APPS.GMS_COST_PLUS_EXTN dependencies on PA_CMT_UTILS

Line 353: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

349: If l_choice in (2,3) then
350: OPEN P_DOC_ADJ FOR
351: select d.invoice_distribution_id dist_id -- AP Lines change
352: ,I.invoice_id header_id
353: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
354: I.invoice_id,
355: nvl(d.base_amount,d.amount),
356: 'N',
357: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) amount

Line 363: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

359: , adl.burdenable_raw_cost burden
360: , adl.award_set_id award_set_id
361: , adl.adl_line_num adl_line_num
362:
363: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
364: I.invoice_id,
365: nvl(d.base_amount,d.amount),
366: 'N',
367: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) - NVL(adl.burdenable_raw_cost,0) ) diff_amount

Line 383: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

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,
385: nvl(d.base_amount,d.amount),
386: 'N',
387: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N')) <> 0

Line 415: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

411: ElsIf l_choice = 1 then
412: OPEN P_DOC_ADJ FOR
413: select d.invoice_distribution_id dist_id -- AP Lines change
414: ,I.invoice_id header_id
415: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
416: I.invoice_id,
417: nvl(d.base_amount,d.amount),
418: 'N',
419: 'GMS' ) amount

Line 424: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

420: --, nvl(d.base_amount,d.amount) amount
421: , adl.burdenable_raw_cost burden
422: , adl.award_set_id award_set_id
423: , adl.adl_line_num adl_line_num
424: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
425: I.invoice_id,
426: nvl(d.base_amount,d.amount),
427: 'N',
428: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) - NVL(adl.burdenable_raw_cost,0) ) diff_amount

Line 444: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

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,
446: nvl(d.base_amount,d.amount),
447: 'N',
448: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) <> 0

Line 2506: and pa_cmt_utils.get_apdist_amt( apd.invoice_distribution_id,

2502: and nvl(adl.burdenable_raw_cost,0) <> 0
2503: and apd.expenditure_type = P_record.expenditure_type
2504: and ADL.award_set_id = APD.award_id
2505: AND G.LEDGER_ID = APD.SET_OF_BOOKS_ID
2506: and pa_cmt_utils.get_apdist_amt( apd.invoice_distribution_id,
2507: apd.invoice_id,
2508: nvl(apd.base_amount,apd.amount),
2509: 'N',
2510: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N') ) <> 0

Line 2676: select sum( pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,

2672: and ap.invoice_id = P_RECORD.document_header_id
2673: and ap.invoice_distribution_id = P_RECORD.document_distribution_id ; -- AP Lines change
2674:
2675: cursor AP_ZERO_INVOICE is
2676: select sum( pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,
2677: ap.invoice_id,
2678: nvl(ap.base_amount,ap.amount),
2679: 'N',
2680: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount ,

Line 2692: and pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,

2688: and adl.award_id = bc_pkt_rec.award_id
2689: and ap.expenditure_type = bc_pkt_rec.expenditure_type
2690: and ADL.award_set_id = AP.award_id
2691: and G.LEDGER_ID = AP.SET_OF_BOOKS_ID
2692: and pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,
2693: ap.invoice_id,
2694: nvl(ap.base_amount,ap.amount),
2695: 'N',
2696: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) <> 0

Line 3302: select sum( pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,

3298: -- Cursor that checks for Net Zero AP
3299: cursor AP_ZERO_INVOICE (p_invoice_id in number,
3300: p_award_id in number,
3301: p_expenditure_type in varchar2) is
3302: select sum( pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,
3303: ap.invoice_id,
3304: nvl(ap.base_amount,ap.amount),
3305: 'N',
3306: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount

Line 3317: and pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,

3313: and ap.expenditure_type = p_expenditure_type
3314: and ADL.award_set_id = AP.award_id
3315: and ap.invoice_id = p_invoice_id
3316: and G.LEDGER_ID = AP.SET_OF_BOOKS_ID
3317: and pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,
3318: ap.invoice_id,
3319: nvl(ap.base_amount,ap.amount),
3320: 'N',
3321: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N') ) <> 0