15: l_org_id PO_HEADERS_ALL.org_id%TYPE; --
16:
17: BEGIN
18: IF (g_po_wf_debug = 'Y') THEN
19: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
20: '*** In Procedure: chord_hd ***' );
21: END IF;
22:
23: IF funcmode <> 'RUN' THEN
48:
49: set_wf_header_control(itemtype, itemkey, x_header_control);
50:
51: IF (g_po_wf_debug = 'Y') THEN
52: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
53: '*** Finish: chord_hd ***' );
54: END IF;
55:
56: result := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
74: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
75:
76: BEGIN
77: IF (g_po_wf_debug = 'Y') THEN
78: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
79: '*** In Procedure check_header_change ***');
80: END IF;
81:
82: /* To use change order,
655: x_header_control.po_total_change := po_total_change(x_po_header_id);
656: end if;
657:
658: IF (g_po_wf_debug = 'Y') THEN
659: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
660: '*** Finish check_header_change ***');
661: END IF;
662:
663: EXCEPTION
845: x_header_control IN t_header_control_type)
846: IS
847: BEGIN
848: IF (g_po_wf_debug = 'Y') THEN
849: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
850: '*** In procedure set_wf_header_control ***');
851: END IF;
852:
853: wf_engine.SetItemAttrText(itemtype,
966:
967: --debug_header_control(itemtype, itemkey, x_header_control);
968:
969: IF (g_po_wf_debug = 'Y') THEN
970: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
971: '*** Finish set_wf_header_control ***');
972: END IF;
973:
974: END;
978: x_header_control IN OUT NOCOPY t_header_control_type)
979: IS
980: BEGIN
981: IF (g_po_wf_debug = 'Y') THEN
982: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
983: '*** In procedure get_wf_header_control ***');
984: END IF;
985:
986: x_header_control.agent_id :=
1096:
1097: debug_header_control(itemtype, itemkey, x_header_control);
1098:
1099: IF (g_po_wf_debug = 'Y') THEN
1100: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1101: '*** FINISH: get_wf_header_control ***');
1102: END IF;
1103: END;
1104:
1107: x_header_parameters IN OUT NOCOPY t_header_parameters_type)
1108: IS
1109: BEGIN
1110: IF (g_po_wf_debug = 'Y') THEN
1111: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1112: '*** In procedure get_wf_header_parameters ***');
1113: END IF;
1114:
1115: x_header_parameters.po_header_id :=
1117: itemkey,
1118: 'DOCUMENT_ID');
1119:
1120: IF (g_po_wf_debug = 'Y') THEN
1121: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1122: 'po_header_id = '|| to_char(x_header_parameters.po_header_id));
1123: END IF;
1124:
1125: IF (g_po_wf_debug = 'Y') THEN
1122: 'po_header_id = '|| to_char(x_header_parameters.po_header_id));
1123: END IF;
1124:
1125: IF (g_po_wf_debug = 'Y') THEN
1126: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1127: '*** FINISH: get_wf_header_parameters ***');
1128: END IF;
1129:
1130: EXCEPTION
1140: x_header_control IN t_header_control_type)
1141: IS
1142: BEGIN
1143: IF (g_po_wf_debug = 'Y') THEN
1144: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1145: '*** In procedure: debug_header_control ***');
1146: END IF;
1147:
1148: IF (g_po_wf_debug = 'Y') THEN
1145: '*** In procedure: debug_header_control ***');
1146: END IF;
1147:
1148: IF (g_po_wf_debug = 'Y') THEN
1149: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1150: 'agent_id : ' ||x_header_control.agent_id);
1151: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1152: 'vendor_site_id : ' ||x_header_control.vendor_site_id);
1153: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1147:
1148: IF (g_po_wf_debug = 'Y') THEN
1149: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1150: 'agent_id : ' ||x_header_control.agent_id);
1151: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1152: 'vendor_site_id : ' ||x_header_control.vendor_site_id);
1153: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1154: 'vendor_contact_id : ' ||x_header_control.vendor_contact_id);
1155: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1149: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1150: 'agent_id : ' ||x_header_control.agent_id);
1151: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1152: 'vendor_site_id : ' ||x_header_control.vendor_site_id);
1153: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1154: 'vendor_contact_id : ' ||x_header_control.vendor_contact_id);
1155: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1156: 'ship_to_location_id : ' ||x_header_control.ship_to_location_id);
1157: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1151: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1152: 'vendor_site_id : ' ||x_header_control.vendor_site_id);
1153: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1154: 'vendor_contact_id : ' ||x_header_control.vendor_contact_id);
1155: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1156: 'ship_to_location_id : ' ||x_header_control.ship_to_location_id);
1157: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1158: 'bill_to_location_id : ' ||x_header_control.bill_to_location_id);
1159: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1153: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1154: 'vendor_contact_id : ' ||x_header_control.vendor_contact_id);
1155: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1156: 'ship_to_location_id : ' ||x_header_control.ship_to_location_id);
1157: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1158: 'bill_to_location_id : ' ||x_header_control.bill_to_location_id);
1159: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1160: 'terms_id : ' ||x_header_control.terms_id);
1161: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1155: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1156: 'ship_to_location_id : ' ||x_header_control.ship_to_location_id);
1157: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1158: 'bill_to_location_id : ' ||x_header_control.bill_to_location_id);
1159: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1160: 'terms_id : ' ||x_header_control.terms_id);
1161: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1162: 'ship_via_lookup_code : ' ||x_header_control.ship_via_lookup_code);
1163: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1157: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1158: 'bill_to_location_id : ' ||x_header_control.bill_to_location_id);
1159: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1160: 'terms_id : ' ||x_header_control.terms_id);
1161: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1162: 'ship_via_lookup_code : ' ||x_header_control.ship_via_lookup_code);
1163: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1164: 'fob_lookup_code : ' ||x_header_control.fob_lookup_code);
1165: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1159: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1160: 'terms_id : ' ||x_header_control.terms_id);
1161: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1162: 'ship_via_lookup_code : ' ||x_header_control.ship_via_lookup_code);
1163: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1164: 'fob_lookup_code : ' ||x_header_control.fob_lookup_code);
1165: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1166: 'freight_terms_lookup_code: ' ||x_header_control.freight_terms_lookup_code);
1167: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1161: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1162: 'ship_via_lookup_code : ' ||x_header_control.ship_via_lookup_code);
1163: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1164: 'fob_lookup_code : ' ||x_header_control.fob_lookup_code);
1165: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1166: 'freight_terms_lookup_code: ' ||x_header_control.freight_terms_lookup_code);
1167: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1168: 'note_to_vendor : ' ||x_header_control.note_to_vendor);
1169: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1163: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1164: 'fob_lookup_code : ' ||x_header_control.fob_lookup_code);
1165: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1166: 'freight_terms_lookup_code: ' ||x_header_control.freight_terms_lookup_code);
1167: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1168: 'note_to_vendor : ' ||x_header_control.note_to_vendor);
1169: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1170: 'confirming_order_flag : ' ||x_header_control.confirming_order_flag);
1171: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1165: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1166: 'freight_terms_lookup_code: ' ||x_header_control.freight_terms_lookup_code);
1167: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1168: 'note_to_vendor : ' ||x_header_control.note_to_vendor);
1169: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1170: 'confirming_order_flag : ' ||x_header_control.confirming_order_flag);
1171: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1172: 'acceptance_required_flag : ' ||x_header_control.acceptance_required_flag);
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1167: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1168: 'note_to_vendor : ' ||x_header_control.note_to_vendor);
1169: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1170: 'confirming_order_flag : ' ||x_header_control.confirming_order_flag);
1171: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1172: 'acceptance_required_flag : ' ||x_header_control.acceptance_required_flag);
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1174: 'acceptance_due_date : ' ||x_header_control.acceptance_due_date);
1175: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1169: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1170: 'confirming_order_flag : ' ||x_header_control.confirming_order_flag);
1171: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1172: 'acceptance_required_flag : ' ||x_header_control.acceptance_required_flag);
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1174: 'acceptance_due_date : ' ||x_header_control.acceptance_due_date);
1175: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1176: 'start_date : ' ||x_header_control.start_date);
1177: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1171: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1172: 'acceptance_required_flag : ' ||x_header_control.acceptance_required_flag);
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1174: 'acceptance_due_date : ' ||x_header_control.acceptance_due_date);
1175: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1176: 'start_date : ' ||x_header_control.start_date);
1177: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1178: 'end_date : ' ||x_header_control.end_date);
1179: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1174: 'acceptance_due_date : ' ||x_header_control.acceptance_due_date);
1175: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1176: 'start_date : ' ||x_header_control.start_date);
1177: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1178: 'end_date : ' ||x_header_control.end_date);
1179: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1180: 'cancel_flag : ' ||x_header_control.cancel_flag);
1181: END IF;
1175: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1176: 'start_date : ' ||x_header_control.start_date);
1177: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1178: 'end_date : ' ||x_header_control.end_date);
1179: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1180: 'cancel_flag : ' ||x_header_control.cancel_flag);
1181: END IF;
1182:
1183: IF (g_po_wf_debug = 'Y') THEN
1180: 'cancel_flag : ' ||x_header_control.cancel_flag);
1181: END IF;
1182:
1183: IF (g_po_wf_debug = 'Y') THEN
1184: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1185: 'blanket_total_change : ' ||to_char(x_header_control.blanket_total_change));
1186: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1187: 'amount_limit_change : ' ||to_char(x_header_control.amount_limit_change));
1188: END IF;
1182:
1183: IF (g_po_wf_debug = 'Y') THEN
1184: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1185: 'blanket_total_change : ' ||to_char(x_header_control.blanket_total_change));
1186: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1187: 'amount_limit_change : ' ||to_char(x_header_control.amount_limit_change));
1188: END IF;
1189:
1190: IF (g_po_wf_debug = 'Y') THEN
1187: 'amount_limit_change : ' ||to_char(x_header_control.amount_limit_change));
1188: END IF;
1189:
1190: IF (g_po_wf_debug = 'Y') THEN
1191: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1192: 'po_acknowledged : ' ||x_header_control.po_acknowledged);
1193: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1194: 'po_accepted : ' ||x_header_control.po_accepted);
1195: END IF;
1189:
1190: IF (g_po_wf_debug = 'Y') THEN
1191: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1192: 'po_acknowledged : ' ||x_header_control.po_acknowledged);
1193: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1194: 'po_accepted : ' ||x_header_control.po_accepted);
1195: END IF;
1196:
1197: IF (g_po_wf_debug = 'Y') THEN
1194: 'po_accepted : ' ||x_header_control.po_accepted);
1195: END IF;
1196:
1197: IF (g_po_wf_debug = 'Y') THEN
1198: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1199: '*** Finished: debug_header_control ***');
1200: END IF;
1201: END;
1202: