1: PACKAGE PO_DRAFTS_PVT AUTHID CURRENT_USER AS
2: /* $Header: PO_DRAFTS_PVT.pls 120.30.12020000.5 2013/03/25 08:24:27 mabaig ship $ */
3:
4: g_ACCEPT_ALL CONSTANT VARCHAR2(10) := 'ACCEPT_ALL';
5: g_REJECT_ALL CONSTANT VARCHAR2(10) := 'REJECT_ALL';
1: PACKAGE PO_DRAFTS_PVT AUTHID CURRENT_USER AS
2: /* $Header: PO_DRAFTS_PVT.pls 120.30.12020000.5 2013/03/25 08:24:27 mabaig ship $ */
3:
4: g_ACCEPT_ALL CONSTANT VARCHAR2(10) := 'ACCEPT_ALL';
5: g_REJECT_ALL CONSTANT VARCHAR2(10) := 'REJECT_ALL';
6: g_LINE_DISP CONSTANT VARCHAR2(10) := 'LINE_DISP';
4: g_ACCEPT_ALL CONSTANT VARCHAR2(10) := 'ACCEPT_ALL';
5: g_REJECT_ALL CONSTANT VARCHAR2(10) := 'REJECT_ALL';
6: g_LINE_DISP CONSTANT VARCHAR2(10) := 'LINE_DISP';
7:
8: g_status_DRAFT CONSTANT PO_DRAFTS.status%TYPE := 'DRAFT';
9: g_status_IN_PROCESS CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';
10: g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';
11: g_status_PDOI_ERROR CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';
12: g_status_COMPLETED CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';
5: g_REJECT_ALL CONSTANT VARCHAR2(10) := 'REJECT_ALL';
6: g_LINE_DISP CONSTANT VARCHAR2(10) := 'LINE_DISP';
7:
8: g_status_DRAFT CONSTANT PO_DRAFTS.status%TYPE := 'DRAFT';
9: g_status_IN_PROCESS CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';
10: g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';
11: g_status_PDOI_ERROR CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';
12: g_status_COMPLETED CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';
13: g_status_WITHDRAWN CONSTANT PO_DRAFTS.status%TYPE := 'WITHDRAWN';
6: g_LINE_DISP CONSTANT VARCHAR2(10) := 'LINE_DISP';
7:
8: g_status_DRAFT CONSTANT PO_DRAFTS.status%TYPE := 'DRAFT';
9: g_status_IN_PROCESS CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';
10: g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';
11: g_status_PDOI_ERROR CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';
12: g_status_COMPLETED CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';
13: g_status_WITHDRAWN CONSTANT PO_DRAFTS.status%TYPE := 'WITHDRAWN';
14:
7:
8: g_status_DRAFT CONSTANT PO_DRAFTS.status%TYPE := 'DRAFT';
9: g_status_IN_PROCESS CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';
10: g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';
11: g_status_PDOI_ERROR CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';
12: g_status_COMPLETED CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';
13: g_status_WITHDRAWN CONSTANT PO_DRAFTS.status%TYPE := 'WITHDRAWN';
14:
15: g_call_mod_HTML_UI CONSTANT VARCHAR2(30) := 'HTML UI';
8: g_status_DRAFT CONSTANT PO_DRAFTS.status%TYPE := 'DRAFT';
9: g_status_IN_PROCESS CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';
10: g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';
11: g_status_PDOI_ERROR CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';
12: g_status_COMPLETED CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';
13: g_status_WITHDRAWN CONSTANT PO_DRAFTS.status%TYPE := 'WITHDRAWN';
14:
15: g_call_mod_HTML_UI CONSTANT VARCHAR2(30) := 'HTML UI';
16: g_call_mod_PDOI CONSTANT VARCHAR2(30) := 'PDOI';
9: g_status_IN_PROCESS CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';
10: g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';
11: g_status_PDOI_ERROR CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';
12: g_status_COMPLETED CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';
13: g_status_WITHDRAWN CONSTANT PO_DRAFTS.status%TYPE := 'WITHDRAWN';
14:
15: g_call_mod_HTML_UI CONSTANT VARCHAR2(30) := 'HTML UI';
16: g_call_mod_PDOI CONSTANT VARCHAR2(30) := 'PDOI';
17: g_call_mod_API CONSTANT VARCHAR2(30) := 'API';
27: g_chg_accepted_flag_ACCEPT CONSTANT VARCHAR2(1) := 'Y';
28: g_chg_accepted_flag_REJECT CONSTANT VARCHAR2(1) := 'N';
29: g_chg_accepted_flag_NOTIFY CONSTANT VARCHAR2(1) := 'I'; -- bug5149827
30:
31: g_draft_type_MOD CONSTANT PO_DRAFTS.draft_type%TYPE := 'MOD'; --
33: g_draft_type_DOC_CHANGE CONSTANT PO_DRAFTS.draft_type%TYPE := 'DOC_CHANGE';
34:
35: --
28: g_chg_accepted_flag_REJECT CONSTANT VARCHAR2(1) := 'N';
29: g_chg_accepted_flag_NOTIFY CONSTANT VARCHAR2(1) := 'I'; -- bug5149827
30:
31: g_draft_type_MOD CONSTANT PO_DRAFTS.draft_type%TYPE := 'MOD'; --
32: g_draft_type_PAR CONSTANT PO_DRAFTS.draft_type%TYPE := 'PAR'; --
34:
35: --
36: G_LOCK_HEADER_ENTITY CONSTANT VARCHAR2(30) := 'PO_HEADER';
29: g_chg_accepted_flag_NOTIFY CONSTANT VARCHAR2(1) := 'I'; -- bug5149827
30:
31: g_draft_type_MOD CONSTANT PO_DRAFTS.draft_type%TYPE := 'MOD'; --
32: g_draft_type_PAR CONSTANT PO_DRAFTS.draft_type%TYPE := 'PAR'; --
33: g_draft_type_DOC_CHANGE CONSTANT PO_DRAFTS.draft_type%TYPE := 'DOC_CHANGE';
34:
35: --
36: G_LOCK_HEADER_ENTITY CONSTANT VARCHAR2(30) := 'PO_HEADER';
37: G_LOCK_LINE_ENTITY CONSTANT VARCHAR2(30) := 'PO_LINE';
55: G_LOCK_LINE_ATTACH_ENTITY CONSTANT VARCHAR2(30) := 'PO_LINE_ATTACH';
56: G_LOCK_SHIPMENT_ATTACH_ENTITY CONSTANT VARCHAR2(30) := 'PO_LINE_LOCATION_ATTACH';
57:
58: TYPE DRAFT_INFO_REC_TYPE IS RECORD
59: ( draft_id PO_DRAFTS.draft_id%TYPE,
60: po_header_id PO_HEADERS_ALL.po_header_id%TYPE,
61: doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE,
62: doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE,
63: ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE,
72: attr_values_changed VARCHAR2(1),
73: attr_values_tlp_changed VARCHAR2(1),
74: price_adj_changed VARCHAR2(1), --Enhanced Pricing
75: exhibits_changed VARCHAR2(1), -- Elins project
76: draft_type PO_DRAFTS.draft_type%TYPE --
78:
79:
80: FUNCTION draft_id_nextval RETURN NUMBER;
398: PROCEDURE delete_line_ucas(
399: p_po_draft_id IN NUMBER,
400: po_line_ids_tbl IN PO_TBL_NUMBER);
401: --UCA Revert Action Changes End
402: END PO_DRAFTS_PVT;