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_GL_REV_XFER_AUDIT_PKG dependencies on PA_GL_REV_XFER_AUDIT_REP

Line 39: delete pa_gl_rev_xfer_audit_rep where request_id = x_request_id;

35: loss_stmt1 VARCHAR2(4000);
36:
37: begin
38:
39: delete pa_gl_rev_xfer_audit_rep where request_id = x_request_id;
40: /* FOR SLA uptake : Removing batch name */
41:
42:
43: /*

Line 47: ERDL_STMT := 'insert into pa_gl_rev_xfer_audit_rep

43: /*
44: Insertion of ERDL Lines
45: =======================
46: */
47: ERDL_STMT := 'insert into pa_gl_rev_xfer_audit_rep
48: (
49: REQUEST_ID,
50: CODE_COMBINATION_ID,
51: LINE_TYPE,

Line 125: ERDL_STMT1 := 'insert into pa_gl_rev_xfer_audit_rep

121: fdbk := DBMS_SQL.EXECUTE (erdl_cur);
122: DBMS_SQL.CLOSE_CURSOR (erdl_cur);
123: COMMIT;
124:
125: ERDL_STMT1 := 'insert into pa_gl_rev_xfer_audit_rep
126: (
127: REQUEST_ID,
128: CODE_COMBINATION_ID,
129: LINE_TYPE,

Line 202: rdl_stmt := 'insert into pa_gl_rev_xfer_audit_rep

198: Insertion of RDL lines
199: ======================
200: */
201:
202: rdl_stmt := 'insert into pa_gl_rev_xfer_audit_rep
203: (
204: REQUEST_ID,
205: CODE_COMBINATION_ID,
206: LINE_TYPE,

Line 275: rdl_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

271: fdbk := DBMS_SQL.EXECUTE (rdl_cur);
272: DBMS_SQL.CLOSE_CURSOR (rdl_cur);
273:
274:
275: rdl_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep
276: (
277: REQUEST_ID,
278: CODE_COMBINATION_ID,
279: LINE_TYPE,

Line 346: update pa_gl_rev_xfer_audit_rep rep set (TRANSACTION_TYPE,TRANSACTION_DATE,TASK_ID,EMP_OR_ORG_NAME) =

342: DBMS_SQL.PARSE (rdl_cur1, rdl_stmt1, DBMS_SQL.NATIVE);
343: fdbk := DBMS_SQL.EXECUTE (rdl_cur1);
344: DBMS_SQL.CLOSE_CURSOR (rdl_cur1);
345:
346: update pa_gl_rev_xfer_audit_rep rep set (TRANSACTION_TYPE,TRANSACTION_DATE,TASK_ID,EMP_OR_ORG_NAME) =
347: (select ei.expenditure_type,ei.expenditure_item_date,ei.task_id,DECODE(emp.full_name, null,org.name, emp.full_name )
348: from hr_organization_units org,
349: per_people_f emp,
350: pa_expenditure_items_all ei,

Line 369: uer_stmt := 'insert into pa_gl_rev_xfer_audit_rep

365: /*
366: Insertion of UER Lines
367: ======================
368: */
369: uer_stmt := 'insert into pa_gl_rev_xfer_audit_rep
370: (
371: REQUEST_ID,
372: CODE_COMBINATION_ID,
373: LINE_TYPE,

Line 442: uer_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

438: DBMS_SQL.CLOSE_CURSOR (uer_cur);
439: COMMIT;
440:
441:
442: uer_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep
443: (
444: REQUEST_ID,
445: CODE_COMBINATION_ID,
446: LINE_TYPE,

Line 514: ubr_stmt := 'insert into pa_gl_rev_xfer_audit_rep

510: /*
511: Insertion of UBR Lines
512: ======================
513: */
514: ubr_stmt := 'insert into pa_gl_rev_xfer_audit_rep
515: (
516: REQUEST_ID,
517: CODE_COMBINATION_ID,
518: LINE_TYPE,

Line 586: ubr_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

582: DBMS_SQL.CLOSE_CURSOR (ubr_cur);
583: COMMIT;
584:
585:
586: ubr_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep
587: (
588: REQUEST_ID,
589: CODE_COMBINATION_ID,
590: LINE_TYPE,

Line 658: gain_stmt :='insert into pa_gl_rev_xfer_audit_rep

654: /*
655: Insertion of RLZD-GAIN lines
656: ============================
657: */
658: gain_stmt :='insert into pa_gl_rev_xfer_audit_rep
659: (
660: REQUEST_ID,
661: CODE_COMBINATION_ID,
662: LINE_TYPE,

Line 731: gain_stmt1 :='insert into pa_gl_rev_xfer_audit_rep

727: COMMIT;
728:
729:
730:
731: gain_stmt1 :='insert into pa_gl_rev_xfer_audit_rep
732: (
733: REQUEST_ID,
734: CODE_COMBINATION_ID,
735: LINE_TYPE,

Line 802: loss_stmt :='insert into pa_gl_rev_xfer_audit_rep

798: /*
799: Insertion of RLZD-LOSS lines
800: ============================
801: */
802: loss_stmt :='insert into pa_gl_rev_xfer_audit_rep
803: (
804: REQUEST_ID,
805: CODE_COMBINATION_ID,
806: LINE_TYPE,

Line 873: loss_stmt1 :='insert into pa_gl_rev_xfer_audit_rep

869: fdbk := DBMS_SQL.EXECUTE (loss_cur);
870: DBMS_SQL.CLOSE_CURSOR (loss_cur);
871: COMMIT;
872:
873: loss_stmt1 :='insert into pa_gl_rev_xfer_audit_rep
874: (
875: REQUEST_ID,
876: CODE_COMBINATION_ID,
877: LINE_TYPE,

Line 946: UPDATE pa_gl_rev_xfer_audit_rep a

942: Summary updation
943: =================
944: */
945:
946: UPDATE pa_gl_rev_xfer_audit_rep a
947: SET project_number = (SELECT p.segment1 FROM pa_projects p WHERE p.project_id = a.project_id)
948: WHERE request_id = x_request_id;
949:
950: DELETE pa_gl_rev_xfer_audit_rep

Line 950: DELETE pa_gl_rev_xfer_audit_rep

946: UPDATE pa_gl_rev_xfer_audit_rep a
947: SET project_number = (SELECT p.segment1 FROM pa_projects p WHERE p.project_id = a.project_id)
948: WHERE request_id = x_request_id;
949:
950: DELETE pa_gl_rev_xfer_audit_rep
951: WHERE request_id = x_request_id
952: AND project_number IS NULL;
953:
954: UPDATE pa_gl_rev_xfer_audit_rep a

Line 954: UPDATE pa_gl_rev_xfer_audit_rep a

950: DELETE pa_gl_rev_xfer_audit_rep
951: WHERE request_id = x_request_id
952: AND project_number IS NULL;
953:
954: UPDATE pa_gl_rev_xfer_audit_rep a
955: SET task_number = (SELECT t.task_number FROM pa_tasks t WHERE t.task_id=a.task_id)
956: WHERE task_id IS NOT NULL
957: AND request_id = x_request_id;
958:

Line 960: UPDATE pa_gl_rev_xfer_audit_rep a

956: WHERE task_id IS NOT NULL
957: AND request_id = x_request_id;
958:
959:
960: UPDATE pa_gl_rev_xfer_audit_rep a
961: SET (transaction_type,transaction_date) = ( SELECT event_type,completion_date
962: FROM pa_events pe
963: WHERE a.project_id = pe.project_id
964: AND NVL(a.task_id,-1) = NVL(pe.task_id,-1)