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_AWARDS_DIST_PKG dependencies on GMS_AWARD_DISTRIBUTIONS

Line 40: x_adls_rec gms_award_distributions%ROWTYPE ;

36: p_dist_line_num IN NUMBER DEFAULT NULL,
37: p_raw_cost IN NUMBER DEFAULT NULL,
38: p_called_from IN varchar2 DEFAULT 'NOT_MISC_SYNCH_ADLS') IS
39:
40: x_adls_rec gms_award_distributions%ROWTYPE ;
41: g_rec_index Number ;
42: x_new_award_set_id NUMBER ;
43: x_line_num_reversed NUMBER ;
44: x_reversed_flag varchar2(1) ;

Line 111: update gms_award_distributions

107: -- --------------------------------------
108: close C_CDL ;
109: return ;
110: ELSE
111: update gms_award_distributions
112: set reversed_flag = 'Y'
113: where award_set_id = p_award_set_id
114: and document_type = 'EXP'
115: and adl_status = 'A'

Line 125: FROM gms_award_distributions

121: -- Get the next adl line num.
122: -- --------------------------------
123: SELECT max(adl_line_num ) + 1
124: INTO x_adl_line_num
125: FROM gms_award_distributions
126: where award_set_id = p_award_set_id ;
127:
128: x_new_award_set_id := p_award_set_id ;
129: ELSE

Line 141: INSERT INTO gms_award_distributions ( award_set_id ,

137:
138: -- -----------------------------------
139: -- Create new record into ADL.
140: -- -----------------------------------
141: INSERT INTO gms_award_distributions ( award_set_id ,
142: adl_line_num,
143: funding_pattern_id,
144: distribution_value ,
145: raw_cost,

Line 234: from GMS_AWARD_DISTRIBUTIONS

230: nvl(fnd_global.user_id,0) , -- created_by ,
231: sysdate , -- creation_date ,
232: last_update_login ,
233: nvl( x_billable_flag, NVL(billable_flag,'Y') )
234: from GMS_AWARD_DISTRIBUTIONS
235: where AWARD_SET_ID = P_AWARD_SET_ID
236: AND ADL_STATUS = 'A'
237: AND rownum < 2 ;
238:

Line 250: from gms_award_distributions

246: set award_id = x_new_award_set_id
247: where po_distribution_id = p_dist_id
248: and award_id = p_award_set_id
249: and exists ( select 'X'
250: from gms_award_distributions
251: where award_set_id = x_new_award_set_id
252: ) ;
253: p_new_award_set_id := x_new_award_set_id ;
254:

Line 276: from gms_award_distributions

272: set award_id = x_new_award_set_id
273: WHERE invoice_id = p_invoice_id
274: and invoice_distribution_id = p_dist_id
275: and exists ( select 'X'
276: from gms_award_distributions
277: where award_set_id = x_new_award_set_id
278: ) ;
279:
280: /* Bug 5344693 : The following update is added to stamp the distribution_line_number correctly

Line 281: on gms_award_distributions. */

277: where award_set_id = x_new_award_set_id
278: ) ;
279:
280: /* Bug 5344693 : The following update is added to stamp the distribution_line_number correctly
281: on gms_award_distributions. */
282: UPDATE gms_award_distributions
283: set distribution_line_number = (select distribution_line_number
284: from ap_invoice_distributions_all
285: where invoice_id = p_invoice_id

Line 282: UPDATE gms_award_distributions

278: ) ;
279:
280: /* Bug 5344693 : The following update is added to stamp the distribution_line_number correctly
281: on gms_award_distributions. */
282: UPDATE gms_award_distributions
283: set distribution_line_number = (select distribution_line_number
284: from ap_invoice_distributions_all
285: where invoice_id = p_invoice_id
286: and invoice_distribution_id = p_dist_id

Line 303: from gms_award_distributions

299: set award_id = x_new_award_set_id
300: where distribution_id = p_dist_id
301: and award_id = p_award_set_id
302: and exists ( select 'X'
303: from gms_award_distributions
304: where award_set_id = x_new_award_set_id
305: ) ;
306: p_new_award_set_id := x_new_award_set_id ;
307:

Line 339: PROCEDURE create_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS

335: -- ----------------------------------------------------------------
336: -- CREATE_ADLS
337: -- The following function allows to create ADL and shared all across.
338: -- -----------------------------------------------------------------
339: PROCEDURE create_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
340: x_adls_rec gms_award_distributions%ROWTYPE ;
341: g_rec_index number ;
342: p_err_code NUMBER ;
343: p_err_buf varchar2(2000) ;

Line 340: x_adls_rec gms_award_distributions%ROWTYPE ;

336: -- CREATE_ADLS
337: -- The following function allows to create ADL and shared all across.
338: -- -----------------------------------------------------------------
339: PROCEDURE create_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
340: x_adls_rec gms_award_distributions%ROWTYPE ;
341: g_rec_index number ;
342: p_err_code NUMBER ;
343: p_err_buf varchar2(2000) ;
344: BEGIN

Line 374: INSERT into gms_award_distributions ( award_set_id ,

370: x_adls_rec.distribution_value:=100;
371: END IF;
372: /* Bug 4301049, 4610217 ends here */
373:
374: INSERT into gms_award_distributions ( award_set_id ,
375: adl_line_num,
376: funding_pattern_id,
377: distribution_value ,
378: raw_cost,

Line 479: PROCEDURE update_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS

475: END create_adls ;
476: -- ================= END OF create_adls ================================
477:
478:
479: PROCEDURE update_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
480: x_adls_rec gms_award_distributions%ROWTYPE ;
481: g_rec_index number ;
482: p_err_code NUMBER ;
483: p_err_buf varchar2(2000) ;

Line 480: x_adls_rec gms_award_distributions%ROWTYPE ;

476: -- ================= END OF create_adls ================================
477:
478:
479: PROCEDURE update_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
480: x_adls_rec gms_award_distributions%ROWTYPE ;
481: g_rec_index number ;
482: p_err_code NUMBER ;
483: p_err_buf varchar2(2000) ;
484: BEGIN

Line 501: UPDATE gms_award_distributions

497: IF x_adls_rec.creation_date is NULL THEN
498: x_adls_rec.creation_date := SYSDATE ;
499: END IF ;
500:
501: UPDATE gms_award_distributions
502: SET funding_pattern_id = x_adls_rec.funding_pattern_id,
503: distribution_value = x_adls_rec.distribution_value,
504: document_type = x_adls_rec.document_type,
505: project_id = x_adls_rec.project_id,

Line 567: -- DELETE gms_award_distributions

563: PROCEDURE delete_adls( p_distribution_set_id NUMBER ) is
564: p_err_code NUMBER ;
565: p_err_buf varchar2(2000) ;
566: BEGIN
567: -- DELETE gms_award_distributions
568: -- WHERE distribution_set_id = p_distribution_set_id ;
569: NULL ;
570: EXCEPTION
571: WHEN OTHERS THEN

Line 603: delete from gms_award_distributions adls

599:
600: -- =====
601: -- Delete award distribution line for a given expenditure item.
602: -- =====
603: delete from gms_award_distributions adls
604: where document_type = 'EXP'
605: and expenditure_item_id in ( select expenditure_item_id
606: from pa_expenditure_items_all ei
607: where expenditure_item_id = p_doc_distribution_id ) ;

Line 613: delete from gms_award_distributions adls

609:
610: -- =====
611: -- Delete award distribution line for a given expenditure.
612: -- =====
613: delete from gms_award_distributions adls
614: where document_type = 'EXP'
615: and expenditure_item_id in ( select expenditure_item_id
616: from pa_expenditure_items_all ei
617: where expenditure_id = p_doc_header_id ) ;

Line 626: delete from gms_award_distributions adls

622: IF p_doc_distribution_id is NOT NULL THEN
623: -- =====
624: -- Delete award distribution line for a given encumbrance item.
625: -- =====
626: delete from gms_award_distributions adls
627: where document_type = 'ENC'
628: and expenditure_item_id in ( select encumbrance_item_id
629: from gms_encumbrance_items_all ei
630: where encumbrance_item_id = p_doc_distribution_id ) ;

Line 635: delete from gms_award_distributions adls

631: ELSE
632: -- =====
633: -- Delete award distribution line for a given encumbrance.
634: -- =====
635: delete from gms_award_distributions adls
636: where document_type = 'ENC'
637: and expenditure_item_id in ( select encumbrance_item_id
638: from gms_encumbrance_items_all ei
639: where encumbrance_id = p_doc_header_id ) ;

Line 691: -- on GMS_AWARD_DISTRIBUTIONS

687: -- PROCEDURE update_billable_flag (p_expenditure_item_id in number)
688: -- This procedure will initialize the billable flag
689: -- in PA_EXPENDITURE_ITEMS_ALL
690: -- Called from trigger GMS_UPDATE_EI_BILLABLE_FLAG
691: -- on GMS_AWARD_DISTRIBUTIONS
692: -- this Procedure is created as direct update of
693: -- other products tables directly from trigger leads to warning in
694: -- adpatch
695: -- --------------------------------------------------------------

Line 852: FROM gms_award_distributions

848: AWARD_NOT_FOUND EXCEPTION ;
849:
850: CURSOR c_adl IS
851: SELECT *
852: FROM gms_award_distributions
853: WHERE award_set_id = l_award_set_idX
854: AND adl_line_num = 1 ;
855: l_adl_rec c_adl%ROWTYPE ;
856:

Line 905: gms_award_distributions adl2

901: SELECT adl2.award_set_id
902: bulk collect into l_dummy_tab
903: FROM po_req_distributions_all rd,
904: po_requisition_lines_all rl,
905: gms_award_distributions adl2
906: WHERE rl.requisition_header_id = p_header_id
907: AND rd.requisition_line_id = rl.requisition_line_id
908: AND adl2.distribution_id = rd.distribution_id
909: AND adl2.document_type = 'REQ'

Line 918: UPDATE gms_award_distributions

914: IF l_dummy_tab.count > 0 THEN
915:
916: FORALL i in l_dummy_tab.FIRST..l_dummy_tab.LAST
917:
918: UPDATE gms_award_distributions
919: set adl_status = 'A'
920: where award_set_id = l_dummy_tab(i) ;
921:
922: END IF ;

Line 939: gms_award_distributions adl2

935: SELECT adl2.award_set_id
936: bulk collect into l_dummy_tab
937: FROM po_req_distributions_all rd,
938: po_requisition_lines_all rl,
939: gms_award_distributions adl2
940: WHERE rl.requisition_header_id = p_header_id
941: AND rd.requisition_line_id = rl.requisition_line_id
942: AND adl2.distribution_id = rd.distribution_id
943: AND adl2.document_type = 'REQ'

Line 952: UPDATE gms_award_distributions

948: IF l_dummy_tab.count > 0 THEN
949:
950: FORALL i in l_dummy_tab.FIRST..l_dummy_tab.LAST
951:
952: UPDATE gms_award_distributions
953: set adl_status = 'I'
954: where award_set_id = l_dummy_tab(i) ;
955:
956: END IF ;

Line 1053: INSERT INTO gms_award_distributions ( award_set_id ,

1049: -- End of comment
1050:
1051:
1052: FORALL i in l_distribution_id.FIRST..l_distribution_id.LAST
1053: INSERT INTO gms_award_distributions ( award_set_id ,
1054: adl_line_num ,
1055: document_type ,
1056: distribution_value ,
1057: project_id ,

Line 1140: UPDATE gms_award_distributions adl

1136: -- creation.
1137: AND NVL(pod.award_id,0) >= 0 ;
1138: BEGIN
1139: -- Activate ADLS that belongs to the po distribution line but
1140: UPDATE gms_award_distributions adl
1141: set adl.adl_status = 'A'
1142: WHERE adl.document_type = 'PO'
1143: AND adl.adl_status = 'I'
1144: AND adl.award_set_id in ( SELECT adl2.award_set_id

Line 1145: FROM gms_award_distributions adl2,

1141: set adl.adl_status = 'A'
1142: WHERE adl.document_type = 'PO'
1143: AND adl.adl_status = 'I'
1144: AND adl.award_set_id in ( SELECT adl2.award_set_id
1145: FROM gms_award_distributions adl2,
1146: po_distributions_all pod
1147: WHERE pod.po_header_Id = p_header_id
1148: AND pod.award_id is not null
1149: AND adl2.award_set_id = pod.award_id

Line 1158: UPDATE gms_award_distributions adl

1154: -- Inactivate ADLS that belongs to the po distribution line but
1155: -- not tied up with award_id in distribution line.
1156: -- Inactivate dangling active adls.
1157: -- ----
1158: UPDATE gms_award_distributions adl
1159: set adl.adl_status = 'I'
1160: WHERE adl.document_type = 'PO'
1161: AND adl.adl_status = 'A'
1162: AND adl.award_set_id in (SELECT adl2.award_set_id

Line 1163: FROM gms_award_distributions adl2,

1159: set adl.adl_status = 'I'
1160: WHERE adl.document_type = 'PO'
1161: AND adl.adl_status = 'A'
1162: AND adl.award_set_id in (SELECT adl2.award_set_id
1163: FROM gms_award_distributions adl2,
1164: po_distributions_all pod
1165: WHERE pod.po_header_id = p_header_id
1166: AND pod.award_id is not null
1167: AND adl2.award_set_id <> pod.award_id

Line 1248: INSERT INTO gms_award_distributions ( award_set_id ,

1244: -- End of comment
1245:
1246:
1247: FORALL i in l_distribution_id.FIRST..l_distribution_id.LAST
1248: INSERT INTO gms_award_distributions ( award_set_id ,
1249: adl_line_num,
1250: document_type,
1251: distribution_value,
1252: project_id ,

Line 1389: INSERT INTO gms_award_distributions

1385: , X_status OUT nocopy NUMBER ) is
1386: l_err_code NUMBER ;
1387: l_err_buf varchar2(2000) ;
1388: BEGIN
1389: INSERT INTO gms_award_distributions
1390: ( award_set_id ,
1391: adl_line_num,
1392: funding_pattern_id,
1393: distribution_value ,

Line 1480: from GMS_AWARD_DISTRIBUTIONS

1476: P_user , -- created_by ,
1477: sysdate , -- creation_date ,
1478: p_login ,
1479: billable_flag
1480: from GMS_AWARD_DISTRIBUTIONS
1481: where expenditure_item_id = p_exp_item_id
1482: and document_type = 'EXP'
1483: and adl_status = 'A'
1484: and adl_line_num = 1 ;