[Home] [Help]
PACKAGE: APPS.WIP_RES_UTIL
Source
1 PACKAGE WIP_Res_Util AUTHID CURRENT_USER AS
2 /* $Header: WIPURESS.pls 115.5 2002/12/01 13:58:50 simishra ship $ */
3
4 -- Attributes global constants
5
6 G_ACCT_PERIOD CONSTANT NUMBER := 1;
7 G_ACTIVITY CONSTANT NUMBER := 2;
8 G_ACTIVITY_NAME CONSTANT NUMBER := 3;
9 G_ACTUAL_RESOURCE_RATE CONSTANT NUMBER := 4;
10 G_ATTRIBUTE1 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE10 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE11 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE12 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE13 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE14 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE15 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE2 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE3 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE4 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE5 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE6 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE7 CONSTANT NUMBER := 17;
23 G_ATTRIBUTE8 CONSTANT NUMBER := 18;
24 G_ATTRIBUTE9 CONSTANT NUMBER := 19;
25 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 20;
26 G_AUTOCHARGE_TYPE CONSTANT NUMBER := 21;
27 G_BASIS_TYPE CONSTANT NUMBER := 22;
28 G_COMPLETION_TRANSACTION CONSTANT NUMBER := 23;
29 G_CREATED_BY CONSTANT NUMBER := 24;
30 G_CREATED_BY_NAME CONSTANT NUMBER := 25;
31 G_CREATION_DATE CONSTANT NUMBER := 26;
32 G_CURRENCY_ACTUAL_RSC_RATE CONSTANT NUMBER := 27;
33 G_CURRENCY CONSTANT NUMBER := 28;
34 G_CURRENCY_CONVERSION_DATE CONSTANT NUMBER := 29;
35 G_CURRENCY_CONVERSION_RATE CONSTANT NUMBER := 30;
36 G_CURRENCY_CONVERSION_TYPE CONSTANT NUMBER := 31;
37 G_DEPARTMENT_CODE CONSTANT NUMBER := 32;
38 G_DEPARTMENT_ID CONSTANT NUMBER := 33;
39 G_EMPLOYEE CONSTANT NUMBER := 34;
40 G_EMPLOYEE_NUM CONSTANT NUMBER := 35;
41 G_ENTITY_TYPE CONSTANT NUMBER := 36;
42 G_GROUP CONSTANT NUMBER := 37;
43 G_LAST_UPDATED_BY CONSTANT NUMBER := 38;
44 G_LAST_UPDATED_BY_NAME CONSTANT NUMBER := 39;
45 G_LAST_UPDATE_DATE CONSTANT NUMBER := 40;
46 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 41;
47 G_LINE_CODE CONSTANT NUMBER := 42;
48 G_LINE_ID CONSTANT NUMBER := 43;
49 G_MOVE_TRANSACTION CONSTANT NUMBER := 44;
50 G_OPERATION_SEQ_NUM CONSTANT NUMBER := 45;
51 G_ORGANIZATION_CODE CONSTANT NUMBER := 46;
52 G_ORGANIZATION_ID CONSTANT NUMBER := 47;
53 G_PO_HEADER CONSTANT NUMBER := 48;
54 G_PO_LINE CONSTANT NUMBER := 49;
55 G_PRIMARY_ITEM CONSTANT NUMBER := 50;
56 G_PRIMARY_QUANTITY CONSTANT NUMBER := 51;
57 G_PRIMARY_UOM CONSTANT NUMBER := 52;
58 G_PRIMARY_UOM_CLASS CONSTANT NUMBER := 53;
59 G_PROCESS_PHASE CONSTANT NUMBER := 54;
60 G_PROCESS_STATUS CONSTANT NUMBER := 55;
61 G_PROGRAM_APPLICATION CONSTANT NUMBER := 56;
62 G_PROGRAM CONSTANT NUMBER := 57;
63 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 58;
64 G_PROJECT CONSTANT NUMBER := 59;
65 G_PROJECT_NUMBER CONSTANT NUMBER := 60;
66 G_RCV_TRANSACTION CONSTANT NUMBER := 61;
67 G_REASON CONSTANT NUMBER := 62;
68 G_REASON_NAME CONSTANT NUMBER := 63;
69 G_RECEIVING_ACCOUNT CONSTANT NUMBER := 64;
70 G_REFERENCE CONSTANT NUMBER := 65;
71 G_REPETITIVE_SCHEDULE CONSTANT NUMBER := 66;
72 G_REQUEST CONSTANT NUMBER := 67;
73 G_RESOURCE_CODE CONSTANT NUMBER := 68;
74 G_RESOURCE_ID CONSTANT NUMBER := 69;
75 G_RESOURCE_SEQ_NUM CONSTANT NUMBER := 70;
76 G_RESOURCE_TYPE CONSTANT NUMBER := 71;
77 G_SOURCE CONSTANT NUMBER := 72;
78 G_SOURCE_LINE CONSTANT NUMBER := 73;
79 G_STANDARD_RATE CONSTANT NUMBER := 74;
80 G_TASK CONSTANT NUMBER := 75;
81 G_TASK_NUMBER CONSTANT NUMBER := 76;
82 G_TRANSACTION_DATE CONSTANT NUMBER := 77;
83 G_TRANSACTION CONSTANT NUMBER := 78;
84 G_TRANSACTION_QUANTITY CONSTANT NUMBER := 79;
85 G_TRANSACTION_TYPE CONSTANT NUMBER := 80;
86 G_TRANSACTION_UOM CONSTANT NUMBER := 81;
87 G_USAGE_RATE_OR_AMOUNT CONSTANT NUMBER := 82;
88 G_WIP_ENTITY CONSTANT NUMBER := 83;
89 G_WIP_ENTITY_NAME CONSTANT NUMBER := 84;
90 G_MAX_ATTR_ID CONSTANT NUMBER := 85;
91
92 -- Function Convert_Miss_To_Null
93
94 FUNCTION Convert_Miss_To_Null
95 ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
96 ) RETURN WIP_Transaction_PUB.Res_Rec_Type;
97
98 -- Procedure Update_Row
99
100 PROCEDURE Update_Row
101 ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
102 );
103
104 -- Procedure Insert_Row
105
106 PROCEDURE Insert_Row
107 ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
108 );
109
110 -- Procedure Delete_Row
111
112 PROCEDURE Delete_Row
113 ( p_po_header_id IN NUMBER
114 );
115
116 -- Function Query_Row
117
118 FUNCTION Query_Row
119 ( p_po_header_id IN NUMBER
120 ) RETURN WIP_Transaction_PUB.Res_Rec_Type;
121
122 -- Function Query_Rows
123
124 --
125
126 FUNCTION Query_Rows
127 ( p_po_header_id IN NUMBER :=
128 NULL
129 , p_dummy IN VARCHAR2 :=
130 NULL
131 ) RETURN WIP_Transaction_PUB.Res_Tbl_Type;
132
133 -- Procedure lock_Row
134 --
135
136 PROCEDURE Lock_Row
137 ( x_return_status OUT NOCOPY VARCHAR2
138 , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
139 , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type
140 );
141
142
143 PROCEDURE Print_record(p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type);
144
145 END WIP_Res_Util;