[Home] [Help]
PACKAGE: APPS.WIP_FLOWSCHEDULE_UTIL
Source
1 PACKAGE WIP_Flowschedule_Util AUTHID CURRENT_USER AS
2 /* $Header: WIPUFLOS.pls 115.7 2002/11/29 18:45:40 simishra ship $ */
3
4 -- Attributes global constants
5
6 G_ALTERNATE_BOM_DESIGNATOR CONSTANT NUMBER := 1;
7 G_ALTERNATE_ROUT_DESIGNATOR CONSTANT NUMBER := 2;
8 G_ATTRIBUTE1 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE10 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE11 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE12 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE13 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE14 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE15 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE2 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE3 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE4 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE5 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE6 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE7 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE8 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE9 CONSTANT NUMBER := 17;
23 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 18;
24 G_BOM_REVISION CONSTANT NUMBER := 19;
25 G_BOM_REVISION_DATE CONSTANT NUMBER := 20;
26 G_BUILD_SEQUENCE CONSTANT NUMBER := 21;
27 G_CLASS CONSTANT NUMBER := 22;
28 G_COMPLETION_LOCATOR CONSTANT NUMBER := 23;
29 G_COMPLETION_SUBINVENTORY CONSTANT NUMBER := 24;
30 G_CREATED_BY CONSTANT NUMBER := 25;
31 G_CREATION_DATE CONSTANT NUMBER := 26;
32 G_DATE_CLOSED CONSTANT NUMBER := 27;
33 G_DEMAND_CLASS CONSTANT NUMBER := 28;
34 G_DEMAND_SOURCE_DELIVERY CONSTANT NUMBER := 29;
35 G_DEMAND_SOURCE_HEADER CONSTANT NUMBER := 30;
36 G_DEMAND_SOURCE_LINE CONSTANT NUMBER := 31;
37 G_DEMAND_SOURCE_TYPE CONSTANT NUMBER := 32;
38 G_KANBAN_CARD CONSTANT NUMBER := 33;
39 G_LAST_UPDATED_BY CONSTANT NUMBER := 34;
40 G_LAST_UPDATE_DATE CONSTANT NUMBER := 35;
41 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 36;
42 G_LINE CONSTANT NUMBER := 37;
43 G_MATERIAL_ACCOUNT CONSTANT NUMBER := 38;
44 G_MATERIAL_OVERHEAD_ACCOUNT CONSTANT NUMBER := 39;
45 G_MATERIAL_VARIANCE_ACCOUNT CONSTANT NUMBER := 40;
46 G_MPS_NET_QUANTITY CONSTANT NUMBER := 41;
47 G_MPS_SCHEDULED_CPL_DATE CONSTANT NUMBER := 42;
48 G_ORGANIZATION CONSTANT NUMBER := 43;
49 G_OSP_ACCOUNT CONSTANT NUMBER := 44;
50 G_OSP_VARIANCE_ACCOUNT CONSTANT NUMBER := 45;
51 G_OVERHEAD_ACCOUNT CONSTANT NUMBER := 46;
52 G_OVERHEAD_VARIANCE_ACCOUNT CONSTANT NUMBER := 47;
53 G_PLANNED_QUANTITY CONSTANT NUMBER := 48;
54 G_PRIMARY_ITEM CONSTANT NUMBER := 49;
55 G_PROGRAM_APPLICATION CONSTANT NUMBER := 50;
56 G_PROGRAM CONSTANT NUMBER := 51;
57 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 52;
58 G_PROJECT CONSTANT NUMBER := 53;
59 G_QUANTITY_COMPLETED CONSTANT NUMBER := 54;
60 G_REQUEST CONSTANT NUMBER := 55;
61 G_RESOURCE_ACCOUNT CONSTANT NUMBER := 56;
62 G_RESOURCE_VARIANCE_ACCOUNT CONSTANT NUMBER := 57;
63 G_ROUTING_REVISION CONSTANT NUMBER := 58;
64 G_ROUTING_REVISION_DATE CONSTANT NUMBER := 59;
65 G_SCHEDULED_COMPLETION_DATE CONSTANT NUMBER := 60;
66 G_SCHEDULED CONSTANT NUMBER := 61;
67 G_SCHEDULED_START_DATE CONSTANT NUMBER := 62;
68 G_SCHEDULE_GROUP CONSTANT NUMBER := 63;
69 G_SCHEDULE_NUMBER CONSTANT NUMBER := 64;
70 G_STATUS CONSTANT NUMBER := 65;
71 G_STD_COST_ADJ_ACCOUNT CONSTANT NUMBER := 66;
72 G_TASK CONSTANT NUMBER := 67;
73 G_WIP_ENTITY CONSTANT NUMBER := 68;
74 G_MAX_ATTR_ID CONSTANT NUMBER := 69;
75
76
77 -- Function Complete_Record
78
79 FUNCTION Complete_Record
80 ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
81 , p_old_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
82 , p_ForceCopy IN BOOLEAN := FALSE
83 ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type;
84
85 -- Function Convert_Miss_To_Null
86
87 FUNCTION Convert_Miss_To_Null
88 ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
89 ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type;
90
91 -- Procedure Update_Row
92
93 PROCEDURE Update_Row
94 ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
95 );
96
97 -- Procedure Insert_Row
98
99 PROCEDURE Insert_Row
100 ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
101 );
102
103 -- Procedure Delete_Row
104
105 PROCEDURE Delete_Row
106 ( p_schedule_number IN VARCHAR2
107 );
108
109 -- Function Query_Row
110
111 FUNCTION Query_Row
112 ( p_schedule_number IN VARCHAR2
113 ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type;
114
115 FUNCTION Query_Row
116 ( p_wip_entity_id IN NUMBER
117 ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type;
118
119 -- Function Query_Rows
120
121 --
122
123 FUNCTION Query_Rows
124 ( p_schedule_number IN VARCHAR2 :=
125 FND_API.G_MISS_CHAR
126 , p_wip_entity_id IN NUMBER :=
127 FND_API.G_MISS_NUM
128 ) RETURN WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
129
130 -- Procedure lock_Row
131 --
132
133 PROCEDURE Lock_Row
134 ( x_return_status OUT NOCOPY VARCHAR2
135 , p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
136 , x_FlowSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Rec_Type
137 );
138
139
140 FUNCTION Compare( p_FlowSchedule_rec1 IN WIP_Work_Order_PUB.Flowschedule_Rec_Type,
141 p_FlowSchedule_rec2 IN WIP_Work_Order_PUB.Flowschedule_Rec_Type)
142 RETURN BOOLEAN;
143
144
145 PROCEDURE dprintf(p_FlowSchedule_rec IN WIP_Work_Order_PUB.FlowSchedule_Rec_Type);
146
147 END WIP_Flowschedule_Util;