[Home] [Help]
127: gbp.award_set_id,
128: transaction_source,
129: gbp.request_id
130: from gms_bc_packets gbp,
131: gms_award_distributions adl
132: where gbp.packet_id = p_packet_id
133: and gbp.expenditure_type = p_expenditure_type
134: and gbp.award_id = p_award_id
135: and gbp.document_header_id = adl.expenditure_item_id
255: adl.ind_compiled_set_id
256: from po_requisition_headers RH,
257: po_requisition_lines RL,
258: po_req_distributions RD,
259: gms_award_distributions ADL
260: where rh.type_lookup_code = 'PURCHASE'
261: and rh.requisition_header_id = rl.requisition_header_id
262: and nvl(rl.modified_by_agent_flag,'N') = 'N'
263: and rl.source_type_code = 'VENDOR'
316: , adl.bud_task_id
317: , adl.ind_compiled_set_id
318: from
319: po_distributions pod,
320: gms_award_distributions adl
321: where nvl(pod.encumbered_flag,'N')= 'Y'
322: and pod.award_id = adl.award_set_id
323: and adl.adl_line_num = 1
324: and adl.po_distribution_id = pod.po_distribution_id
376: , adl.bud_task_id
377: , adl.ind_compiled_set_id
378: from ap_invoices I,
379: ap_invoice_distributions D,
380: gms_award_distributions ADL,
381: GL_LEDGERS G
382: where i.invoice_id = d.invoice_id
383: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
384: I.invoice_id,
437: , adl.bud_task_id
438: , adl.ind_compiled_set_id
439: from ap_invoices I,
440: ap_invoice_distributions D,
441: gms_award_distributions ADL,
442: gl_ledgers g
443: where i.invoice_id = d.invoice_id
444: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
445: I.invoice_id,
484: , adl.resource_list_member_id
485: , adl.bud_task_id
486: , adl.ind_compiled_set_id
487: from gms_encumbrance_items enc,
488: gms_award_distributions adl,
489: gms_encumbrances_all ge
490: where enc.encumbrance_item_id = adl.expenditure_item_id
491: and nvl(enc.enc_distributed_flag,'N') = 'Y'
492: and adl.adl_status = 'A'
1159: -- BUG 1522671 - For REQ,PO,AP if there is any idc rate changes when REQ->PO->AP
1160: -- then the reversing committments should be based on the orginal
1161: -- idc rate. This is also applicable if the above committments are reversed.
1162: -- For this the orignal idc rate schedule (ind_compiled_set_id)
1163: -- is picked from gms_award_distributions for the committements
1164: -- ----------------------------------------------------------------------------------
1165:
1166: -- ==================================================================================
1167: -- bug : 1698738 - IDC RATE CHANGES CAUSE DISCREPENCIES IN S.I. INTERFACE TO PROJECTS.
1192:
1193: BEGIN
1194: select adl.ind_compiled_set_id
1195: into l_compiled_set_id
1196: from gms_award_distributions adl
1197: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1198: --po_req_distributions_all por
1199: where adl.award_id = x_award_id
1200: and adl.task_id = x_task_id
1213: ELSIF x_document_type = 'PO' THEN
1214: BEGIN
1215: select adl.ind_compiled_set_id
1216: into l_compiled_set_id
1217: from gms_award_distributions adl
1218: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1219: -- po_distributions_all pod
1220: where adl.award_id = x_award_id
1221: and adl.task_id = x_task_id
1235: ELSIF x_document_type = 'AP' THEN
1236: BEGIN
1237: select adl.ind_compiled_set_id
1238: into l_compiled_set_id
1239: from gms_award_distributions adl
1240: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1241: -- ap_invoice_distributions_all apd
1242: where adl.award_id = x_award_id
1243: and adl.task_id = x_task_id
1258: ELSIF x_document_type = 'EXP' THEN
1259: BEGIN
1260: select ind_compiled_set_id
1261: into l_compiled_set_id
1262: from gms_award_distributions
1263: where award_id = x_award_id
1264: and task_id = x_task_id
1265: and expenditure_item_id = x_document_header_id
1266: and cdl_line_num = x_document_distribution_id
2089: CURSOR C_req is
2090: SELECT adl.burdenable_raw_cost burden_amount,
2091: adl.adl_line_num,
2092: adl.award_set_id
2093: FROM gms_award_distributions adl ,
2094: po_req_distributions_all req
2095: WHERE adl.distribution_id = p_record.document_distribution_id
2096: AND req.distribution_id = p_record.document_distribution_id
2097: AND req.award_id = adl.award_set_id
2251: select nvl(adl.burdenable_raw_cost,0) ,
2252: adl.award_set_id award_set_id,
2253: adl_line_num adl_line_num
2254: FROM po_distributions_all pod,
2255: gms_award_distributions adl
2256: where adl.award_set_id = pod.award_id
2257: AND adl.po_distribution_id = pod.po_distribution_id
2258: and adl.adl_status = 'A'
2259: and pod.po_distribution_id = X_po_dist_id ;
2394: select nvl(adl.burdenable_raw_cost,0) ,
2395: adl.award_set_id award_set_id,
2396: adl_line_num adl_line_num
2397: FROM gms_encumbrance_items_all enc,
2398: gms_award_distributions adl
2399: where adl.expenditure_item_id = ENC.encumbrance_item_id
2400: and adl.adl_status = 'A'
2401: and ENC.encumbrance_item_id = bc_pkt_rec.document_header_id
2402: and enc.enc_distributed_flag = 'Y' ;
2493: adl.resource_list_member_id,
2494: adl.bud_task_id,
2495: adl.ind_compiled_set_id
2496: FROM ap_invoice_distributions APD,
2497: gms_award_distributions ADL,
2498: gl_ledgers G
2499: where adl.invoice_distribution_id = APD.invoice_distribution_id
2500: and adl.adl_status = 'A'
2501: and adl.award_id = P_record.award_id
2627: adl.bud_task_id,
2628: adl.ind_compiled_set_id
2629: from ap_invoice_distributions_all apd1,
2630: ap_invoice_distributions_all apd2,
2631: gms_award_distributions adl
2632: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2633: and apd2.invoice_distribution_id = apd1.prepay_distribution_id
2634: and apd2.award_id = adl.award_set_id
2635: and adl.invoice_distribution_id = apd2.invoice_distribution_id
2662:
2663: CURSOR C_GET_AWARD_SET_ID IS
2664: SELECT adl.award_set_id , adl.adl_line_num
2665: FROM ap_invoice_distributions AP,
2666: gms_award_distributions ADL
2667: where adl.invoice_distribution_id = AP.invoice_distribution_id
2668: and adl.adl_status = 'A'
2669: and adl.award_id = p_record.award_id
2670: and ap.expenditure_type = p_record.expenditure_type
2680: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount ,
2681: sum(nvl(adl.burdenable_raw_cost,0)) sum_burden,
2682: count(*) sum_count
2683: FROM ap_invoice_distributions AP,
2684: gms_award_distributions ADL,
2685: gl_ledgers G
2686: where adl.invoice_distribution_id = AP.invoice_distribution_id
2687: and adl.adl_status = 'A'
2688: and adl.award_id = bc_pkt_rec.award_id
3304: nvl(ap.base_amount,ap.amount),
3305: 'N',
3306: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount
3307: FROM ap_invoice_distributions AP,
3308: gms_award_distributions ADL,
3309: GL_LEDGERS G
3310: where adl.invoice_distribution_id = AP.invoice_distribution_id
3311: and adl.adl_status = 'A'
3312: and adl.award_id = p_award_id
4216: BEGIN
4217: null; -- All code remove as this will be taken care by Interface FC
4218: END PPAY_LOG_POSTING ;
4219:
4220: PROCEDURE CALC_prepayment_burden( X_AP_REC ap_invoice_distributions_all%ROWTYPE , X_adl_rec gms_award_distributions%ROWTYPE ) is
4221: BEGIN
4222: null; -- All code remove as this will be taken care by Interface FC
4223: END CALC_prepayment_burden ;
4224:
4265: l_stage := 'Retrieve records';
4266: FOR bc_records in c_packet
4267: LOOP
4268: If bc_records.document_type = 'REQ' then
4269: update gms_award_distributions
4270: set burdenable_raw_cost = nvl(burdenable_raw_cost,0) + bc_records.burdenable_raw_cost,
4271: ind_compiled_set_id = decode(bc_records.burden_adjustment_flag,
4272: 'Y',ind_compiled_set_id,bc_records.ind_compiled_set_id)
4273: where distribution_id = bc_records.document_distribution_id
4274: and adl_status = 'A'
4275: and document_type = 'REQ';
4276:
4277: Elsif bc_records. document_type = 'PO' then
4278: update gms_award_distributions
4279: set burdenable_raw_cost = nvl(burdenable_raw_cost,0) + bc_records.burdenable_raw_cost,
4280: ind_compiled_set_id = decode(bc_records.burden_adjustment_flag,
4281: 'Y',ind_compiled_set_id,bc_records.ind_compiled_set_id)
4282: where po_distribution_id = bc_records.document_distribution_id
4283: and adl_status = 'A'
4284: and document_type = 'PO';
4285:
4286: Elsif bc_records.document_type = 'AP' then
4287: update gms_award_distributions
4288: set burdenable_raw_cost = nvl(burdenable_raw_cost,0) + bc_records.burdenable_raw_cost,
4289: ind_compiled_set_id = decode(bc_records.burden_adjustment_flag,
4290: 'Y',ind_compiled_set_id,bc_records.ind_compiled_set_id)
4291: where invoice_id = bc_records.document_header_id
4293: and adl_status = 'A'
4294: and document_type = 'AP';
4295:
4296: Elsif bc_records.document_type = 'ENC' then
4297: update gms_award_distributions
4298: set burdenable_raw_cost = nvl(burdenable_raw_cost,0) + bc_records.burdenable_raw_cost,
4299: ind_compiled_set_id = decode(bc_records.burden_adjustment_flag,
4300: 'Y',ind_compiled_set_id,bc_records.ind_compiled_set_id)
4301: where expenditure_item_id = bc_records.document_header_id
4368: -- Resolution : Joins with the base tables were added.
4369: --
4370: select adl.ind_compiled_set_id
4371: into x_ind_compiled_set_id
4372: from gms_award_distributions adl,
4373: po_req_distributions_all req
4374: where req.distribution_id = x_distribution_id
4375: and req.award_id = adl.award_set_id
4376: and adl.adl_line_num = 1 ;
4381: -- Resolution : Joins with the base tables were added.
4382: --
4383: select adl.ind_compiled_set_id
4384: into x_ind_compiled_set_id
4385: from gms_award_distributions adl,
4386: po_distributions_all po
4387: where po.po_distribution_id = x_distribution_id
4388: and po.award_id = adl.award_set_id
4389: and adl.adl_line_num = 1 ;
4394: -- Resolution : Joins with the base tables were added.
4395: --
4396: select adl.ind_compiled_set_id
4397: into x_ind_compiled_set_id
4398: from gms_award_distributions adl,
4399: ap_invoice_distributions_all apd
4400: where apd.distribution_line_number = x_distribution_line_number
4401: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4402: and apd.award_id = adl.award_set_id
4404:
4405: elsif x_doc_type = 'ENC' then
4406: select ind_compiled_set_id
4407: into x_ind_compiled_set_id
4408: from gms_award_distributions
4409: where expenditure_item_id = x_distribution_id
4410: and adl_status = 'A'
4411: and fc_status = 'A'
4412: and nvl(reversed_flag, 'N') <> 'Y' --Bug 5726575
4437: -- Resolution : Joins with the base tables were added.
4438: --
4439: select adl.burdenable_raw_cost
4440: into x_burdenable_raw_cost
4441: from gms_award_distributions adl,
4442: po_req_distributions_all req
4443: where req.distribution_id = x_distribution_id
4444: and req.award_id = adl.award_set_id
4445: and adl.adl_line_num = 1 ;
4450: -- Resolution : Joins with the base tables were added.
4451: --
4452: select adl.burdenable_raw_cost
4453: into x_burdenable_raw_cost
4454: from gms_award_distributions adl,
4455: po_distributions_all po
4456: where po.po_distribution_id = x_distribution_id
4457: and po.award_id = adl.award_set_id
4458: and adl.adl_line_num = 1 ;
4463: -- Resolution : Joins with the base tables were added.
4464: --
4465: select adl.burdenable_raw_cost
4466: into x_burdenable_raw_cost
4467: from gms_award_distributions adl,
4468: ap_invoice_distributions_all apd
4469: where apd.distribution_line_number = x_distribution_line_number
4470: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4471: and apd.award_id = adl.award_set_id
4473:
4474: elsif x_doc_type = 'ENC' then
4475: select burdenable_raw_cost
4476: into x_burdenable_raw_cost
4477: from gms_award_distributions
4478: where expenditure_item_id = x_distribution_id
4479: and adl_status = 'A'
4480: and fc_status = 'A'
4481: and nvl(reversed_flag, 'N') <> 'Y' --Bug 5726575