*Obtain:
1. Birth Certificate
http://www.india.gov.in/howdo/howdoi.php?service=1
2. Caste Certificate
http://www.india.gov.in/howdo/howdoi.php?service=4
3. Tribe Certificate
http://www.india.gov.in/howdo/otherservice_details.php?service=8
4. Domicile Certificate
http://www.india.gov.in/howdo/howdoi.php?service=5
5. Driving Licence
http://www.india.gov.in/howdo/howdoi.php?service=6
6. Marriage Certificate
http://www.india.gov.in/howdo/howdoi.php?service=3
7. Death Certificate
http://www.india.gov.in/howdo/howdoi.php?service=2
Apply for:
1. PAN Card
http://www.india.gov.in/howdo/otherservice_details.php?service=15
2. TAN Card
http://www.india.gov.in/howdo/otherservice_details.php?service=3
3. Ration Card
http://www.india.gov.in/howdo/howdoi.php?service=7
4. Passport
http://www.india.gov.in/howdo/otherservice_details.php?service=2
5. Inclusion of name in the Electoral Rolls
http://www.india.gov.in/howdo/howdoi.php?service=10
Register:
1. Land/Property
http://www.india.gov.in/howdo/howdoi.php?service=9
2. Vehicle
http://www.india.gov.in/howdo/howdoi.php?service=13
3. With State Employment Exchange
http://www.india.gov.in/howdo/howdoi.php?service=12
4. As Employer
http://www.india.gov.in/howdo/otherservice_details.php?service=17
5. Company
http://www.india.gov.in/howdo/otherservice_details.php?service=19
6. .IN Domain
http://www.india.gov.in/howdo/otherservice_details.php?service=18
7. GOV.IN Domain
http://www.india.gov.in/howdo/otherservice_details.php?service=25
Check/Track:
1. Waiting list status for Central Government Housing
http://www.india.gov.in/howdo/otherservice_details.php?service=9
2. Status of Stolen Vehicles
http://www.india.gov.in/howdo/otherservice_details.php?service=1
3. Land Records
http://www.india.gov.in/landrecords/index.php
4. Cause list of Indian Courts
http://www.india.gov.in/howdo/otherservice_details.php?service=7
5. Court Judgments (JUDIS )
http://www.india.gov.in/howdo/otherservice_details.php?service=24
6. Daily Court Orders/Case Status
http://www.india.gov.in/howdo/otherservice_details.php?service=21
7. Acts of Indian Parliament
http://www.india.gov.in/howdo/otherservice_details.php?service=13
8. Exam Results
http://www.india.gov.in/howdo/otherservice_details.php?service=16
9. Speed Post Status
http://www.india.gov.in/howdo/otherservice_details.php?service=10
10. Agricultural Market Prices Online
http://www.india.gov.in/howdo/otherservice_details.php?service=6
Book/File/Lodge:
1. Train Tickets Online
http://www.india.gov.in/howdo/otherservice_details.php?service=5
2. Air Tickets Online
http://www.india.gov.in/howdo/otherservice_details.php?service=4
3. Income Tax Returns
http://www.india.gov.in/howdo/otherservice_details.php?service=12
4. Complaint with Central Vigilance Commission (CVC)
http://www.india.gov.in/howdo/otherservice_details.php?service=14
Contribute to:
1. Prime Minister's Relief Fund
http://www.india.gov.in/howdo/otherservice_details.php?service=11
Others:
1. Send Letters Electronically
http://www.india.gov.in/howdo/otherservice_details.php?service=20
Global Navigation
1. Citizens
http://www.india.gov.in/citizen.php
2. Business (External website that opens in a new window)
http://business.gov.in/
3. Overseas
http://www.india.gov.in/overseas.php
4. Government
http://www.india.gov.in/govtphp
5. Know India
http://www.india.gov.in/knowindia.php
6. Sectors
http://www.india.gov.in/sector.php
7. Directories
http://www.india.gov.in/directories.php
8. Documents
http://www.india.gov.in/documents.php
9. Forms
http://www.india.gov.in/forms/forms.php
10. Acts
http://www.india.gov.in/govt/acts.php
11. Rules
http://www.india.gov.in/govtmoo/rules.php
30 January 2015
06 January 2015
SQL to fetch the SMTP server details from Workflow Setup
SQL to fetch the SMTP server details from Workflow Setup
select fscpv.parameter_value smtp_server_name,fscpt.display_name
from fnd_svc_comp_params_tl fscpt
, fnd_svc_comp_param_vals fscpv
, fnd_svc_components fsc
where fscpt.parameter_id = fscpv.parameter_id
and fscpv.component_id = fsc.component_id
and fscpt.display_name = 'Outbound Server Name'
and fsc.component_name = 'Workflow Notification Mailer'
select fscpv.parameter_value smtp_server_name,fscpt.display_name
from fnd_svc_comp_params_tl fscpt
, fnd_svc_comp_param_vals fscpv
, fnd_svc_components fsc
where fscpt.parameter_id = fscpv.parameter_id
and fscpv.component_id = fsc.component_id
and fscpt.display_name = 'Outbound Server Name'
and fsc.component_name = 'Workflow Notification Mailer'
09 October 2014
How to delete XML Templete in oracle R12
Use the following code to delete a Template Code
declare
l_templateCode varchar2 (100) :=; -- Template Code
begin
for r in (select t1.application_short_name template_app_name,
t1.data_source_code,
t1.application_short_name def_app_name
from xdo_templates_b t1
where t1.template_code = l_templateCode)
loop
xdo_templates_pkg.delete_row (r.template_app_name, l_templateCode);
delete from xdo_lobs
where lob_code = l_templateCode
and application_short_name = r.template_app_name
and lob_type in ('TEMPLATE_SOURCE', 'TEMPLATE');
delete from xdo_config_values
where application_short_name = r.template_app_name
and template_code = l_templateCode
and data_source_code = r.data_source_code
and config_level = 50;
end loop;
end;
declare
l_templateCode varchar2 (100) :=
begin
for r in (select t1.application_short_name template_app_name,
t1.data_source_code,
t1.application_short_name def_app_name
from xdo_templates_b t1
where t1.template_code = l_templateCode)
loop
xdo_templates_pkg.delete_row (r.template_app_name, l_templateCode);
delete from xdo_lobs
where lob_code = l_templateCode
and application_short_name = r.template_app_name
and lob_type in ('TEMPLATE_SOURCE', 'TEMPLATE');
delete from xdo_config_values
where application_short_name = r.template_app_name
and template_code = l_templateCode
and data_source_code = r.data_source_code
and config_level = 50;
end loop;
end;
18 September 2014
How do I re-enable PST usage on an Outlook Client
How do I re-enable PST usage on an Outlook Client
1) Click Start, and then click Run.
2) In the Open box, type regedit, and then click OK.
3) Locate one of the following keys in the registry, as applicable:
For Outlook 98:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\8.0\Outlook\
For Outlook 2000:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Outlook\
On the Edit menu, click Add Value, and then add the following registry value:
Value Name: DisablePst
Data Type: REG_DWORD
Value: 1 -- To disable/0 - enable
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q258277
1) Click Start, and then click Run.
2) In the Open box, type regedit, and then click OK.
3) Locate one of the following keys in the registry, as applicable:
For Outlook 98:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\8.0\Outlook\
For Outlook 2000:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Outlook\
On the Edit menu, click Add Value, and then add the following registry value:
Value Name: DisablePst
Data Type: REG_DWORD
Value: 1 -- To disable/0 - enable
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q258277
19 August 2014
Oracle dbms_scheduler
Starting with 10g offers a brand new job-scheduling facility, known as The Scheduler, controlled via the new package dbms_scheduler. This package replaces the dbms_job (but that one is still available). The new scheduler offers more functionality over the dbms_job package.
CREATE TABLE KTEST
(
X NUMBER,
Y NUMBER
);
CREATE SEQUENCE ktest_s
START WITH 1;
CREATE OR REPLACE PROCEDURE KPRO (PX IN NUMBER, PY NUMBER)
AS
BEGIN
INSERT INTO KTEST
VALUES (PX, PY);
DBMS_LOCK.SLEEP (60);
COMMIT;
END KPRO;
BEGIN
DBMS_SCHEDULER.create_program (
program_name => 'TEST_STORED_PROCEDURE_PROG',
program_type => 'STORED_PROCEDURE',
program_action => 'KPRO',
number_of_arguments => 2,
enabled => FALSE,
comments => 'SOA Invoke Program');
DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT (
program_name => 'TEST_STORED_PROCEDURE_PROG',
argument_position => 1,
argument_type => 'NUMBER',
DEFAULT_VALUE => '1');
DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT (
program_name => 'TEST_STORED_PROCEDURE_PROG',
argument_position => 2,
argument_type => 'NUMBER',
DEFAULT_VALUE => '2');
DBMS_SCHEDULER.enable ('TEST_STORED_PROCEDURE_PROG');
END;
CREATE OR REPLACE PROCEDURE SOA_INVOKE (px IN VARCHAR2, py IN VARCHAR2)
AS
ljob_id NUMBER;
ljob VARCHAR2 (100);
BEGIN
ljob_id := ktest_s.NEXTVAL;
ljob := 'RequestID_' || ljob_id;
DBMS_SCHEDULER.create_job (ljob,
program_name => 'TEST_STORED_PROCEDURE_PROG');
DBMS_SCHEDULER.set_job_argument_value (ljob, 1, px);
DBMS_SCHEDULER.set_job_argument_value (ljob, 2, px);
DBMS_SCHEDULER.enable (ljob);
DBMS_OUTPUT.put_line ('Job ID : ' || ljob);
END;
EXECUTE SOA_INVOKE(1,2);
SELECT *
FROM ALL_SCHEDULER_RUNNING_JOBS
WHERE job_name = :1
|
|
References
http://www.pafumi.net/Scheduler_DBMS_SCHEDULER.html
http://dba.stackexchange.com/questions/42119/passing-parameters-to-a-procedure-executed-by-dbms-scheduler
|
|
04 August 2014
Wait for concurrent request using fnd_concurrent.wait_for_request
Most of the times while submitting concurrent request one has to wait for its completion to perform sequence of steps. This can be achieved through fnd_concurrent.wait_for_request in oracle apps. It returns the status of the previously submitted concurrent program upon interval set.
This is a conjunction to the SUBMIT_REQUEST. Follow ARTICLE on submitting concurrent program and use below call upon completed. There are some parameter that has to be declared.
lb_complete BOOLEAN;
lc_phase VARCHAR2 (100);
lc_status VARCHAR2 (100);
lc_dev_phase VARCHAR2 (100);
lc_dev_status VARCHAR2 (100);
lc_message VARCHAR2 (100);
ln_request_id is return variable for concurrent_request_id from above article. If ln_request_id > 0 (means request submitted successfully) then wait_for_request.
Arguments (input)
request_id - Request ID to wait on
interval - time b/w checks. Number of seconds to sleep (default 60 seconds)
max_wait - Max amount of time to wait (in seconds) for request's completion
Arguments (output)
User version of phase and status
Developer version of phase and status
Completion text if any
phase - Request phase ( from meaning in fnd_lookups )
status - Request status( for display purposes )
dev_phase - Request phase as a constant string so that it can be used for comparisons
dev_status - Request status as a constatnt string
message - Completion message if request has completed
IF ln_request_id > 0
THEN
lb_complete :=
fnd_concurrent.wait_for_request (request_id => ln_request_id
,interval => 2
,max_wait => 60
-- out arguments
,phase => lc_phase
,status => lc_status
,dev_phase => lc_dev_phase
,dev_status => lc_dev_status
,message => lc_message
);
COMMIT;
IF UPPER (lc_dev_phase) IN ('COMPLETE')
THEN
dbms_output.put_line('Concurrent request completed successfully');
END IF;
END IF;
30 July 2014
Oracle PIVOT function sample script
ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';
SELECT job
, deptno
, SUM(sal) AS sum_sal
FROM emp
GROUP BY
job
, deptno
ORDER BY
job
, deptno;
WITH pivot_data AS (
SELECT deptno, job, sal
FROM emp
)
SELECT *
FROM pivot_data
PIVOT (
SUM(sal) --<-- p="" pivot_clause=""> FOR deptno --<-- p="" pivot_for_clause=""> IN (10,20,30,40) --<-- p="" pivot_in_clause=""> );
SELECT *
FROM emp
PIVOT (SUM(sal)
FOR deptno IN (10,20,30,40));
WITH pivot_data AS (
SELECT deptno, job, sal
FROM emp
)
SELECT *
FROM pivot_data
PIVOT (
SUM(sal) --<-- p="" pivot_clause=""> FOR deptno --<-- p="" pivot_for_clause=""> IN (10,20,30,40) --<-- p="" pivot_in_clause=""> )
WHERE job IN ('ANALYST','CLERK','SALESMAN');
SELECT *
FROM (
SELECT deptno, job, sal
FROM emp
)
PIVOT (SUM(sal)
FOR deptno IN (10,20,30,40));-->-->-->-->-->-->
set echo on
SELECT *
FROM pivot_data
PIVOT (SUM(sal) AS salaries
FOR deptno IN (10, 20, 30, 40));
SELECT *
FROM pivot_data
PIVOT (SUM(sal) AS salaries
FOR deptno IN (10 AS d10_sal,
20 AS d20_sal,
30 AS d30_sal,
40 AS d40_sal));
SELECT *
FROM pivot_data
PIVOT (SUM(sal)
FOR deptno IN (10 AS d10_sal,
20 AS d20_sal,
30 AS d30_sal,
40 AS d40_sal));
SELECT *
FROM pivot_data
PIVOT (SUM(sal)
FOR deptno IN (10 AS d10_sal,
20,
30 AS d30_sal,
40));
SELECT *
FROM pivot_data
PIVOT (SUM(sal) AS sum
, COUNT(sal) AS cnt
FOR deptno IN (10 AS d10_sal,
20 AS d20_sal,
30 AS d30_sal,
40 AS d40_sal));
SELECT *
FROM pivot_data
PIVOT (SUM(sal) AS sum
, COUNT(sal) AS cnt
FOR (deptno,job) IN ((30, 'SALESMAN') AS d30_sls,
(30, 'MANAGER') AS d30_mgr,
(30, 'CLERK') AS d30_clk));
SELECT d30_mgr_sum
, d30_clk_cnt
FROM pivot_data
PIVOT (SUM(sal) AS sum
, COUNT(sal) AS cnt
FOR (deptno,job) IN ((30, 'SALESMAN') AS d30_sls,
(30, 'MANAGER') AS d30_mgr,
(30, 'CLERK') AS d30_clk));
SELECT job
, deptno
, SUM(sal) AS sum_sal
FROM emp
GROUP BY
job
, deptno
ORDER BY
job
, deptno;
WITH pivot_data AS (
SELECT deptno, job, sal
FROM emp
)
SELECT *
FROM pivot_data
PIVOT (
SUM(sal) --<-- p="" pivot_clause=""> FOR deptno --<-- p="" pivot_for_clause=""> IN (10,20,30,40) --<-- p="" pivot_in_clause=""> );
SELECT *
FROM emp
PIVOT (SUM(sal)
FOR deptno IN (10,20,30,40));
WITH pivot_data AS (
SELECT deptno, job, sal
FROM emp
)
SELECT *
FROM pivot_data
PIVOT (
SUM(sal) --<-- p="" pivot_clause=""> FOR deptno --<-- p="" pivot_for_clause=""> IN (10,20,30,40) --<-- p="" pivot_in_clause=""> )
WHERE job IN ('ANALYST','CLERK','SALESMAN');
SELECT *
FROM (
SELECT deptno, job, sal
FROM emp
)
PIVOT (SUM(sal)
FOR deptno IN (10,20,30,40));-->-->-->-->-->-->
set echo on
SELECT *
FROM pivot_data
PIVOT (SUM(sal) AS salaries
FOR deptno IN (10, 20, 30, 40));
SELECT *
FROM pivot_data
PIVOT (SUM(sal) AS salaries
FOR deptno IN (10 AS d10_sal,
20 AS d20_sal,
30 AS d30_sal,
40 AS d40_sal));
SELECT *
FROM pivot_data
PIVOT (SUM(sal)
FOR deptno IN (10 AS d10_sal,
20 AS d20_sal,
30 AS d30_sal,
40 AS d40_sal));
SELECT *
FROM pivot_data
PIVOT (SUM(sal)
FOR deptno IN (10 AS d10_sal,
20,
30 AS d30_sal,
40));
SELECT *
FROM pivot_data
PIVOT (SUM(sal) AS sum
, COUNT(sal) AS cnt
FOR deptno IN (10 AS d10_sal,
20 AS d20_sal,
30 AS d30_sal,
40 AS d40_sal));
SELECT *
FROM pivot_data
PIVOT (SUM(sal) AS sum
, COUNT(sal) AS cnt
FOR (deptno,job) IN ((30, 'SALESMAN') AS d30_sls,
(30, 'MANAGER') AS d30_mgr,
(30, 'CLERK') AS d30_clk));
SELECT d30_mgr_sum
, d30_clk_cnt
FROM pivot_data
PIVOT (SUM(sal) AS sum
, COUNT(sal) AS cnt
FOR (deptno,job) IN ((30, 'SALESMAN') AS d30_sls,
(30, 'MANAGER') AS d30_mgr,
(30, 'CLERK') AS d30_clk));
Subscribe to:
Posts (Atom)