[Home] [Help]
PACKAGE: APPS.PO_PDOI_CONSTANTS
Source
1 PACKAGE PO_PDOI_CONSTANTS AUTHID CURRENT_USER AS
2 /* $Header: PO_PDOI_CONSTANTS.pls 120.7.12020000.4 2013/03/29 06:29:01 xueche ship $ */
3
4 -- Action Type constants
5 g_ACTION_ORIGINAL CONSTANT VARCHAR2(20) := 'ORIGINAL';
6 g_ACTION_REPLACE CONSTANT VARCHAR2(20) := 'REPLACE';
7 g_ACTION_ADD CONSTANT VARCHAR2(20) := 'ADD';
8 g_ACTION_UPDATE CONSTANT VARCHAR2(20) := 'UPDATE';
9
10 -- Document Type constants
11 g_DOC_TYPE_BLANKET CONSTANT VARCHAR2(20) := 'BLANKET';
12 g_DOC_TYPE_STANDARD CONSTANT VARCHAR2(20) := 'STANDARD';
13 g_DOC_TYPE_QUOTATION CONSTANT VARCHAR2(20) := 'QUOTATION';
14 g_DOC_TYPE_RFQ CONSTANT VARCHAR2(20) := 'RFQ';
15 g_DOC_TYPE_CONTRACT CONSTANT VARCHAR2(20) := 'CONTRACT'; --CLM PDOI Integration
16
17 -- Process Code constants
18 g_PROCESS_CODE_NOTIFIED CONSTANT VARCHAR2(25) := 'NOTIFIED';
19 g_PROCESS_CODE_PENDING CONSTANT VARCHAR2(25) := 'PENDING';
20 g_PROCESS_CODE_REJECTED CONSTANT VARCHAR2(25) := 'REJECTED';
21 g_PROCESS_CODE_ACCEPTED CONSTANT VARCHAR2(25) := 'ACCEPTED';
22 g_PROCESS_CODE_IN_PROCESS CONSTANT VARCHAR2(25) := 'IN PROCESS';
23 g_PROCESS_CODE_VAL_AND_REJECT CONSTANT VARCHAR2(25) := 'VALIDATE AND REJECT';
24 g_PROCESS_CODE_OBSOLETE CONSTANT VARCHAR2(25) := 'OBSOLETE';
25
26 -- Default Bath Size
27 --bug 13343886 start - Batch Size and gather Stats variable will be set in POXPDOI.sql.
28 g_DEF_BATCH_SIZE NUMBER := 5000;
29
30 --Default Gather Stats
31 g_GATHER_STATS VARCHAR2(1) := 'N';
32 --bug 13343886 end
33
34 -- #Del constants for each data type
35 g_NULLIFY_NUM CONSTANT NUMBER := FND_API.G_NULL_NUM;
36 g_NULLIFY_DATE CONSTANT DATE := FND_API.G_NULL_DATE;
37 g_NULLIFY_VARCHAR CONSTANT VARCHAR2(1) := FND_API.G_NULL_CHAR;
38
39 -- Constants to identify different types of line cursors
40 g_LINE_CSR_ADD CONSTANT NUMBER := 0;
41 g_LINE_CSR_FORCE_ADD CONSTANT NUMBER := 1;
42 g_LINE_CSR_SYNC CONSTANT NUMBER := 2;
43 g_LINE_CSR_SYNC_ON_DESC CONSTANT NUMBER := 3;
44 g_LINE_CSR_INFO_LINE_ADD CONSTANT NUMBER := 4; --PDOI CLM Project
45
46 -- Constants that define id type
47 g_INTERFACE_HEADER_ID CONSTANT VARCHAR2(30) := 'INTERFACE_HEADER_ID';
48 g_INTERFACE_LINE_ID CONSTANT VARCHAR2(30) := 'INTERFACE_LINE_ID';
49 g_INTERFACE_LINE_LOCATION_ID CONSTANT VARCHAR2(30) :=
50 'INTERFACE_LINE_LOCATION_ID';
51 g_INTERFACE_DISTRIBUTION_ID CONSTANT VARCHAR2(30) :=
52 'INTERFACE_DISTRIBUTION_ID';
53 g_PRICE_DIFF_INTERFACE_ID CONSTANT VARCHAR2(30) := 'PRICE_DIFF_INTERFACE_ID';
54 g_INTERFACE_ATTR_VALUES_ID CONSTANT VARCHAR2(30) := 'INTERFACE_ATTR_VALUES_ID';
55 g_INTERFACE_ATTR_VALUES_TLP_ID CONSTANT VARCHAR2(30) :=
56 'INTERFACE_ATTR_VALUES_TLP_ID';
57
58 -- Calling Module
59 g_CALL_MOD_CATALOG_UPLOAD CONSTANT VARCHAR2(30) := 'CATALOG UPLOAD';
60 g_CALL_MOD_CONCURRENT_PRGM CONSTANT VARCHAR2(30) := 'CONCURRENT PROGRAM';
61 g_CALL_MOD_UNKNOWN CONSTANT VARCHAR2(30) := 'UNKNOWN';
62 g_CALL_MOD_PRICE_TOL_RESP CONSTANT VARCHAR2(30) := 'PRICE TOLERANCE RESPONSE';
63
64
65 -- Approval Methods
66 g_APPR_METHOD_NONE CONSTANT VARCHAR2(30) := 'NONE';
67 g_APPR_METHOD_INIT_APPROVAL CONSTANT VARCHAR2(30) := 'INITIATE APPROVAL';
68 g_APPR_METHOD_AUTO_APPROVE CONSTANT VARCHAR2(30) := 'AUTO APPROVE';
69
70 -- Exception Aliases
71 g_SNAPSHOT_TOO_OLD EXCEPTION;
72 PRAGMA EXCEPTION_INIT(g_SNAPSHOT_TOO_OLD, -1555);
73
74
75 -- Name of the modules for timing
76 g_T_PDOI_ALL CONSTANT VARCHAR2(30) := 'PDOI_ALL';
77 g_T_PREPROCESSING CONSTANT VARCHAR2(30) := 'PREPROCESSING';
78 g_T_HEADER_GROUPING CONSTANT VARCHAR2(30) := 'HEADER_GROUPING';
79 g_T_MAIN_PROCESSING CONSTANT VARCHAR2(30) := 'MAIN_PROCESSING';
80 g_T_POSTPROCESSING CONSTANT VARCHAR2(30) := 'POSTPROCESSING';
81 g_T_GATHER_TBL_STAT CONSTANT VARCHAR2(30) := 'GATHER_TBL_STAT';
82 g_T_ITEM_CREATION CONSTANT VARCHAR2(30) := 'ITEM_CREATION';
83 g_T_HEADER_PROCESS CONSTANT VARCHAR2(30) := 'HEADER_PROCESS';
84 g_T_HEADER_DERIVE CONSTANT VARCHAR2(30) := 'HEADER_DERIVE';
85 g_T_HEADER_DEFAULT CONSTANT VARCHAR2(30) := 'HEADER_DEFAULT';
86 g_T_HEADER_VALIDATE CONSTANT VARCHAR2(30) := 'HEADER_VALIDATE';
87 g_T_HEADER_INSERT CONSTANT VARCHAR2(30) := 'HEADER_INSERT';
88 g_T_LINE_PROCESS CONSTANT VARCHAR2(30) := 'LINE_PROCESS';
89 g_T_LINE_DERIVE CONSTANT VARCHAR2(30) := 'LINE_DERIVE';
90 g_T_LINE_DEFAULT CONSTANT VARCHAR2(30) := 'LINE_DEFAULT';
91 g_T_LINE_VALIDATE CONSTANT VARCHAR2(30) := 'LINE_VALIDATE';
92 g_T_LINE_MATCH CONSTANT VARCHAR2(30) := 'LINE_MATCH';
93 g_T_LINE_UNIQUENESS_CHECK CONSTANT VARCHAR2(30) := 'LINE_UNIQUENESS_CHECK';
94 g_T_LINE_INSERT CONSTANT VARCHAR2(30) := 'LINE_INSERT';
95 g_T_LINE_UPDATE CONSTANT VARCHAR2(30) := 'LINE_UPDATE';
96 g_T_LINE_LOC_PROCESS CONSTANT VARCHAR2(30) := 'LINE_LOC_PROCESS';
97 g_T_LINE_LOC_DERIVE CONSTANT VARCHAR2(30) := 'LINE_LOC_DERIVE';
98 g_T_LINE_LOC_DEFAULT CONSTANT VARCHAR2(30) := 'LINE_LOC_DEFAULT';
99 g_T_LINE_LOC_VALIDATE CONSTANT VARCHAR2(30) := 'LINE_LOC_VALIDATE';
100 g_T_LINE_LOC_INSERT CONSTANT VARCHAR2(30) := 'LINE_LOC_INSERT';
101 g_T_DIST_PROCESS CONSTANT VARCHAR2(30) := 'DIST_PROCESS';
102 g_T_DIST_DERIVE CONSTANT VARCHAR2(30) := 'DIST_DERIVE';
103 g_T_DIST_DEFAULT CONSTANT VARCHAR2(30) := 'DIST_DEFAULT';
104 g_T_DIST_VALIDATE CONSTANT VARCHAR2(30) := 'DIST_VALIDATE';
105 g_T_DIST_INSERT CONSTANT VARCHAR2(30) := 'DIST_INSERT';
106 g_T_PRICE_DIFF_PROCESS CONSTANT VARCHAR2(30) := 'PRICE_DIFF_PROCESS';
107 g_T_PRICE_DIFF_DEFAULT CONSTANT VARCHAR2(30) := 'PRICE_DIFF_DEFAULT';
108 g_T_PRICE_DIFF_VALIDATE CONSTANT VARCHAR2(30) := 'PRICE_DIFF_VALIDATE';
109 g_T_PRICE_DIFF_INSERT CONSTANT VARCHAR2(30) := 'PRICE_DIFF_INSERT';
110 g_T_ATTR_PROCESS CONSTANT VARCHAR2(30) := 'ATTR_PROCESS';
111 g_T_ATTR_VALUES_INSERT CONSTANT VARCHAR2(30) := 'ATTR_VALUES_INSERT';
112 g_T_ATTR_VALUES_TLP_INSERT CONSTANT VARCHAR2(30) := 'ATTR_VALUES_TLP_INSERT';
113
114
115
116 -- Name of the interface tables
117 g_PO_HEADERS_INTERFACE CONSTANT VARCHAR2(30) := 'PO_HEADERS_INTERFACE';
118 g_PO_LINES_INTERFACE CONSTANT VARCHAR2(30) := 'PO_LINES_INTERFACE';
119 g_PO_LINE_LOCATIONS_INTERFACE CONSTANT VARCHAR2(30) := 'PO_LINE_LOCATIONS_INTERFACE';
120 g_PO_DISTRIBUTIONS_INTERFACE CONSTANT VARCHAR2(30) := 'PO_DISTRIBUTIONS_INTERFACE';
121 g_PO_PRICE_DIFF_INTERFACE CONSTANT VARCHAR2(30) := 'PO_PRICE_DIFF_INTERFACE';
122
123
124 END PO_PDOI_CONSTANTS;