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 89: update gms_award_distributions

85:
86: IF c_er_rec.award_set_id is Not NULL OR
87: NVL(X_reject_code, 'X' ) <> 'X' THEN
88:
89: update gms_award_distributions
90: set adl_status = 'I'
91: where award_set_id = NVL(c_er_rec.award_set_id,0)
92:
93:

Line 210: l_adl_rec gms_award_distributions%ROWTYPE ;

206: IS
207: lb_return BOOLEAN ;
208: l_output varchar2(2000) ;
209: l_award_set_id NUMBER ;
210: l_adl_rec gms_award_distributions%ROWTYPE ;
211: BEGIN
212: lb_return := TRUE ;
213: -- IF NOT gms_install.enabled THEN -- Bug 3002305.
214: IF NOT gms_pa_api.vert_install THEN

Line 259: delete from gms_award_distributions

255: p_award_id := l_award_set_id ;
256: END IF ;
257:
258: ELSIF P_EVENT = 'AWARD_SET_ID_REMOVE' THEN
259: delete from gms_award_distributions
260: where award_set_id = p_award_id
261: and adl_line_num = 1
262: and document_type = 'OPI' ;
263: END IF ;

Line 293: from gms_award_distributions ADL

289: p_dist_set_line_number IN NUMBER default NULL
290: ) is
291: CURSOR C_ADL_REC is
292: SELECT *
293: from gms_award_distributions ADL
294: where award_set_id = p_award_id
295: and adl_status = 'A'
296: and adl_line_num = 1 -- AP Lines uptake
297: and document_type= 'APD' ;

Line 319: l_adl_rec gms_award_distributions%ROWTYPE ;

315: and a.project_id = b.project_id
316: and b.project_type = c.project_type
317: and c.sponsored_flag = 'Y' ;
318: l_ap_rec c_ap_rec%ROWTYPE ;
319: l_adl_rec gms_award_distributions%ROWTYPE ;
320: BEGIN
321: -- IF NOT gms_install.enabled THEN -- Bug 3002305
322: IF NOT gms_pa_api.vert_install THEN
323: return ;

Line 419: from gms_award_distributions ADL

415: l_award_id NUMBER ;
416:
417: CURSOR C_ADL_REC is
418: select award_id
419: from gms_award_distributions ADL
420: where award_set_id = p_award_set_id
421: and adl_line_num = 1 ;
422:
423: --and document_type = 'AP'

Line 502: x_adl_rec gms_award_distributions%ROWTYPE ;

498: p_next_dist_line_num IN NUMBER,
499: p_invoice_distribution_id IN NUMBER
500: ) is
501: X_award_set_id NUMBER ;
502: x_adl_rec gms_award_distributions%ROWTYPE ;
503: x_ap_rec ap_invoice_distributions_all%ROWTYPE ;
504:
505: x_inv_dist_id NUMBER ;
506: X_amount NUMBER ;

Line 513: from gms_award_distributions

509: from ap_invoice_distributions_all
510: where Invoice_distribution_id = p_prepay_dist_id ;
511: Cursor C_adl is
512: select *
513: from gms_award_distributions
514: where award_set_id = X_award_set_id
515: and adl_line_num = 1 ;
516: Cursor c_new_dist_line is
517: select *

Line 561: UPDATE GMS_AWARD_DISTRIBUTIONS

557: -- =====================================================
558: x_adl_rec.fc_status := 'N' ;
559: x_adl_rec.burdenable_raw_cost := 0 ;
560: gms_awardS_dist_pkg.create_adls( X_adl_rec) ;
561: UPDATE GMS_AWARD_DISTRIBUTIONS
562: SET BUD_TASK_ID = x_adl_rec.BUD_TASK_ID
563: WHERE AWARD_SET_ID = x_adl_rec.award_set_id
564: AND ADL_STATUS = 'A' ;
565: Update ap_invoice_distributions_all

Line 586: gms_award_distributions adl

582: p_award_id IN OUT NOCOPY NUMBER ) is
583: cursor c_get_award is
584: select adl.award_id
585: from ap_distribution_set_lines apd,
586: gms_award_distributions adl
587: where apd.distribution_set_id = p_distribution_set_id
588: and apd.distribution_set_line_number = p_distribution_set_line_number
589: and adl.award_set_id = p_award_set_id
590: and apd.award_id = adl.award_set_id

Line 771: select * from gms_award_distributions where award_set_id = l_award_set_idX

767: and inv.invoice_id = a.invoice_id
768: and gpt.sponsored_flag = 'Y' ;
769:
770: cursor c_adl is
771: select * from gms_award_distributions where award_set_id = l_award_set_idX
772: and adl_line_num = 1 ;
773: l_adl_rec c_adl%ROWTYPE ;
774:
775: cursor c2 is

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

780: where a.invoice_id = p_invoice_id
781: and a.project_id = p.project_id
782: and p.project_type = gpt.project_type
783: and gpt.sponsored_flag = 'Y'
784: and not exists ( select 1 from gms_award_distributions adl
785: where adl.invoice_id = p_invoice_id
786: and adl.distribution_line_number = A.distribution_line_number
787: and adl.invoice_distribution_id = A.invoice_distribution_id -- AP Lines uptake
788: and adl.document_type = 'AP'

Line 840: gms_award_distributions adl

836: l_created_by ,
837: l_last_update_login ,
838: l_new_award_set_id
839: from ap_invoice_distributions_all A,
840: gms_award_distributions adl
841: where a.invoice_id = p_invoice_id
842: and adl.award_set_id = a.award_id
843: and adl.adl_line_num = 1
844: and a.award_id IS NOT NULL;

Line 852: update gms_award_distributions adl

848: IF NVL(SUBSTR(p_calling_sequence, 1,15),'X') = 'AP_APPROVAL_PKG' THEN
849: l_count := 0 ;
850:
851: -- 2308005 ( CLEARING INVOICE DIST. LINE AFTER CHANGING AWARD MAKES ADL STATUS 'I' )
852: update gms_award_distributions adl
853: set adl.adl_status = 'A'
854: where adl.document_type = 'AP'
855: and adl.adl_status = 'I'
856: and adl.award_set_id in ( select adl2.award_set_id

Line 857: from gms_award_distributions adl2,

853: set adl.adl_status = 'A'
854: where adl.document_type = 'AP'
855: and adl.adl_status = 'I'
856: and adl.award_set_id in ( select adl2.award_set_id
857: from gms_award_distributions adl2,
858: ap_invoice_distributions_all apd
859: where apd.invoice_id = p_invoice_id
860: and apd.award_id is not null
861: and adl2.award_set_id = apd.award_id

Line 872: update gms_award_distributions adl

868: -- Inactivate ADLS that belongs to the AP distribution line but
869: -- not tied up with award_id in ap_distribution line.
870: -- Inactivate dangling active adls.
871: -- ----
872: update gms_award_distributions adl
873: set adl.adl_status = 'I'
874: where adl.document_type = 'AP'
875: and adl.adl_status = 'A'
876: and adl.award_set_id in ( select adl2.award_set_id

Line 877: from gms_award_distributions adl2,

873: set adl.adl_status = 'I'
874: where adl.document_type = 'AP'
875: and adl.adl_status = 'A'
876: and adl.award_set_id in ( select adl2.award_set_id
877: from gms_award_distributions adl2,
878: ap_invoice_distributions_all apd
879: where apd.invoice_id = p_invoice_id
880: and apd.award_id is not null
881: and adl2.award_set_id <> apd.award_id

Line 996: INSERT into gms_award_distributions ( award_set_id ,

992: -- End of comment
993:
994:
995: FORALL i in l_invoice_distribution_id.FIRST..l_invoice_distribution_id.LAST
996: INSERT into gms_award_distributions ( award_set_id ,
997: adl_line_num,
998: document_type,
999: distribution_value,
1000: project_id ,

Line 1141: from gms_award_distributions

1137: X_msg_count OUT nocopy NUMBER,
1138: X_msg_data OUT nocopy VARCHAR2 ) is
1139: cursor c1 is
1140: select award_id
1141: from gms_award_distributions
1142: where award_set_id = x_award_id
1143: and adl_line_num = 1 ;
1144:
1145: l_award_id number ;

Line 1209: from gms_award_distributions ADL

1205:
1206: l_award_id NUMBER ;
1207: CURSOR C_ADL_REC is
1208: select award_id
1209: from gms_award_distributions ADL
1210: where award_set_id = p_award_set_id
1211: and adl_line_num = 1 ;
1212:
1213: BEGIN