DBA Data[Home] [Help]

APPS.FLM_COPY_ROUTING dependencies on BOM_RTG_PUB

Line 163: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

159: l_line_code varchar2(10) := get_line_code(p_organization_id,p_line_id_to);
160: l_assembly_item_name varchar2(81);
161: l_today date := sysdate;
162:
163: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
164: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
165: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
166: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

Line 164: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

160: l_assembly_item_name varchar2(81);
161: l_today date := sysdate;
162:
163: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
164: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
165: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
166: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 165: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

161: l_today date := sysdate;
162:
163: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
164: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
165: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
166: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
169:

Line 166: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

162:
163: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
164: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
165: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
166: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
169:
170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

Line 167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

163: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
164: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
165: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
166: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
169:
170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

Line 168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

164: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
165: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
166: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
169:
170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

Line 170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

166: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
169:
170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

Line 171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

167: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
169:
170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 172: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

168: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
169:
170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:

Line 173: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

169:
170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

Line 174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

170: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
178: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

Line 175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

171: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
178: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
179: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

Line 177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

173: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
178: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
179: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
180: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
181: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 178: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

174: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
178: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
179: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
180: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
181: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
182:

Line 179: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

175: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
178: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
179: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
180: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
181: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
182:
183: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

Line 180: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

176:
177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
178: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
179: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
180: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
181: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
182:
183: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
184:

Line 181: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

177: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
178: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
179: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
180: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
181: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
182:
183: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
184:
185: o_return_status Varchar2(8);

Line 183: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

179: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
180: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
181: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
182:
183: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
184:
185: o_return_status Varchar2(8);
186: o_msg_count Number;
187: l_msg varchar2(1000);

Line 1088: Bom_Rtg_Pub.Process_Rtg( p_rtg_header_rec =>l_rtg_header_rec

1084: CLOSE c_networks;
1085:
1086: error_handler.initialize;
1087:
1088: Bom_Rtg_Pub.Process_Rtg( p_rtg_header_rec =>l_rtg_header_rec
1089: ,p_rtg_revision_tbl =>l_rtg_revision_tbl
1090: ,p_operation_tbl =>l_operation_tbl
1091: ,p_op_resource_tbl =>l_op_resource_tbl
1092: ,p_sub_resource_tbl =>l_sub_resource_tbl