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: /* BUG 14216205 : Added the following Code for SAT : Starts */
280: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL

Line 285: from gms_award_distributions

281: set award_id = x_new_award_set_id
282: WHERE invoice_id = p_invoice_id
283: and invoice_distribution_id = p_dist_id
284: and exists ( select 'X'
285: from gms_award_distributions
286: where AWARD_SET_ID = X_NEW_AWARD_SET_ID
287: ) ;
288: /* BUG 14216205 : Added the following Code for SAT : Ends */
289: /* Bug 5344693 : The following update is added to stamp the distribution_line_number correctly

Line 290: on gms_award_distributions. */

286: where AWARD_SET_ID = X_NEW_AWARD_SET_ID
287: ) ;
288: /* BUG 14216205 : Added the following Code for SAT : Ends */
289: /* Bug 5344693 : The following update is added to stamp the distribution_line_number correctly
290: on gms_award_distributions. */
291: UPDATE gms_award_distributions
292: set distribution_line_number = (select distribution_line_number
293: from ap_invoice_distributions_all
294: where invoice_id = p_invoice_id

Line 291: UPDATE gms_award_distributions

287: ) ;
288: /* BUG 14216205 : Added the following Code for SAT : Ends */
289: /* Bug 5344693 : The following update is added to stamp the distribution_line_number correctly
290: on gms_award_distributions. */
291: UPDATE gms_award_distributions
292: set distribution_line_number = (select distribution_line_number
293: from ap_invoice_distributions_all
294: where invoice_id = p_invoice_id
295: and invoice_distribution_id = p_dist_id

Line 302: UPDATE gms_award_distributions

298: and invoice_id = p_invoice_id
299: and INVOICE_DISTRIBUTION_ID = P_DIST_ID;
300:
301: /* BUG 14216205 : Added the following Code for SAT : Starts */
302: UPDATE gms_award_distributions
303: set distribution_line_number = (select distribution_line_number
304: from AP_SELF_ASSESSED_TAX_DIST_ALL
305: where invoice_id = p_invoice_id
306: and invoice_distribution_id = p_dist_id

Line 323: from gms_award_distributions

319: set award_id = x_new_award_set_id
320: where distribution_id = p_dist_id
321: and award_id = p_award_set_id
322: and exists ( select 'X'
323: from gms_award_distributions
324: where award_set_id = x_new_award_set_id
325: ) ;
326: p_new_award_set_id := x_new_award_set_id ;
327:

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

355: -- ----------------------------------------------------------------
356: -- CREATE_ADLS
357: -- The following function allows to create ADL and shared all across.
358: -- -----------------------------------------------------------------
359: PROCEDURE create_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
360: x_adls_rec gms_award_distributions%ROWTYPE ;
361: g_rec_index number ;
362: p_err_code NUMBER ;
363: p_err_buf varchar2(2000) ;

Line 360: x_adls_rec gms_award_distributions%ROWTYPE ;

356: -- CREATE_ADLS
357: -- The following function allows to create ADL and shared all across.
358: -- -----------------------------------------------------------------
359: PROCEDURE create_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
360: x_adls_rec gms_award_distributions%ROWTYPE ;
361: g_rec_index number ;
362: p_err_code NUMBER ;
363: p_err_buf varchar2(2000) ;
364: BEGIN

Line 394: INSERT into gms_award_distributions ( award_set_id ,

390: x_adls_rec.distribution_value:=100;
391: END IF;
392: /* Bug 4301049, 4610217 ends here */
393:
394: INSERT into gms_award_distributions ( award_set_id ,
395: adl_line_num,
396: funding_pattern_id,
397: distribution_value ,
398: raw_cost,

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

495: END create_adls ;
496: -- ================= END OF create_adls ================================
497:
498:
499: PROCEDURE update_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
500: x_adls_rec gms_award_distributions%ROWTYPE ;
501: g_rec_index number ;
502: p_err_code NUMBER ;
503: p_err_buf varchar2(2000) ;

Line 500: x_adls_rec gms_award_distributions%ROWTYPE ;

496: -- ================= END OF create_adls ================================
497:
498:
499: PROCEDURE update_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
500: x_adls_rec gms_award_distributions%ROWTYPE ;
501: g_rec_index number ;
502: p_err_code NUMBER ;
503: p_err_buf varchar2(2000) ;
504: BEGIN

Line 521: UPDATE gms_award_distributions

517: IF x_adls_rec.creation_date is NULL THEN
518: x_adls_rec.creation_date := SYSDATE ;
519: END IF ;
520:
521: UPDATE gms_award_distributions
522: SET funding_pattern_id = x_adls_rec.funding_pattern_id,
523: distribution_value = x_adls_rec.distribution_value,
524: document_type = x_adls_rec.document_type,
525: project_id = x_adls_rec.project_id,

Line 587: -- DELETE gms_award_distributions

583: PROCEDURE delete_adls( p_distribution_set_id NUMBER ) is
584: p_err_code NUMBER ;
585: p_err_buf varchar2(2000) ;
586: BEGIN
587: -- DELETE gms_award_distributions
588: -- WHERE distribution_set_id = p_distribution_set_id ;
589: NULL ;
590: EXCEPTION
591: WHEN OTHERS THEN

Line 623: delete from gms_award_distributions adls

619:
620: -- =====
621: -- Delete award distribution line for a given expenditure item.
622: -- =====
623: delete from gms_award_distributions adls
624: where document_type = 'EXP'
625: and expenditure_item_id in ( select expenditure_item_id
626: from pa_expenditure_items_all ei
627: where expenditure_item_id = p_doc_distribution_id ) ;

Line 633: delete from gms_award_distributions adls

629:
630: -- =====
631: -- Delete award distribution line for a given expenditure.
632: -- =====
633: delete from gms_award_distributions adls
634: where document_type = 'EXP'
635: and expenditure_item_id in ( select expenditure_item_id
636: from pa_expenditure_items_all ei
637: where expenditure_id = p_doc_header_id ) ;

Line 646: delete from gms_award_distributions adls

642: IF p_doc_distribution_id is NOT NULL THEN
643: -- =====
644: -- Delete award distribution line for a given encumbrance item.
645: -- =====
646: delete from gms_award_distributions adls
647: where document_type = 'ENC'
648: and expenditure_item_id in ( select encumbrance_item_id
649: from gms_encumbrance_items_all ei
650: where encumbrance_item_id = p_doc_distribution_id ) ;

Line 655: delete from gms_award_distributions adls

651: ELSE
652: -- =====
653: -- Delete award distribution line for a given encumbrance.
654: -- =====
655: delete from gms_award_distributions adls
656: where document_type = 'ENC'
657: and expenditure_item_id in ( select encumbrance_item_id
658: from gms_encumbrance_items_all ei
659: where encumbrance_id = p_doc_header_id ) ;

Line 711: -- on GMS_AWARD_DISTRIBUTIONS

707: -- PROCEDURE update_billable_flag (p_expenditure_item_id in number)
708: -- This procedure will initialize the billable flag
709: -- in PA_EXPENDITURE_ITEMS_ALL
710: -- Called from trigger GMS_UPDATE_EI_BILLABLE_FLAG
711: -- on GMS_AWARD_DISTRIBUTIONS
712: -- this Procedure is created as direct update of
713: -- other products tables directly from trigger leads to warning in
714: -- adpatch
715: -- --------------------------------------------------------------

Line 872: FROM gms_award_distributions

868: AWARD_NOT_FOUND EXCEPTION ;
869:
870: CURSOR c_adl IS
871: SELECT *
872: FROM gms_award_distributions
873: WHERE award_set_id = l_award_set_idX
874: AND adl_line_num = 1 ;
875: l_adl_rec c_adl%ROWTYPE ;
876:

Line 925: gms_award_distributions adl2

921: SELECT adl2.award_set_id
922: bulk collect into l_dummy_tab
923: FROM po_req_distributions_all rd,
924: po_requisition_lines_all rl,
925: gms_award_distributions adl2
926: WHERE rl.requisition_header_id = p_header_id
927: AND rd.requisition_line_id = rl.requisition_line_id
928: AND adl2.distribution_id = rd.distribution_id
929: AND adl2.document_type = 'REQ'

Line 938: UPDATE gms_award_distributions

934: IF l_dummy_tab.count > 0 THEN
935:
936: FORALL i in l_dummy_tab.FIRST..l_dummy_tab.LAST
937:
938: UPDATE gms_award_distributions
939: set adl_status = 'A'
940: where award_set_id = l_dummy_tab(i) ;
941:
942: END IF ;

Line 959: gms_award_distributions adl2

955: SELECT adl2.award_set_id
956: bulk collect into l_dummy_tab
957: FROM po_req_distributions_all rd,
958: po_requisition_lines_all rl,
959: gms_award_distributions adl2
960: WHERE rl.requisition_header_id = p_header_id
961: AND rd.requisition_line_id = rl.requisition_line_id
962: AND adl2.distribution_id = rd.distribution_id
963: AND adl2.document_type = 'REQ'

Line 972: UPDATE gms_award_distributions

968: IF l_dummy_tab.count > 0 THEN
969:
970: FORALL i in l_dummy_tab.FIRST..l_dummy_tab.LAST
971:
972: UPDATE gms_award_distributions
973: set adl_status = 'I'
974: where award_set_id = l_dummy_tab(i) ;
975:
976: END IF ;

Line 1073: INSERT INTO gms_award_distributions ( award_set_id ,

1069: -- End of comment
1070:
1071:
1072: FORALL i in l_distribution_id.FIRST..l_distribution_id.LAST
1073: INSERT INTO gms_award_distributions ( award_set_id ,
1074: adl_line_num ,
1075: document_type ,
1076: distribution_value ,
1077: project_id ,

Line 1160: UPDATE gms_award_distributions adl

1156: -- creation.
1157: AND NVL(pod.award_id,0) >= 0 ;
1158: BEGIN
1159: -- Activate ADLS that belongs to the po distribution line but
1160: UPDATE gms_award_distributions adl
1161: set adl.adl_status = 'A'
1162: WHERE adl.document_type = 'PO'
1163: AND adl.adl_status = 'I'
1164: AND adl.award_set_id in ( SELECT adl2.award_set_id

Line 1165: FROM gms_award_distributions adl2,

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

Line 1178: UPDATE gms_award_distributions adl

1174: -- Inactivate ADLS that belongs to the po distribution line but
1175: -- not tied up with award_id in distribution line.
1176: -- Inactivate dangling active adls.
1177: -- ----
1178: UPDATE gms_award_distributions adl
1179: set adl.adl_status = 'I'
1180: WHERE adl.document_type = 'PO'
1181: AND adl.adl_status = 'A'
1182: AND adl.award_set_id in (SELECT adl2.award_set_id

Line 1183: FROM gms_award_distributions adl2,

1179: set adl.adl_status = 'I'
1180: WHERE adl.document_type = 'PO'
1181: AND adl.adl_status = 'A'
1182: AND adl.award_set_id in (SELECT adl2.award_set_id
1183: FROM gms_award_distributions adl2,
1184: po_distributions_all pod
1185: WHERE pod.po_header_id = p_header_id
1186: AND pod.award_id is not null
1187: AND adl2.award_set_id <> pod.award_id

Line 1268: INSERT INTO gms_award_distributions ( award_set_id ,

1264: -- End of comment
1265:
1266:
1267: FORALL i in l_distribution_id.FIRST..l_distribution_id.LAST
1268: INSERT INTO gms_award_distributions ( award_set_id ,
1269: adl_line_num,
1270: document_type,
1271: distribution_value,
1272: project_id ,

Line 1409: INSERT INTO gms_award_distributions

1405: , X_status OUT nocopy NUMBER ) is
1406: l_err_code NUMBER ;
1407: l_err_buf varchar2(2000) ;
1408: BEGIN
1409: INSERT INTO gms_award_distributions
1410: ( award_set_id ,
1411: adl_line_num,
1412: funding_pattern_id,
1413: distribution_value ,

Line 1500: from GMS_AWARD_DISTRIBUTIONS

1496: P_user , -- created_by ,
1497: sysdate , -- creation_date ,
1498: p_login ,
1499: billable_flag
1500: from GMS_AWARD_DISTRIBUTIONS
1501: where expenditure_item_id = p_exp_item_id
1502: and document_type = 'EXP'
1503: and adl_status = 'A'
1504: and adl_line_num = 1 ;