PACKAGE: APPS.OE_PC_GLOBALS

Source

1 PACKAGE Oe_PC_GLOBALS AUTHID CURRENT_USER AS
2 /* $Header: OEXPPCGS.pls 115.9 2003/10/20 07:07:46 appldev ship $ */
3 
4 
5 -- type declaration
6 
7 -- Constrained Entities
8 -- These constants correspond to the entity_id column on oe_pc_entities_v
9 G_ENTITY_HEADER     		constant number  := 1;
10 G_ENTITY_LINE     			constant number  := 2;
11 G_ENTITY_HEADER_SCREDIT 		constant number  := 5;
12 G_ENTITY_HEADER_ADJ 		constant number  := 6;
13 G_ENTITY_LINE_SCREDIT  		constant number  := 7;
14 G_ENTITY_LINE_ADJ  			constant number  := 8;
15 G_ENTITY_BLANKET_HEADER     		constant number  := 1018;
16 G_ENTITY_BLANKET_LINE     			constant number  := 1019;
17 --serla begin
18 G_ENTITY_HEADER_PAYMENT                 constant number  := 1024;
19 G_ENTITY_LINE_PAYMENT           constant number  := 1025;
20 --serla end
21 -- constants
22 YES     		constant number  := 1;
23 NO      		constant number  := 0;
24 ERROR   		constant number  := -1;
25 MSDATA_LEN	constant number  := 238;
26 
27 -- on operation actions
28 DONT       constant number  := 0;
29 RREASON    constant number  := 1;
30 RHISTORY   constant number  := 2;
31 RVERSN     constant number  := 0.1;
32 VERSNONLY  constant number  := 0.2;
33 
34 -- condition type flag
35 WF_VALIDATION	      constant varchar2(5) := 'WF';
36 TBL_VALIDATION     	constant varchar2(5) := 'TBL';
37 API_VALIDATION	      constant varchar2(5) := 'API';
38 
39 
40 YES_FLAG    constant  varchar2(3) := 'Y';
41 NO_FLAG     constant  varchar2(3) := 'N';
42 
43 CREATE_OP 	constant varchar2(1)  := 'C';
44 RETRIEVE_OP constant varchar2(1)  := 'R';
45 UPDATE_OP	constant varchar2(1)  := 'U';
46 DELETE_OP   constant varchar2(1)  := 'D';
47 CANCEL_OP   constant varchar2(1)  := 'X';
48 SPLIT_OP   constant varchar2(1)  := 'S';
49 EXECUTE_OP  constant varchar2(1)  := 'E';
50 
51 
52 MAX_WRITE_LENGTH  	constant number := 1200;
53 MIN_WRITE_LENGTH  	constant number := 1100;
54 
55 COMMENT           	constant varchar2(1) := 'C';
56 PKG            	      constant varchar2(1) := 'P';
57 SQLSTR          	      constant varchar2(1) := 'S';
58 
59 NEWLINE         	      constant varchar2(10) := '
60 ';  -- *** IMPORTANT : this should be kept in two lines
61 HOST_CONC_PROGRAM       constant varchar2(30) := 'OECOMPF';
62 
63 -- Record And Table Type to return the list of authorized WF
64 -- Roles for a constraint. Used by the function
65 -- Get_Authorized_WF_Roles
66 
67 TYPE Authorized_WF_Role_TYPE IS RECORD
68 ( Name			VARCHAR2(100)
69 , Display_Name		VARCHAR2(240)
70 );
71 
72 TYPE Authorized_WF_Roles_TBL IS TABLE OF Authorized_WF_Role_TYPE
73 	INDEX BY BINARY_INTEGER;
74 
75 -- Bug 2003823:
76 -- Cache the value of profile that controls whether generic update
77 -- constraints apply to DFF or not.
78 G_CHECK_UPDATE_ALL_FOR_DFF VARCHAR2(30) := nvl(FND_PROFILE.VALUE
79                                    ('ONT_PC_UPDATE_ALL_FOR_DFF'),'Y');
80 
81 --  Start of Comments
82 --  API name    Debug_Print
83 --  Type        Private
84 --  Function
85 --
86 --  Pre-reqs
87 --
88 --  Parameters
89 --
90 --  Version     Current version = 1.0
91 --              Initial version = 1.0
92 --
93 --  Notes
94 --
95 --  End of Comments
96 -------------------------------------------
97 Procedure  Debug_Print (
98   p_buffer long
99   ,p_title in varchar2 default null
100 );
101 
102 END Oe_PC_GLOBALS;