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 162: FROM dual;

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

Line 3180: From Dual;

3176: END IF ; -- end of p_rule_id <> -1
3177: If x_alloc_txn_id is Null Then
3178: Select pa_alloc_txn_details_s.nextval
3179: Into x_alloc_txn_id
3180: From Dual;
3181: End If;
3182: INSERT INTO pa_alloc_txn_details (
3183: RUN_ID
3184: , RULE_ID

Line 4287: From dual;

4283: pa_debug.set_err_stack('insert_alloc_runs');
4284: If x_run_id is NULL then
4285: Select pa_alloc_runs_s.nextval
4286: Into x_run_id
4287: From dual;
4288: End If;
4289: INSERT INTO pa_alloc_runs_all (
4290: RUN_ID
4291: , RULE_ID

Line 8822: from dual

8818: END IF;
8819: BEGIN
8820: select 'Y'
8821: into v_do_commit
8822: from dual
8823: where exists
8824: (select null
8825: from pa_alloc_run_targets part
8826: where part.run_id = p_run_id

Line 8871: from dual

8867: END IF;
8868: BEGIN
8869: select 'Y'
8870: into v_do_commit
8871: from dual
8872: where exists
8873: (select null
8874: from pa_alloc_run_targets part
8875: where part.run_id = p_run_id

Line 8926: from dual

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

Line 8977: from dual

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

Line 9029: from dual

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

Line 9079: from dual

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

Line 9133: from dual

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

Line 9176: from dual

9172: );
9173: BEGIN
9174: select 'Y'
9175: into v_do_commit
9176: from dual
9177: where exists
9178: (select null
9179: from pa_alloc_run_targets part
9180: where part.run_id = p_run_id

Line 9550: from dual ;

9546: Commit ;
9547: --- Call import procedure to import the records ------
9548: Select pa_interface_id_s.nextval
9549: into v_interface_id
9550: from dual ;
9551: IF P_DEBUG_MODE = 'Y' THEN
9552: pa_debug.write_file('Release_alloc_txns: ' || 'LOG', 'Calling Transaction Import ..' );
9553: END IF;
9554: /* Adding exception handling for bug 2749043 */

Line 9612: from dual

9608:
9609: BEGIN
9610: select 'Y'
9611: into v_import_failed
9612: from dual
9613: where EXISTS ( select 'exists'
9614: from pa_alloc_txn_details
9615: where run_id = p_run_id
9616: and status_code = 'R' ) ;

Line 10047: FROM dual

10043: RETURN VARCHAR2
10044: IS
10045: CURSOR C_valid_project is
10046: SELECT '1'
10047: FROM dual
10048: WHERE EXISTS (SELECT 'Y'
10049: FROM pa_alloc_src_projects_v ps
10050: WHERE ps.project_id=p_project_id);
10051: v_ret_code varchar2(1) ;

Line 10078: FROM dual

10074: RETURN VARCHAR2
10075: IS
10076: CURSOR C_valid_task is
10077: SELECT '1'
10078: FROM dual
10079: WHERE EXISTS (SELECT 'Y'
10080: FROM pa_alloc_src_tasks_v pt
10081: WHERE pt.project_id=p_project_id
10082: and pt.task_id=p_task_id);

Line 10110: FROM dual

10106: RETURN VARCHAR2
10107: IS
10108: CURSOR C_valid_project is
10109: SELECT '1'
10110: FROM dual
10111: WHERE EXISTS (SELECT 'Y'
10112: FROM pa_alloc_target_proj_v pap
10113: WHERE pap.project_id=p_project_id);
10114: v_ret_code varchar2(1) ;

Line 10141: FROM dual

10137: RETURN VARCHAR2
10138: IS
10139: CURSOR C_valid_task is
10140: SELECT '1'
10141: FROM dual
10142: WHERE EXISTS (SELECT 'Y'
10143: FROM pa_alloc_tgt_tasks_v pt
10144: WHERE pt.project_id=p_project_id
10145: and pt.task_id=p_task_id);

Line 10173: FROM dual

10169: RETURN VARCHAR2
10170: IS
10171: CURSOR C_valid_project is
10172: SELECT '1'
10173: FROM dual
10174: WHERE EXISTS (SELECT 'Y'
10175: FROM pa_alloc_offset_projects_v pap
10176: WHERE pap.project_id=p_project_id);
10177: v_ret_code varchar2(1) ;

Line 10204: FROM dual

10200: RETURN VARCHAR2
10201: IS
10202: CURSOR C_valid_task is
10203: SELECT '1'
10204: FROM dual
10205: WHERE EXISTS (SELECT 'Y'
10206: FROM pa_alloc_tgt_tasks_v pt
10207: WHERE pt.project_id=p_project_id
10208: and pt.task_id=p_task_id);