PACKAGE: APPS.MRP_GLOBALS

Source

1 PACKAGE MRP_Globals AUTHID CURRENT_USER AS
2 /* $Header: MRPSGLBS.pls 115.2 99/07/16 12:37:22 porting ship $ */
3 
4 --  Procedure Get_Entities_Tbl;
5 --
6 --  Used by generator to avoid overriding or duplicating existing
7 --  entity constants.
8 --
9 --  DO NOT MODIFY
10 
11 PROCEDURE Get_Entities_Tbl;
12 
13 --  Product entity constants.
14 
15 --  START GEN entities
16 G_ENTITY_ALL                   CONSTANT VARCHAR2(30) := 'ALL';
17 G_ENTITY_FLOW_SCHEDULE         CONSTANT VARCHAR2(30) := 'FLOW_SCHEDULE';
18 G_ENTITY_ASSIGNMENT_SET        CONSTANT VARCHAR2(30) := 'ASSIGNMENT_SET';
19 G_ENTITY_ASSIGNMENT            CONSTANT VARCHAR2(30) := 'ASSIGNMENT';
20 G_ENTITY_SOURCING_RULE         CONSTANT VARCHAR2(30) := 'SOURCING_RULE';
21 G_ENTITY_RECEIVING_ORG         CONSTANT VARCHAR2(30) := 'RECEIVING_ORG';
22 G_ENTITY_SHIPPING_ORG          CONSTANT VARCHAR2(30) := 'SHIPPING_ORG';
23 --  END GEN entities
24 
25 --  Operations.
26 
27 G_OPR_CREATE	    CONSTANT	VARCHAR2(30) := 'CREATE';
28 G_OPR_UPDATE	    CONSTANT	VARCHAR2(30) := 'UPDATE';
29 G_OPR_DELETE	    CONSTANT	VARCHAR2(30) := 'DELETE';
30 G_OPR_LOCK	    CONSTANT	VARCHAR2(30) := 'LOCK';
31 G_OPR_NONE	    CONSTANT	VARCHAR2(30) := FND_API.G_MISS_CHAR;
32 
33 --  Max number of defaulting tterations.
34 
35 G_MAX_DEF_ITERATIONS          CONSTANT NUMBER:= 5;
36 
37 --  Index table type used by JVC controllers.
38 
39 TYPE Index_Tbl_Type IS TABLE OF BINARY_INTEGER
40     INDEX BY BINARY_INTEGER;
41 
42 --  API Operation control flags.
43 
44 TYPE Control_Rec_Type IS RECORD
45 (   controlled_operation          BOOLEAN := FALSE
46 ,   default_attributes            BOOLEAN := TRUE
47 ,   change_attributes             BOOLEAN := TRUE
48 ,   validate_entity               BOOLEAN := TRUE
49 ,   write_to_db                   BOOLEAN := TRUE
50 ,   process                       BOOLEAN := TRUE
51 ,   process_entity                VARCHAR2(30) := G_ENTITY_ALL
52 ,   clear_api_cache               BOOLEAN := TRUE
53 ,   clear_api_requests            BOOLEAN := TRUE
54 ,   request_category              VARCHAR2(30):= NULL
55 ,   request_name                  VARCHAR2(30):= NULL
56 );
57 
58 --  Variable representing missing control record.
59 
60 G_MISS_CONTROL_REC            Control_Rec_Type;
61 
62 --  API request record type.
63 
64 TYPE Request_Rec_Type IS RECORD
65 (   entity                        VARCHAR2(30) := NULL
66 ,   step                          VARCHAR2(30) := NULL
67 ,   name                          VARCHAR2(30) := NULL
68 ,   category                      VARCHAR2(30) := NULL
69 ,   processed                     BOOLEAN := FALSE
70 ,   attribute1                    VARCHAR2(240) := NULL
71 ,   attribute2                    VARCHAR2(240) := NULL
72 ,   attribute3                    VARCHAR2(240) := NULL
73 ,   attribute4                    VARCHAR2(240) := NULL
74 ,   attribute5                    VARCHAR2(240) := NULL
75 );
76 
77 --  API Request table type.
78 
79 TYPE Request_Tbl_Type IS TABLE OF Request_Rec_Type
80     INDEX BY BINARY_INTEGER;
81 
82 --  Initialize control record.
83 
84 FUNCTION Init_Control_Rec
85 (   p_operation                     IN  VARCHAR2
86 ,   p_control_rec                   IN  Control_Rec_Type
87 )RETURN Control_Rec_Type;
88 
89 --  Function Equal
90 --  Number comparison.
91 
92 FUNCTION Equal
93 (   p_attribute1                    IN  NUMBER
94 ,   p_attribute2                    IN  NUMBER
95 )RETURN BOOLEAN;
96 
97 --  Varchar2 comparison.
98 
99 FUNCTION Equal
100 (   p_attribute1                    IN  VARCHAR2
101 ,   p_attribute2                    IN  VARCHAR2
102 )RETURN BOOLEAN;
103 
104 --  Date comparison.
105 
106 FUNCTION Equal
107 (   p_attribute1                    IN  DATE
108 ,   p_attribute2                    IN  DATE
109 )RETURN BOOLEAN;
110 
111 END MRP_Globals;