DBA Data[Home] [Help]

APPS.PO_LINES_DRAFT_PKG dependencies on PO_DRAFTS

Line 185: FROM po_drafts

181: FOR i IN 1..p_draft_id_tbl.Count LOOP
182: BEGIN
183: SELECT draft_type
184: INTO l_draft_type_tbl(i)
185: FROM po_drafts
186: WHERE draft_id = p_draft_id_tbl(i);
187: EXCEPTION
188: WHEN OTHERS THEN
189: l_draft_type_tbl(i) := NULL;

Line 581: PO_DRAFTS_PVT.g_draft_type_MOD, NULL,

577: clm_delivery_event_code,
578: clm_payment_instr_code,
579: clm_undef_flag,
580: DECODE(l_draft_type_tbl(i),
581: PO_DRAFTS_PVT.g_draft_type_MOD, NULL,
582: PO_DRAFTS_PVT.g_draft_type_PAR, NULL,
583: clm_undef_action_code),--UCA Change
584: clm_approved_undef_amount,
585: clm_uda_pricing_total,

Line 582: PO_DRAFTS_PVT.g_draft_type_PAR, NULL,

578: clm_payment_instr_code,
579: clm_undef_flag,
580: DECODE(l_draft_type_tbl(i),
581: PO_DRAFTS_PVT.g_draft_type_MOD, NULL,
582: PO_DRAFTS_PVT.g_draft_type_PAR, NULL,
583: clm_undef_action_code),--UCA Change
584: clm_approved_undef_amount,
585: clm_uda_pricing_total,
586: unit_price, --old_unit_price

Line 730: p_draft_type PO_DRAFTS.draft_type%TYPE DEFAULT NULL

726: --End of Comments
727: ------------------------------------------------------------------------
728: PROCEDURE merge_changes
729: ( p_draft_id IN NUMBER,
730: p_draft_type PO_DRAFTS.draft_type%TYPE DEFAULT NULL
731: ) IS
732:
733: l_line_id_tbl PO_TBL_NUMBER;
734: d_api_name CONSTANT VARCHAR2(30) := 'merge_changes';

Line 1171: PO_DRAFTS_PVT.g_draft_type_MOD,PL.clm_undef_action_code,

1167: PL.clm_payment_instr_code = PLDV.clm_payment_instr_code,
1168: PL.clm_undef_flag = PLDV.clm_undef_flag,
1169: PL.clm_undef_action_code =
1170: DECODE(p_draft_type,
1171: PO_DRAFTS_PVT.g_draft_type_MOD,PL.clm_undef_action_code,
1172: PLDV.clm_undef_action_code), -- UCA Project CLMR4 Changes
1173: PL.clm_approved_undef_amount = PLDV.clm_approved_undef_amount,
1174: PL.clm_uda_pricing_total = PLDV.clm_uda_pricing_total,
1175: PL.clm_pop_exception_reason = PLDV.clm_pop_exception_reason,