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.GMS_AP_API dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 5: P_invoice_id Invoice_id for AP_invoice_distributions_all

1: PACKAGE BODY GMS_AP_API AS
2: -- $Header: gmsapx1b.pls 120.3.12020000.2 2012/10/16 13:49:11 navemish ship $
3:
4: /* Declare procedure GMS_AP_ER_HEADERS_AUT1
5: P_invoice_id Invoice_id for AP_invoice_distributions_all
6: p_report_header_id Ap_expense_report_headers ID
7: p_reject_code Rejection identifier
8: */
9: -- For Bug 3269365: To check on, whether to print debug messages in log file or not

Line 43: ap_invoice_distributions_all apd,

39: erl.distribution_line_number distribution_line_number,
40: apd.invoice_distribution_id invoice_distribution_id,
41: apd.award_id award_set_id
42: from ap_expense_report_lines_all erl,
43: ap_invoice_distributions_all apd,
44: pa_projects_all p,
45: gms_project_types gpt
46: where report_header_id = X_report_header_id
47: and erl.distribution_line_number= apd.distribution_line_number

Line 126: update ap_invoice_distributions_all

122: END IF ;
123:
124: gms_awards_dist_pkg.create_adls(x_adl_rec) ;
125:
126: update ap_invoice_distributions_all
127: set award_id = X_adl_rec.award_set_id
128: where invoice_id = X_invoice_id
129: and distribution_line_number = X_adl_rec.distribution_line_number
130:

Line 337: from ap_invoice_distributions_all A,

333: A.creation_date CREATION_DATE,
334: A.last_updated_by LAST_UPDATED_BY,
335: A.created_by CREATED_BY,
336: A.last_update_login LAST_UPDATE_LOGIN
337: from ap_invoice_distributions_all A,
338: pa_projects_all B,
339: gms_project_types C
340: where invoice_id = p_invoice_id
341: and distribution_line_number = p_distribution_line_number

Line 394: update ap_invoice_distributions_all

390: l_adl_rec.last_updated_by := loop_ap_rec.last_updated_by ;
391: l_adl_rec.created_by := loop_ap_rec.created_by ;
392: l_adl_rec.last_update_login := loop_ap_rec.last_update_login ;
393: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;
394: update ap_invoice_distributions_all
395: set award_id = l_adl_rec.award_set_id
396: where invoice_id = loop_ap_rec.invoice_id
397: and distribution_line_number = loop_ap_rec.distribution_line_number
398: and invoice_distribution_id = loop_ap_rec.invoice_distribution_id ;

Line 419: update ap_invoice_distributions_all

415: l_adl_rec.invoice_distribution_id := p_invoice_distribution_id ;
416: l_adl_rec.document_type := 'AP' ;
417: l_adl_rec.line_type := 'R' ;
418: gms_awards_dist_pkg.create_adls( l_adl_rec ) ;
419: update ap_invoice_distributions_all
420: set award_id = l_adl_rec.award_set_id
421: where invoice_id = p_invoice_id
422: and distribution_line_number = p_distribution_line_number
423:

Line 565: x_ap_rec ap_invoice_distributions_all%ROWTYPE ;

561: p_invoice_distribution_id IN NUMBER
562: ) is
563: X_award_set_id NUMBER ;
564: x_adl_rec gms_award_distributions%ROWTYPE ;
565: x_ap_rec ap_invoice_distributions_all%ROWTYPE ;
566:
567: x_inv_dist_id NUMBER ;
568: X_amount NUMBER ;
569: Cursor C_get_adl_id is

Line 571: from ap_invoice_distributions_all

567: x_inv_dist_id NUMBER ;
568: X_amount NUMBER ;
569: Cursor C_get_adl_id is
570: select award_id
571: from ap_invoice_distributions_all
572: where Invoice_distribution_id = p_prepay_dist_id
573: union /* BUG 14216205 : Added the union for SAT */
574: select award_id
575: from AP_SELF_ASSESSED_TAX_DIST_ALL

Line 585: from ap_invoice_distributions_all

581: where award_set_id = X_award_set_id
582: and adl_line_num = 1 ;
583: Cursor c_new_dist_line is
584: select *
585: from ap_invoice_distributions_all
586: where invoice_id = p_invoice_id
587: and distribution_line_number = p_next_dist_line_num
588: and invoice_distribution_id = p_invoice_distribution_id; -- AP Line change: added additional join
589: BEGIN

Line 632: Update ap_invoice_distributions_all

628: UPDATE GMS_AWARD_DISTRIBUTIONS
629: SET BUD_TASK_ID = x_adl_rec.BUD_TASK_ID
630: WHERE AWARD_SET_ID = x_adl_rec.award_set_id
631: AND ADL_STATUS = 'A' ;
632: Update ap_invoice_distributions_all
633: Set award_id = x_adl_rec.award_set_id
634: Where invoice_distribution_id = x_inv_dist_id ;
635: /* BUG 14216205 : Added the following Code for SAT : Starts */
636: Update AP_SELF_ASSESSED_TAX_DIST_ALL

Line 831: from ap_invoice_distributions_all A,

827: A.last_updated_by LAST_UPDATED_BY,
828: A.created_by CREATED_BY,
829: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
830: inv.invoice_num invoice_num
831: from ap_invoice_distributions_all A,
832: pa_projects_all p,
833: gms_project_types gpt,
834: ap_invoices_all inv
835: where a.invoice_id = p_invoice_id

Line 848: from ap_invoice_distributions_all A,

844: l_adl_rec c_adl%ROWTYPE ;
845:
846: cursor c2 is
847: SELECT 1
848: from ap_invoice_distributions_all A,
849: pa_projects_all p,
850: gms_project_types gpt
851: where a.invoice_id = p_invoice_id
852: and a.project_id = p.project_id

Line 910: from ap_invoice_distributions_all A,

906: l_last_updated_by ,
907: l_created_by ,
908: l_last_update_login ,
909: l_new_award_set_id
910: from ap_invoice_distributions_all A,
911: gms_award_distributions adl
912: where a.invoice_id = p_invoice_id
913: and adl.award_set_id = a.award_id
914: and adl.adl_line_num = 1

Line 929: ap_invoice_distributions_all apd

925: where adl.document_type = 'AP'
926: and adl.adl_status = 'I'
927: and adl.award_set_id in ( select adl2.award_set_id
928: from gms_award_distributions adl2,
929: ap_invoice_distributions_all apd
930: where apd.invoice_id = p_invoice_id
931: and apd.award_id is not null
932: and adl2.award_set_id = apd.award_id
933: and adl2.invoice_id = apd.invoice_id

Line 949: ap_invoice_distributions_all apd

945: where adl.document_type = 'AP'
946: and adl.adl_status = 'A'
947: and adl.award_set_id in ( select adl2.award_set_id
948: from gms_award_distributions adl2,
949: ap_invoice_distributions_all apd
950: where apd.invoice_id = p_invoice_id
951: and apd.award_id is not null
952: and adl2.award_set_id <> apd.award_id
953: and adl2.invoice_id = apd.invoice_id

Line 967: -- UPDATE ap_invoice_distributions_all apd

963: -- =================================================
964: -- Bug : 4956860
965: -- R12.PJ:XB2:DEV:GMS: APPSPERF: PACKAGE:GMSAPX1B.PLS
966: --
967: -- UPDATE ap_invoice_distributions_all apd
968: -- SET award_id = NULL
969: -- where apd.invoice_id = p_invoice_id
970: -- and apd.award_id is not NULL
971: -- and apd.invoice_distribution_id in ( select a.invoice_distribution_id

Line 972: -- from ap_invoice_distributions_all A,

968: -- SET award_id = NULL
969: -- where apd.invoice_id = p_invoice_id
970: -- and apd.award_id is not NULL
971: -- and apd.invoice_distribution_id in ( select a.invoice_distribution_id
972: -- from ap_invoice_distributions_all A,
973: -- pa_projects_all p,
974: -- gms_project_types gpt
975: -- where a.invoice_id = p_invoice_id
976: -- and a.project_id = p.project_id

Line 985: from ap_invoice_distributions_all A,

981: ** Update statement was changed to bulk statement to resolve the share memory performance issue.
982: */
983: select a.invoice_distribution_id
984: bulk collect into l_dummy_tab
985: from ap_invoice_distributions_all A,
986: pa_projects_all p,
987: gms_project_types gpt
988: where a.invoice_id = p_invoice_id
989: and a.project_id = p.project_id

Line 997: UPDATE ap_invoice_distributions_all apd

993:
994: IF l_dummy_tab.count > 0 THEN
995:
996: FORALL i in l_dummy_tab.FIRST..l_dummy_tab.LAST
997: UPDATE ap_invoice_distributions_all apd
998: SET award_id = NULL
999: where apd.invoice_id = p_invoice_id
1000: and apd.invoice_distribution_id = l_dummy_tab(i) ;
1001:

Line 1127: update ap_invoice_distributions_all

1123: -- Update AP distribution with the award set id.
1124: -- End of comment.
1125:
1126: FORALL k in l_invoice_distribution_id.FIRST..l_invoice_distribution_id.LAST
1127: update ap_invoice_distributions_all
1128: set award_id = l_new_award_set_id(k)
1129: where invoice_id = l_invoice_id(k)
1130: and distribution_line_number = l_distribution_line_number(k)
1131: and invoice_distribution_id = l_invoice_distribution_id(k) ;