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 GMS_AWARD_DISTRIBUTIONS

Line 20: X_ADL_REC GMS_AWARD_DISTRIBUTIONS%ROWTYPE ;

16:
17: X_expenditure_item_id NUMBER ;
18: X_cdl_line_num NUMBER ;
19: X_award_set_id NUMBER ;
20: X_ADL_REC GMS_AWARD_DISTRIBUTIONS%ROWTYPE ;
21: X_invoice_id NUMBER ;
22: X_invoice_dist_id NUMBER ;
23: X_report_header_id NUMBER ;
24: X_reject_code Varchar2(25) ;

Line 28: from gms_award_distributions adl

24: X_reject_code Varchar2(25) ;
25:
26: CURSOR C_ADL is
27: select *
28: from gms_award_distributions adl
29: where expenditure_item_id = x_expenditure_item_id
30: and cdl_line_num = x_cdl_line_num
31: and document_type = 'EXP'
32: and adl_status = 'A' ;

Line 111: update gms_award_distributions

107:
108: IF c_er_rec.award_set_id is Not NULL OR
109: NVL(X_reject_code, 'X' ) <> 'X' THEN
110:
111: update gms_award_distributions
112: set adl_status = 'I'
113: where award_set_id = NVL(c_er_rec.award_set_id,0)
114:
115:

Line 238: l_adl_rec gms_award_distributions%ROWTYPE ;

234: IS
235: lb_return BOOLEAN ;
236: l_output varchar2(2000) ;
237: l_award_set_id NUMBER ;
238: l_adl_rec gms_award_distributions%ROWTYPE ;
239: BEGIN
240: lb_return := TRUE ;
241: -- IF NOT gms_install.enabled THEN -- Bug 3002305.
242: IF NOT gms_pa_api.vert_install THEN

Line 287: delete from gms_award_distributions

283: p_award_id := l_award_set_id ;
284: END IF ;
285:
286: ELSIF P_EVENT = 'AWARD_SET_ID_REMOVE' THEN
287: delete from gms_award_distributions
288: where award_set_id = p_award_id
289: and adl_line_num = 1
290: and document_type = 'OPI' ;
291: END IF ;

Line 321: from gms_award_distributions ADL

317: p_dist_set_line_number IN NUMBER default NULL
318: ) is
319: CURSOR C_ADL_REC is
320: SELECT *
321: from gms_award_distributions ADL
322: where award_set_id = p_award_id
323: and adl_status = 'A'
324: and adl_line_num = 1 -- AP Lines uptake
325: and document_type= 'APD' ;

Line 368: l_adl_rec gms_award_distributions%ROWTYPE ;

364: and a.line_type_lookup_code = 'NONREC_TAX'
365: and B.PROJECT_TYPE = C.PROJECT_TYPE
366: and c.sponsored_flag = 'Y' ;
367: l_ap_rec c_ap_rec%ROWTYPE ;
368: l_adl_rec gms_award_distributions%ROWTYPE ;
369: BEGIN
370: -- IF NOT gms_install.enabled THEN -- Bug 3002305
371: IF NOT gms_pa_api.vert_install THEN
372: return ;

Line 481: from gms_award_distributions ADL

477: l_award_id NUMBER ;
478:
479: CURSOR C_ADL_REC is
480: select award_id
481: from gms_award_distributions ADL
482: where award_set_id = p_award_set_id
483: and adl_line_num = 1 ;
484:
485: --and document_type = 'AP'

Line 564: x_adl_rec gms_award_distributions%ROWTYPE ;

560: p_next_dist_line_num IN NUMBER,
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 ;

Line 580: from gms_award_distributions

576: where INVOICE_DISTRIBUTION_ID = P_PREPAY_DIST_ID
577: AND LINE_TYPE_LOOKUP_CODE='NONREC_TAX';
578: Cursor C_adl is
579: select *
580: from gms_award_distributions
581: where award_set_id = X_award_set_id
582: and adl_line_num = 1 ;
583: Cursor c_new_dist_line is
584: select *

Line 628: UPDATE GMS_AWARD_DISTRIBUTIONS

624: -- =====================================================
625: x_adl_rec.fc_status := 'N' ;
626: x_adl_rec.burdenable_raw_cost := 0 ;
627: gms_awardS_dist_pkg.create_adls( X_adl_rec) ;
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

Line 657: gms_award_distributions adl

653: p_award_id IN OUT NOCOPY NUMBER ) is
654: cursor c_get_award is
655: select adl.award_id
656: from ap_distribution_set_lines apd,
657: gms_award_distributions adl
658: where apd.distribution_set_id = p_distribution_set_id
659: and apd.distribution_set_line_number = p_distribution_set_line_number
660: and adl.award_set_id = p_award_set_id
661: and apd.award_id = adl.award_set_id

Line 842: select * from gms_award_distributions where award_set_id = l_award_set_idX

838: and inv.invoice_id = a.invoice_id
839: and gpt.sponsored_flag = 'Y' ;
840:
841: cursor c_adl is
842: select * from gms_award_distributions where award_set_id = l_award_set_idX
843: and adl_line_num = 1 ;
844: l_adl_rec c_adl%ROWTYPE ;
845:
846: cursor c2 is

Line 855: and not exists ( select 1 from gms_award_distributions adl

851: where a.invoice_id = p_invoice_id
852: and a.project_id = p.project_id
853: and p.project_type = gpt.project_type
854: and gpt.sponsored_flag = 'Y'
855: and not exists ( select 1 from gms_award_distributions adl
856: where adl.invoice_id = p_invoice_id
857: and adl.distribution_line_number = A.distribution_line_number
858: and adl.invoice_distribution_id = A.invoice_distribution_id -- AP Lines uptake
859: and adl.document_type = 'AP'

Line 911: gms_award_distributions adl

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
915: and a.award_id IS NOT NULL;

Line 923: update gms_award_distributions adl

919: IF NVL(SUBSTR(p_calling_sequence, 1,15),'X') = 'AP_APPROVAL_PKG' THEN
920: l_count := 0 ;
921:
922: -- 2308005 ( CLEARING INVOICE DIST. LINE AFTER CHANGING AWARD MAKES ADL STATUS 'I' )
923: update gms_award_distributions adl
924: set adl.adl_status = 'A'
925: where adl.document_type = 'AP'
926: and adl.adl_status = 'I'
927: and adl.award_set_id in ( select adl2.award_set_id

Line 928: from gms_award_distributions adl2,

924: set adl.adl_status = 'A'
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

Line 943: update gms_award_distributions adl

939: -- Inactivate ADLS that belongs to the AP distribution line but
940: -- not tied up with award_id in ap_distribution line.
941: -- Inactivate dangling active adls.
942: -- ----
943: update gms_award_distributions adl
944: set adl.adl_status = 'I'
945: where adl.document_type = 'AP'
946: and adl.adl_status = 'A'
947: and adl.award_set_id in ( select adl2.award_set_id

Line 948: from gms_award_distributions adl2,

944: set adl.adl_status = 'I'
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

Line 1067: INSERT into gms_award_distributions ( award_set_id ,

1063: -- End of comment
1064:
1065:
1066: FORALL i in l_invoice_distribution_id.FIRST..l_invoice_distribution_id.LAST
1067: INSERT into gms_award_distributions ( award_set_id ,
1068: adl_line_num,
1069: document_type,
1070: distribution_value,
1071: project_id ,

Line 1212: from gms_award_distributions

1208: X_msg_count OUT nocopy NUMBER,
1209: X_msg_data OUT nocopy VARCHAR2 ) is
1210: cursor c1 is
1211: select award_id
1212: from gms_award_distributions
1213: where award_set_id = x_award_id
1214: and adl_line_num = 1 ;
1215:
1216: l_award_id number ;

Line 1280: from gms_award_distributions ADL

1276:
1277: l_award_id NUMBER ;
1278: CURSOR C_ADL_REC is
1279: select award_id
1280: from gms_award_distributions ADL
1281: where award_set_id = p_award_set_id
1282: and adl_line_num = 1 ;
1283:
1284: BEGIN