[Home] [Help]
PACKAGE: APPS.INV_TROLIN_UTIL
Source
1 PACKAGE inv_trolin_util AS
2 /* $Header: INVUTRLS.pls 120.0.12000000.1 2007/01/17 16:34:20 appldev ship $ */
3
4 -- Attributes global constants
5
6 g_attribute1 CONSTANT NUMBER := 2;
7 g_attribute10 CONSTANT NUMBER := 3;
8 g_attribute11 CONSTANT NUMBER := 4;
9 g_attribute12 CONSTANT NUMBER := 5;
10 g_attribute13 CONSTANT NUMBER := 6;
11 g_attribute14 CONSTANT NUMBER := 7;
12 g_attribute15 CONSTANT NUMBER := 8;
13 g_attribute2 CONSTANT NUMBER := 9;
14 g_attribute3 CONSTANT NUMBER := 10;
15 g_attribute4 CONSTANT NUMBER := 11;
16 g_attribute5 CONSTANT NUMBER := 12;
17 g_attribute6 CONSTANT NUMBER := 13;
18 g_attribute7 CONSTANT NUMBER := 14;
19 g_attribute8 CONSTANT NUMBER := 15;
20 g_attribute9 CONSTANT NUMBER := 16;
21 g_attribute_category CONSTANT NUMBER := 17;
22 g_created_by CONSTANT NUMBER := 18;
23 g_creation_date CONSTANT NUMBER := 19;
24 g_date_required CONSTANT NUMBER := 20;
25 g_from_locator CONSTANT NUMBER := 21;
26 g_from_subinventory CONSTANT NUMBER := 22;
27 --G_FROM_SUBINVENTORY CONSTANT NUMBER := 23;
28 g_header CONSTANT NUMBER := 24;
29 g_inventory_item CONSTANT NUMBER := 25;
30 g_last_updated_by CONSTANT NUMBER := 26;
31 g_last_update_date CONSTANT NUMBER := 27;
32 g_last_update_login CONSTANT NUMBER := 28;
33 g_line CONSTANT NUMBER := 29;
34 g_line_number CONSTANT NUMBER := 30;
35 g_line_status CONSTANT NUMBER := 31;
36 g_lot_number CONSTANT NUMBER := 32;
37 g_organization CONSTANT NUMBER := 33;
38 g_program_application CONSTANT NUMBER := 34;
39 g_program CONSTANT NUMBER := 35;
40 g_program_update_date CONSTANT NUMBER := 36;
41 g_project CONSTANT NUMBER := 37;
42 g_quantity CONSTANT NUMBER := 38;
43 g_quantity_delivered CONSTANT NUMBER := 39;
44 g_quantity_detailed CONSTANT NUMBER := 40;
45 g_reason CONSTANT NUMBER := 41;
46 g_reference CONSTANT NUMBER := 42;
47 --G_REFERENCE CONSTANT NUMBER := 43;
48 g_reference_type CONSTANT NUMBER := 44;
49 g_request CONSTANT NUMBER := 45;
50 g_revision CONSTANT NUMBER := 46;
51 g_serial_number_end CONSTANT NUMBER := 47;
52 g_serial_number_start CONSTANT NUMBER := 48;
53 g_status_date CONSTANT NUMBER := 49;
54 g_task CONSTANT NUMBER := 50;
55 g_to_account CONSTANT NUMBER := 51;
56 g_to_locator CONSTANT NUMBER := 52;
57 g_to_subinventory CONSTANT NUMBER := 53;
58 --G_TO_SUBINVENTORY CONSTANT NUMBER := 54;
59 g_transaction_header CONSTANT NUMBER := 55;
60 g_uom CONSTANT NUMBER := 56;
61 --G_UOM CONSTANT NUMBER := 57;
62 g_max_attr_id CONSTANT NUMBER := 58;
63 g_transaction_type_id CONSTANT NUMBER := 59;
64 g_transaction_source_type_id CONSTANT NUMBER := 60;
65 g_txn_source_id CONSTANT NUMBER := 61;
66 g_txn_source_line_id CONSTANT NUMBER := 62;
67 g_txn_source_line_detail_id CONSTANT NUMBER := 63;
68 g_primary_quantity CONSTANT NUMBER := 64;
69 g_to_organization_id CONSTANT NUMBER := 65;
70 g_pick_strategy_id CONSTANT NUMBER := 66;
71 g_put_away_strategy_id CONSTANT NUMBER := 67;
72 g_unit_number CONSTANT NUMBER := 68;
73 g_ship_to_location_id CONSTANT NUMBER := 69;
74 g_from_cost_group_id CONSTANT NUMBER := 70;
75 g_to_cost_group_id CONSTANT NUMBER := 71;
76 g_lpn_id CONSTANT NUMBER := 72;
77 g_to_lpn_id CONSTANT NUMBER := 73;
78 g_pick_methodology_id CONSTANT NUMBER := 74;
79 g_container_item_id CONSTANT NUMBER := 75;
80 g_carton_grouping_id CONSTANT NUMBER := 76;
81 g_pick_slip_number CONSTANT NUMBER := 77;
82 g_pick_slip_date CONSTANT NUMBER := 78;
83 g_ship_set_id CONSTANT NUMBER := 79;
84 g_ship_model_id CONSTANT NUMBER := 80;
85 g_model_quantity CONSTANT NUMBER := 81;
86 g_required_quantity CONSTANT NUMBER := 82;
87 --INVCONV BEGIN
88 g_secondary_quantity CONSTANT NUMBER := 83;
89 g_secondary_quantity_delivered CONSTANT NUMBER := 84;
90 g_secondary_quantity_detailed CONSTANT NUMBER := 85;
91 g_secondary_uom CONSTANT NUMBER := 86;
92 g_grade_code CONSTANT NUMBER := 87;
93 g_secondary_required_quantity CONSTANT NUMBER := 88;
94 --INVCONV END;
95
96 -- Procedure Clear_Dependent_Attr
97
98 PROCEDURE clear_dependent_attr(
99 p_attr_id IN NUMBER := fnd_api.g_miss_num
100 , p_trolin_rec IN inv_move_order_pub.trolin_rec_type
101 , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec
102 , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
103 );
104
105 -- Procedure Apply_Attribute_Changes
106
107 PROCEDURE apply_attribute_changes(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec, x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type);
108
109 -- Function Complete_Record
110
111 FUNCTION complete_record(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type)
112 RETURN inv_move_order_pub.trolin_rec_type;
113
114 -- Function Convert_Miss_To_Null for TROLIN_REC_TYPE
115
116 FUNCTION convert_miss_to_null(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)
117 RETURN inv_move_order_pub.trolin_rec_type;
118
119 -- Function Convert_Miss_To_Null_Parallel for TROLIN_REC_TYPE
120
121 FUNCTION convert_miss_to_null_parallel(p_trolin_rec IN inv_move_order_pub.trolin_rec_type)
122 RETURN inv_move_order_pub.trolin_rec_type;
123
124 -- Bug#2536932: Function Convert_Miss_To_Null for TROLIN_VAL_REC_TYPE
125 -- Converts all Miss Char, Number or Date to NULL values.
126
127 FUNCTION convert_miss_to_null(p_trolin_val_rec IN inv_move_order_pub.trolin_val_rec_type)
128 RETURN inv_move_order_pub.trolin_val_rec_type;
129
130 -- Procedure Update_Row
131
132 PROCEDURE update_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type);
133
134 -- Procedure Update_Row_Status
135
136 PROCEDURE update_row_status(p_line_id IN NUMBER, p_status IN NUMBER);
137
138 -- Procedure Insert_Row
139
140 PROCEDURE insert_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type);
141
142 -- Procedure Delete_Row
143
144 PROCEDURE delete_row(p_line_id IN NUMBER);
145
146 -- Function Query_Row
147
148 FUNCTION query_row(p_line_id IN NUMBER)
149 RETURN inv_move_order_pub.trolin_rec_type;
150
151 -- Function Query_Rows
152
153 --
154
155 FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num, p_header_id IN NUMBER := fnd_api.g_miss_num)
156 RETURN inv_move_order_pub.trolin_tbl_type;
157
158 -- Function Get_Lines
159 --
160
161 FUNCTION get_lines(p_header_id IN NUMBER)
162 RETURN inv_move_order_pub.trolin_tbl_type;
163
164 -- Procedure lock_Row
165 --
166
167 PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trolin_rec IN inv_move_order_pub.trolin_rec_type, x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type);
168
169 -- Function Get_Values
170
171 FUNCTION get_values(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type := inv_move_order_pub.g_miss_trolin_rec)
172 RETURN inv_move_order_pub.trolin_val_rec_type;
173
174 -- Function Get_Ids
175
176 FUNCTION get_ids(p_trolin_rec IN inv_move_order_pub.trolin_rec_type, p_trolin_val_rec IN inv_move_order_pub.trolin_val_rec_type)
177 RETURN inv_move_order_pub.trolin_rec_type;
178
179 -- Procedure insert_mo_lines_bulk /* For Parallel Pick release */
180
181 PROCEDURE insert_mo_lines_bulk
182 (
183 p_new_trolin_tbl IN inv_move_order_pub.Trolin_New_Tbl_Type
184 , x_return_status IN OUT NOCOPY VARCHAR2
185 );
186
187 END inv_trolin_util;