[Home] [Help]
PACKAGE: APPS.WIP_SHOPFLOORMOVE_UTIL
Source
1 PACKAGE WIP_Shopfloormove_Util AUTHID CURRENT_USER AS
2 /* $Header: WIPUSFMS.pls 115.6 2002/12/03 11:16:28 simishra ship $ */
3
4 -- Attributes global constants
5
6 G_ACCT_PERIOD CONSTANT NUMBER := 1;
7 G_ATTRIBUTE1 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE10 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE11 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE12 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE13 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE14 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE15 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE2 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE3 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE4 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE5 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE6 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE7 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE8 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE9 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 17;
23 G_CREATED_BY CONSTANT NUMBER := 18;
24 G_CREATED_BY_NAME CONSTANT NUMBER := 19;
25 G_CREATION_DATE CONSTANT NUMBER := 20;
26 G_ENTITY_TYPE CONSTANT NUMBER := 21;
27 G_FM_DEPARTMENT_CODE CONSTANT NUMBER := 22;
28 G_FM_DEPARTMENT_ID CONSTANT NUMBER := 23;
29 G_FM_INTRAOP_STEP_TYPE CONSTANT NUMBER := 24;
30 G_FM_OPERATION CONSTANT NUMBER := 25;
31 G_FM_OPERATION_SEQ_NUM CONSTANT NUMBER := 26;
32 G_GROUP CONSTANT NUMBER := 27;
33 G_KANBAN_CARD CONSTANT NUMBER := 28;
34 G_LAST_UPDATED_BY CONSTANT NUMBER := 30;
35 G_LAST_UPDATED_BY_NAME CONSTANT NUMBER := 31;
36 G_LAST_UPDATE_DATE CONSTANT NUMBER := 32;
37 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 33;
38 G_LINE_CODE CONSTANT NUMBER := 34;
39 G_LINE_ID CONSTANT NUMBER := 35;
40 G_ORGANIZATION_CODE CONSTANT NUMBER := 36;
41 G_ORGANIZATION_ID CONSTANT NUMBER := 37;
42 G_OVERCOMPLETION CONSTANT NUMBER := 38;
43 G_OVERCPL_PRIMARY_QTY CONSTANT NUMBER := 39;
44 G_OVERCPL_TRANSACTION CONSTANT NUMBER := 40;
45 G_OVERCPL_TRANSACTION_QTY CONSTANT NUMBER := 41;
46 G_OVERMOVE_TXN_QTY CONSTANT NUMBER := 42;
47 G_PRIMARY_ITEM CONSTANT NUMBER := 43;
48 G_PRIMARY_QUANTITY CONSTANT NUMBER := 44;
49 G_PRIMARY_UOM CONSTANT NUMBER := 45;
50 G_PROCESS_PHASE CONSTANT NUMBER := 46;
51 G_PROCESS_STATUS CONSTANT NUMBER := 47;
52 G_PROGRAM_APPLICATION CONSTANT NUMBER := 48;
53 G_PROGRAM CONSTANT NUMBER := 49;
54 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 50;
55 G_QA_COLLECTION CONSTANT NUMBER := 51;
56 G_REASON CONSTANT NUMBER := 52;
57 G_REASON_NAME CONSTANT NUMBER := 53;
58 G_REFERENCE CONSTANT NUMBER := 54;
59 G_REPETITIVE_SCHEDULE CONSTANT NUMBER := 55;
60 G_REQUEST CONSTANT NUMBER := 56;
61 G_SCRAP_ACCOUNT CONSTANT NUMBER := 57;
62 G_SOURCE CONSTANT NUMBER := 58;
63 G_SOURCE_LINE CONSTANT NUMBER := 59;
64 G_TO_DEPARTMENT_CODE CONSTANT NUMBER := 60;
65 G_TO_DEPARTMENT_ID CONSTANT NUMBER := 61;
66 G_TO_INTRAOP_STEP_TYPE CONSTANT NUMBER := 62;
67 G_TO_OPERATION CONSTANT NUMBER := 63;
68 G_TO_OPERATION_SEQ_NUM CONSTANT NUMBER := 64;
69 G_TRANSACTION_DATE CONSTANT NUMBER := 65;
70 G_TRANSACTION CONSTANT NUMBER := 66;
71 G_TRANSACTION_LINK CONSTANT NUMBER := 67;
72 G_TRANSACTION_QUANTITY CONSTANT NUMBER := 68;
73 G_TRANSACTION_TYPE CONSTANT NUMBER := 69;
74 G_TRANSACTION_UOM CONSTANT NUMBER := 70;
75 G_WIP_ENTITY CONSTANT NUMBER := 71;
76 G_WIP_ENTITY_NAME CONSTANT NUMBER := 72;
77 G_MAX_ATTR_ID CONSTANT NUMBER := 73;
78
79 -- Function Complete_Record
80
81 FUNCTION Complete_Record
82 ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
83 , p_old_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
84 ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type;
85
86 -- Function Convert_Miss_To_Null
87
88 FUNCTION Convert_Miss_To_Null
89 ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
90 ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type;
91
92 -- Procedure Update_Row
93
94
95 -- Procedure Insert_Row
96
97 PROCEDURE Insert_Row
98 ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
99 );
100
101 -- Procedure Delete_Row
102
103 PROCEDURE Delete_Row
104 ( p_transaction_id IN NUMBER
105 );
106
107 -- Function Query_Row
108
109 FUNCTION Query_Row
110 ( p_transaction_id IN NUMBER
111 ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type;
112
113 -- Function Query_Rows
114
115 FUNCTION Query_Rows
116 ( p_transaction_id IN NUMBER :=
117 NULL
118 , p_dummy IN VARCHAR2 :=
119 NULL
120 ) RETURN WIP_Transaction_PUB.Shopfloormove_Tbl_Type;
121 --
122
123 -- Procedure lock_Row
124 --
125
126
127 PROCEDURE print_record(p_ShopFloorMove_rec IN WIP_Transaction_PUB.ShopFloorMove_Rec_Type);
128
129 END WIP_Shopfloormove_Util;