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 126: ERDL_STMT1 := 'insert into pa_gl_rev_xfer_audit_rep

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

Line 203: rdl_stmt := 'insert into pa_gl_rev_xfer_audit_rep

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

Line 277: rdl_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

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

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

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

Line 371: uer_stmt := 'insert into pa_gl_rev_xfer_audit_rep

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

Line 444: uer_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

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

Line 516: ubr_stmt := 'insert into pa_gl_rev_xfer_audit_rep

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

Line 588: ubr_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

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

Line 660: gain_stmt :='insert into pa_gl_rev_xfer_audit_rep

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

Line 733: gain_stmt1 :='insert into pa_gl_rev_xfer_audit_rep

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

Line 804: loss_stmt :='insert into pa_gl_rev_xfer_audit_rep

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

Line 875: loss_stmt1 :='insert into pa_gl_rev_xfer_audit_rep

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

Line 948: UPDATE pa_gl_rev_xfer_audit_rep a

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

Line 952: DELETE pa_gl_rev_xfer_audit_rep

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

Line 956: UPDATE pa_gl_rev_xfer_audit_rep a

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

Line 962: UPDATE pa_gl_rev_xfer_audit_rep a

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