[Home] [Help]
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;