DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on PO_DRAFTS

Line 1: PACKAGE PO_DRAFTS_PVT AUTHID CURRENT_USER AS

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';

Line 2: /* $Header: PO_DRAFTS_PVT.pls 120.30.12020000.5 2013/03/25 08:24:27 mabaig ship $ */

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';

Line 8: g_status_DRAFT CONSTANT PO_DRAFTS.status%TYPE := 'DRAFT';

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';

Line 9: g_status_IN_PROCESS CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';

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';

Line 10: g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';

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:

Line 11: g_status_PDOI_ERROR CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';

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';

Line 12: g_status_COMPLETED CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';

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';

Line 13: g_status_WITHDRAWN CONSTANT PO_DRAFTS.status%TYPE := 'WITHDRAWN';

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';

Line 31: g_draft_type_MOD CONSTANT PO_DRAFTS.draft_type%TYPE := 'MOD'; --

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'; --
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: --

Line 32: g_draft_type_PAR CONSTANT PO_DRAFTS.draft_type%TYPE := 'PAR'; --

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'; --
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';

Line 33: g_draft_type_DOC_CHANGE CONSTANT PO_DRAFTS.draft_type%TYPE := 'DOC_CHANGE';

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';

Line 59: ( draft_id PO_DRAFTS.draft_id%TYPE,

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,

Line 76: draft_type PO_DRAFTS.draft_type%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 --
77: );
78:
79:
80: FUNCTION draft_id_nextval RETURN NUMBER;

Line 402: END PO_DRAFTS_PVT;

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;