[Home] [Help]
PACKAGE: APPS.WIP_DISCRETEJOB_UTIL
Source
1 PACKAGE WIP_Discretejob_Util AS
2 /* $Header: WIPUWDJS.pls 120.3 2005/10/24 17:15:39 sjchen 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_REFERENCE CONSTANT NUMBER := 19;
25 G_BOM_REVISION CONSTANT NUMBER := 20;
26 G_BOM_REVISION_DATE CONSTANT NUMBER := 21;
27 G_BUILD_SEQUENCE CONSTANT NUMBER := 22;
28 G_CLASS CONSTANT NUMBER := 23;
29 G_COMMON_BOM_SEQUENCE CONSTANT NUMBER := 24;
30 G_COMMON_ROUT_SEQUENCE CONSTANT NUMBER := 25;
31 G_COMPLETION_LOCATOR CONSTANT NUMBER := 26;
32 G_COMPLETION_SUBINVENTORY CONSTANT NUMBER := 27;
33 G_CREATED_BY CONSTANT NUMBER := 28;
34 G_CREATION_DATE CONSTANT NUMBER := 29;
35 G_DATE_CLOSED CONSTANT NUMBER := 30;
36 G_DATE_COMPLETED CONSTANT NUMBER := 31;
37 G_DATE_RELEASED CONSTANT NUMBER := 32;
38 G_DEMAND_CLASS CONSTANT NUMBER := 33;
39 G_DESCRIPTION CONSTANT NUMBER := 34;
40 G_FIRM_PLANNED CONSTANT NUMBER := 35;
41 G_JOB_TYPE CONSTANT NUMBER := 36;
42 G_KANBAN_CARD CONSTANT NUMBER := 37;
43 G_LAST_UPDATED_BY CONSTANT NUMBER := 38;
44 G_LAST_UPDATE_DATE CONSTANT NUMBER := 39;
45 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 40;
46 G_LINE CONSTANT NUMBER := 41;
47 G_LOT_NUMBER CONSTANT NUMBER := 42;
48 G_MATERIAL_ACCOUNT CONSTANT NUMBER := 43;
49 G_MATERIAL_OVERHEAD_ACCOUNT CONSTANT NUMBER := 44;
50 G_MATERIAL_VARIANCE_ACCOUNT CONSTANT NUMBER := 45;
51 G_MPS_NET_QUANTITY CONSTANT NUMBER := 46;
52 G_MPS_SCHEDULED_CPL_DATE CONSTANT NUMBER := 47;
53 G_NET_QUANTITY CONSTANT NUMBER := 48;
54 G_ORGANIZATION CONSTANT NUMBER := 49;
55 G_OSP_ACCOUNT CONSTANT NUMBER := 50;
56 G_OSP_VARIANCE_ACCOUNT CONSTANT NUMBER := 51;
57 G_OVERCPL_TOLERANCE_TYPE CONSTANT NUMBER := 52;
58 G_OVERCPL_TOLERANCE_VALUE CONSTANT NUMBER := 53;
59 G_OVERHEAD_ACCOUNT CONSTANT NUMBER := 54;
60 G_OVERHEAD_VARIANCE_ACCOUNT CONSTANT NUMBER := 55;
61 G_PRIMARY_ITEM CONSTANT NUMBER := 56;
62 G_PROGRAM_APPLICATION CONSTANT NUMBER := 57;
63 G_PROGRAM CONSTANT NUMBER := 58;
64 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 59;
65 G_PROJECT_COSTED CONSTANT NUMBER := 60;
66 G_PROJECT CONSTANT NUMBER := 61;
67 G_QUANTITY_COMPLETED CONSTANT NUMBER := 62;
68 G_QUANTITY_SCRAPPED CONSTANT NUMBER := 63;
69 G_REQUEST CONSTANT NUMBER := 64;
70 G_RESOURCE_ACCOUNT CONSTANT NUMBER := 65;
71 G_RESOURCE_VARIANCE_ACCOUNT CONSTANT NUMBER := 66;
72 G_ROUTING_REFERENCE CONSTANT NUMBER := 67;
73 G_ROUTING_REVISION CONSTANT NUMBER := 68;
74 G_ROUTING_REVISION_DATE CONSTANT NUMBER := 69;
75 G_SCHEDULED_COMPLETION_DATE CONSTANT NUMBER := 70;
76 G_SCHEDULED_START_DATE CONSTANT NUMBER := 71;
77 G_SCHEDULE_GROUP CONSTANT NUMBER := 72;
78 G_SOURCE CONSTANT NUMBER := 73;
79 G_SOURCE_LINE CONSTANT NUMBER := 74;
80 G_START_QUANTITY CONSTANT NUMBER := 75;
81 G_STATUS_TYPE CONSTANT NUMBER := 76;
82 G_STD_COST_ADJ_ACCOUNT CONSTANT NUMBER := 77;
83 G_TASK CONSTANT NUMBER := 78;
84 G_WIP_ENTITY CONSTANT NUMBER := 79;
85 G_WIP_SUPPLY_TYPE CONSTANT NUMBER := 80;
86 G_MAX_ATTR_ID CONSTANT NUMBER := 81;
87
88 -- Procedure Clear_Dependent_Attr
89
90 -- Function Complete_Record
91
92 FUNCTION Complete_Record
93 ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
94 , p_old_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
95 , p_ForceCopy IN BOOLEAN := NULL
96 ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type;
97
98 -- Function Convert_Miss_To_Null
99
100 FUNCTION Convert_Miss_To_Null
101 ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
102 ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type;
103
104 -- Procedure Update_Row
105
106 PROCEDURE Update_Row
107 ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
108 );
109
110 -- Procedure Insert_Row
111
112 PROCEDURE Insert_Row
113 ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
114 );
115
116 -- Procedure Delete_Row
117
118 PROCEDURE Delete_Row
119 ( p_wip_entity_id IN NUMBER
120 );
121
122 -- Function Query_Row
123
124 FUNCTION Query_Row
125 ( p_wip_entity_id IN NUMBER
126 ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type;
127
128 -- Function Query_Rows
129
130 --
131
132 FUNCTION Query_Rows
133 ( p_wip_entity_id IN NUMBER :=
134 NULL
135 ) RETURN WIP_Work_Order_PUB.Discretejob_Tbl_Type;
136
137 -- Procedure lock_Row
138 --
139
140 PROCEDURE Lock_Row
141 ( x_return_status OUT NOCOPY VARCHAR2
142 , p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
143 , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type
144 );
145
146 FUNCTION Compare
147 ( p_DiscreteJob_rec1 IN WIP_Work_Order_PUB.Discretejob_Rec_Type
148 , p_DiscreteJob_rec2 IN WIP_Work_Order_PUB.Discretejob_Rec_Type
149 ) RETURN BOOLEAN;
150
151 PROCEDURE dprintf
152 ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type);
153
154 /**
155 * Update miscellaneous details.
156 */
157 PROCEDURE update_job_details(p_org_id IN NUMBER,
158 p_wip_entity_id IN NUMBER,
159 p_due_date IN DATE,
160 p_line_id IN NUMBER,
161 p_schedule_group_id IN NUMBER,
162 p_build_sequence IN NUMBER,
163 p_expedited IN VARCHAR2,
164 p_initialize IN VARCHAR2,
165 x_err_msg OUT NOCOPY VARCHAR2,
166 x_return_status OUT NOCOPY VARCHAR2);
167
168
169 END WIP_Discretejob_Util;