[Home] [Help]
50: IF p_po_header_id IS NULL THEN
51:
52: SELECT document_id
53: INTO l_header_id
54: FROM po_drafts
55: WHERE draft_id = p_draft_id;
56:
57: ELSE
58:
701: --End of Comments
702: ------------------------------------------------------------------------
703: PROCEDURE merge_changes
704: ( p_draft_id IN NUMBER,
705: p_draft_type IN PO_DRAFTS.draft_type%TYPE
706: ) IS
707:
708: d_api_name CONSTANT VARCHAR2(30) := 'merge_changes';
709: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
1127: PH.enable_all_sites = PHDV.enable_all_sites, --ER 9824167
1128: -- Bug # 13612774 Added Contract terms
1129: PH.conterms_exist_flag =
1130: DECODE(p_draft_type,
1131: PO_DRAFTS_PVT.g_draft_type_MOD, PHDV.conterms_exist_flag,
1132: PH.conterms_exist_flag),
1133: PH.ame_approval_id =
1134: DECODE(p_draft_type,
1135: PO_DRAFTS_PVT.g_draft_type_MOD, PH.ame_approval_id,
1131: PO_DRAFTS_PVT.g_draft_type_MOD, PHDV.conterms_exist_flag,
1132: PH.conterms_exist_flag),
1133: PH.ame_approval_id =
1134: DECODE(p_draft_type,
1135: PO_DRAFTS_PVT.g_draft_type_MOD, PH.ame_approval_id,
1136: PHDV.ame_approval_id),
1137: PH.ame_transaction_type =
1138: DECODE(p_draft_type,
1139: PO_DRAFTS_PVT.g_draft_type_MOD, PH.ame_transaction_type,
1135: PO_DRAFTS_PVT.g_draft_type_MOD, PH.ame_approval_id,
1136: PHDV.ame_approval_id),
1137: PH.ame_transaction_type =
1138: DECODE(p_draft_type,
1139: PO_DRAFTS_PVT.g_draft_type_MOD, PH.ame_transaction_type,
1140: PHDV.ame_transaction_type),
1141: PH.approved_flag =
1142: DECODE(p_draft_type,
1143: PO_DRAFTS_PVT.g_draft_type_MOD, PH.approved_flag,
1139: PO_DRAFTS_PVT.g_draft_type_MOD, PH.ame_transaction_type,
1140: PHDV.ame_transaction_type),
1141: PH.approved_flag =
1142: DECODE(p_draft_type,
1143: PO_DRAFTS_PVT.g_draft_type_MOD, PH.approved_flag,
1144: PHDV.approved_flag),
1145: PH.approved_date =
1146: DECODE(p_draft_type,
1147: PO_DRAFTS_PVT.g_draft_type_MOD, PH.approved_date,
1143: PO_DRAFTS_PVT.g_draft_type_MOD, PH.approved_flag,
1144: PHDV.approved_flag),
1145: PH.approved_date =
1146: DECODE(p_draft_type,
1147: PO_DRAFTS_PVT.g_draft_type_MOD, PH.approved_date,
1148: PHDV.approved_date),
1149: PH.acceptance_required_flag =
1150: DECODE(p_draft_type,
1151: PO_DRAFTS_PVT.g_draft_type_MOD, PH.acceptance_required_flag,
1147: PO_DRAFTS_PVT.g_draft_type_MOD, PH.approved_date,
1148: PHDV.approved_date),
1149: PH.acceptance_required_flag =
1150: DECODE(p_draft_type,
1151: PO_DRAFTS_PVT.g_draft_type_MOD, PH.acceptance_required_flag,
1152: PHDV.acceptance_required_flag),
1153: PH.acceptance_due_date =
1154: DECODE(p_draft_type,
1155: PO_DRAFTS_PVT.g_draft_type_MOD, PH.acceptance_due_date,
1151: PO_DRAFTS_PVT.g_draft_type_MOD, PH.acceptance_required_flag,
1152: PHDV.acceptance_required_flag),
1153: PH.acceptance_due_date =
1154: DECODE(p_draft_type,
1155: PO_DRAFTS_PVT.g_draft_type_MOD, PH.acceptance_due_date,
1156: PHDV.acceptance_due_date),
1157: PH.clm_default_dist_flag =
1158: DECODE(p_draft_type,
1159: PO_DRAFTS_PVT.g_draft_type_MOD, PH.clm_default_dist_flag,
1155: PO_DRAFTS_PVT.g_draft_type_MOD, PH.acceptance_due_date,
1156: PHDV.acceptance_due_date),
1157: PH.clm_default_dist_flag =
1158: DECODE(p_draft_type,
1159: PO_DRAFTS_PVT.g_draft_type_MOD, PH.clm_default_dist_flag,
1160: PHDV.clm_default_dist_flag),
1161: PH.clm_contract_finance_code = PHDV.clm_contract_finance_code,
1162: PH.clm_special_contract_type = PHDV.clm_special_contract_type, -- CLM Phase 4
1163: PH.clm_payment_instr_code = PHDV.clm_payment_instr_code-- CLM Phase 4