eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ALLOC_RUN dependencies on DUAL

Line 119: from dual

115: FROM pa_alloc_rules_all
116: WHERE rule_id = p_rule_id ;
117: cursor c_target_det is
118: select '1'
119: from dual
120: where exists ( select 'Y'
121: from pa_alloc_run_targets
122: where run_id = x_run_id
123: and exclude_flag <> 'Y' ) ;

Line 163: FROM dual;

159: pa_debug.write_file('allocation_run: ' || 'LOG', pa_debug.G_err_stage);
160: END IF;
161: SELECT pa_alloc_runs_s.nextval
162: INTO v_run_id
163: FROM dual;
164: G_alloc_run_id := v_run_id;
165: x_run_id := v_run_id;
166: pa_debug.G_err_stage:= 'INITIALIZING WHO COLUMNS';
167: IF P_DEBUG_MODE = 'Y' THEN

Line 3192: From Dual;

3188: END IF ; -- end of p_rule_id <> -1
3189: If x_alloc_txn_id is Null Then
3190: Select pa_alloc_txn_details_s.nextval
3191: Into x_alloc_txn_id
3192: From Dual;
3193: End If;
3194: INSERT INTO pa_alloc_txn_details (
3195: RUN_ID
3196: , RULE_ID

Line 4310: From dual;

4306: pa_debug.set_err_stack('insert_alloc_runs');
4307: If x_run_id is NULL then
4308: Select pa_alloc_runs_s.nextval
4309: Into x_run_id
4310: From dual;
4311: End If;
4312: INSERT INTO pa_alloc_runs_all (
4313: RUN_ID
4314: , RULE_ID

Line 8927: from dual

8923: END IF;
8924: BEGIN
8925: select 'Y'
8926: into v_do_commit
8927: from dual
8928: where exists
8929: (select null
8930: from pa_alloc_run_targets part
8931: where part.run_id = p_run_id

Line 8976: from dual

8972: END IF;
8973: BEGIN
8974: select 'Y'
8975: into v_do_commit
8976: from dual
8977: where exists
8978: (select null
8979: from pa_alloc_run_targets part
8980: where part.run_id = p_run_id

Line 9031: from dual

9027: END IF;
9028: BEGIN
9029: select 'Y'
9030: into v_do_commit
9031: from dual
9032: where exists
9033: (select null
9034: from pa_alloc_run_targets part
9035: where part.run_id = p_run_id

Line 9082: from dual

9078: END IF;
9079: BEGIN
9080: select 'Y'
9081: into v_do_commit
9082: from dual
9083: where exists
9084: (select null
9085: from pa_alloc_run_targets part
9086: where part.run_id = p_run_id

Line 9134: from dual

9130: END IF;
9131: BEGIN
9132: select 'Y'
9133: into v_do_commit
9134: from dual
9135: where exists
9136: (select null
9137: from pa_alloc_run_targets part
9138: where part.run_id = p_run_id

Line 9184: from dual

9180: END IF;
9181: BEGIN
9182: select 'Y'
9183: into v_do_commit
9184: from dual
9185: where exists
9186: (select null
9187: from pa_alloc_run_targets part
9188: where part.run_id = p_run_id

Line 9238: from dual

9234: END IF;
9235: BEGIN
9236: select 'Y'
9237: into v_do_commit
9238: from dual
9239: where exists
9240: (select null
9241: from pa_alloc_run_targets part
9242: where part.run_id = p_run_id

Line 9281: from dual

9277: );
9278: BEGIN
9279: select 'Y'
9280: into v_do_commit
9281: from dual
9282: where exists
9283: (select null
9284: from pa_alloc_run_targets part
9285: where part.run_id = p_run_id

Line 9655: from dual ;

9651: Commit ;
9652: --- Call import procedure to import the records ------
9653: Select pa_interface_id_s.nextval
9654: into v_interface_id
9655: from dual ;
9656: IF P_DEBUG_MODE = 'Y' THEN
9657: pa_debug.write_file('Release_alloc_txns: ' || 'LOG', 'Calling Transaction Import ..' );
9658: END IF;
9659: /* Adding exception handling for bug 2749043 */

Line 9717: from dual

9713:
9714: BEGIN
9715: select 'Y'
9716: into v_import_failed
9717: from dual
9718: where EXISTS ( select 'exists'
9719: from pa_alloc_txn_details
9720: where run_id = p_run_id
9721: and status_code = 'R' ) ;

Line 10152: FROM dual

10148: RETURN VARCHAR2
10149: IS
10150: CURSOR C_valid_project is
10151: SELECT '1'
10152: FROM dual
10153: WHERE EXISTS (SELECT 'Y'
10154: FROM pa_alloc_src_projects_v ps
10155: WHERE ps.project_id=p_project_id);
10156: v_ret_code varchar2(1) ;

Line 10183: FROM dual

10179: RETURN VARCHAR2
10180: IS
10181: CURSOR C_valid_task is
10182: SELECT '1'
10183: FROM dual
10184: WHERE EXISTS (SELECT 'Y'
10185: FROM pa_alloc_src_tasks_v pt
10186: WHERE pt.project_id=p_project_id
10187: and pt.task_id=p_task_id);

Line 10215: FROM dual

10211: RETURN VARCHAR2
10212: IS
10213: CURSOR C_valid_project is
10214: SELECT '1'
10215: FROM dual
10216: WHERE EXISTS (SELECT 'Y'
10217: FROM pa_alloc_target_proj_v pap
10218: WHERE pap.project_id=p_project_id);
10219: v_ret_code varchar2(1) ;

Line 10246: FROM dual

10242: RETURN VARCHAR2
10243: IS
10244: CURSOR C_valid_task is
10245: SELECT '1'
10246: FROM dual
10247: WHERE EXISTS (SELECT 'Y'
10248: FROM pa_alloc_tgt_tasks_v pt
10249: WHERE pt.project_id=p_project_id
10250: and pt.task_id=p_task_id);

Line 10278: FROM dual

10274: RETURN VARCHAR2
10275: IS
10276: CURSOR C_valid_project is
10277: SELECT '1'
10278: FROM dual
10279: WHERE EXISTS (SELECT 'Y'
10280: FROM pa_alloc_offset_projects_v pap
10281: WHERE pap.project_id=p_project_id);
10282: v_ret_code varchar2(1) ;

Line 10309: FROM dual

10305: RETURN VARCHAR2
10306: IS
10307: CURSOR C_valid_task is
10308: SELECT '1'
10309: FROM dual
10310: WHERE EXISTS (SELECT 'Y'
10311: FROM pa_alloc_tgt_tasks_v pt
10312: WHERE pt.project_id=p_project_id
10313: and pt.task_id=p_task_id);