[Home] [Help]
PACKAGE: APPS.WIP_REPSCHEDULE_UTIL
Source
1 PACKAGE WIP_Repschedule_Util AUTHID CURRENT_USER AS
2 /* $Header: WIPUWRSS.pls 115.7 2002/11/29 13:32:56 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_COMMON_BOM_SEQUENCE CONSTANT NUMBER := 21;
27 G_COMMON_ROUT_SEQUENCE CONSTANT NUMBER := 22;
28 G_CREATED_BY CONSTANT NUMBER := 23;
29 G_CREATION_DATE CONSTANT NUMBER := 24;
30 G_DAILY_PRODUCTION_RATE CONSTANT NUMBER := 25;
31 G_DATE_CLOSED CONSTANT NUMBER := 26;
32 G_DATE_RELEASED CONSTANT NUMBER := 27;
33 G_DEMAND_CLASS CONSTANT NUMBER := 28;
34 G_DESCRIPTION CONSTANT NUMBER := 29;
35 G_FIRM_PLANNED CONSTANT NUMBER := 30;
36 G_FIRST_UNIT_CPL_DATE CONSTANT NUMBER := 31;
37 G_FIRST_UNIT_START_DATE CONSTANT NUMBER := 32;
38 G_LAST_UNIT_CPL_DATE CONSTANT NUMBER := 33;
39 G_LAST_UNIT_START_DATE CONSTANT NUMBER := 34;
40 G_LAST_UPDATED_BY CONSTANT NUMBER := 35;
41 G_LAST_UPDATE_DATE CONSTANT NUMBER := 36;
42 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 37;
43 G_LINE CONSTANT NUMBER := 38;
44 G_MATERIAL_ACCOUNT CONSTANT NUMBER := 39;
45 G_MATERIAL_OVERHEAD_ACCOUNT CONSTANT NUMBER := 40;
46 G_MATERIAL_VARIANCE_ACCOUNT CONSTANT NUMBER := 41;
47 G_ORGANIZATION CONSTANT NUMBER := 42;
48 G_OSP_ACCOUNT CONSTANT NUMBER := 43;
49 G_OSP_VARIANCE_ACCOUNT CONSTANT NUMBER := 44;
50 G_OVERHEAD_ACCOUNT CONSTANT NUMBER := 45;
51 G_OVERHEAD_VARIANCE_ACCOUNT CONSTANT NUMBER := 46;
52 G_PROCESSING_WORK_DAYS CONSTANT NUMBER := 47;
53 G_PROGRAM_APPLICATION CONSTANT NUMBER := 48;
54 G_PROGRAM CONSTANT NUMBER := 49;
55 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 50;
56 G_QUANTITY_COMPLETED CONSTANT NUMBER := 51;
57 G_REPETITIVE_SCHEDULE CONSTANT NUMBER := 52;
58 G_REQUEST CONSTANT NUMBER := 53;
59 G_RESOURCE_ACCOUNT CONSTANT NUMBER := 54;
60 G_RESOURCE_VARIANCE_ACCOUNT CONSTANT NUMBER := 55;
61 G_ROUTING_REVISION CONSTANT NUMBER := 56;
62 G_ROUTING_REVISION_DATE CONSTANT NUMBER := 57;
63 G_STATUS_TYPE CONSTANT NUMBER := 58;
64 G_WIP_ENTITY CONSTANT NUMBER := 59;
65 G_KANBAN_CARD CONSTANT NUMBER := 60;
66 G_MAX_ATTR_ID CONSTANT NUMBER := 61;
67
68
69 -- Function Complete_Record
70
71 FUNCTION Complete_Record
72 ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
73 , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
74 , p_ForceCopy IN BOOLEAN := NULL
75 ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
76
77 -- Function Convert_Miss_To_Null
78
79 FUNCTION Convert_Miss_To_Null
80 ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
81 ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
82
83 -- Procedure Update_Row
84
85 PROCEDURE Update_Row
86 ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
87 );
88
89 -- Procedure Insert_Row
90
91 PROCEDURE Insert_Row
92 ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
93 );
94
95 -- Procedure Delete_Row
96
97 PROCEDURE Delete_Row
98 ( p_repetitive_schedule_id IN NUMBER
99 );
100
101 -- Function Query_Row
102
103 FUNCTION Query_Row
104 ( p_repetitive_schedule_id IN NUMBER
105 ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
106
107 FUNCTION Query_Row
108 ( p_wip_entity_id IN NUMBER
109 ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
110
111 -- Function Query_Rows
112
113 --
114
115 FUNCTION Query_Rows
116 ( p_repetitive_schedule_id IN NUMBER :=
117 NULL
118 , p_wip_entity_id IN NUMBER :=
119 NULL
120 ) RETURN WIP_Work_Order_PUB.Repschedule_Tbl_Type;
121
122 -- Procedure lock_Row
123 --
124
125 PROCEDURE Lock_Row
126 ( x_return_status OUT NOCOPY VARCHAR2
127 , p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
128 , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
129 );
130
131 FUNCTION Compare
132 ( p_RepSchedule_rec1 IN WIP_Work_Order_PUB.Repschedule_Rec_Type
133 , p_RepSchedule_rec2 IN WIP_Work_Order_PUB.Repschedule_Rec_Type
134 ) RETURN Boolean;
135
136 PROCEDURE dprintf
137 ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
138 );
139
140 END WIP_Repschedule_Util;