eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_ATP_INTERFACE_PK dependencies on MRP_ATP_PUB

Line 160: g_shipset MRP_ATP_PUB.ATP_REC_TYP ;

156: g_final_cto_shipset CTO_SHIPSET_TBL_TYPE ; /* package global array */
157: g_cto_shipset CTO_SHIPSET_TBL_TYPE ; /* package global array */
158: g_cto_sparse_shipset CTO_SHIPSET_TBL_TYPE ; /* package global sparse array */
159: local_cto_shipset CTO_SHIPSET_TBL_TYPE ; /* package global variable */
160: g_shipset MRP_ATP_PUB.ATP_REC_TYP ;
161: g_final_shipset MRP_ATP_PUB.ATP_REC_TYP ;
162:
163: g_auto_generated_shipset AUTO_SHIPSET_TBL_TYPE ;
164:

Line 161: g_final_shipset MRP_ATP_PUB.ATP_REC_TYP ;

157: g_cto_shipset CTO_SHIPSET_TBL_TYPE ; /* package global array */
158: g_cto_sparse_shipset CTO_SHIPSET_TBL_TYPE ; /* package global sparse array */
159: local_cto_shipset CTO_SHIPSET_TBL_TYPE ; /* package global variable */
160: g_shipset MRP_ATP_PUB.ATP_REC_TYP ;
161: g_final_shipset MRP_ATP_PUB.ATP_REC_TYP ;
162:
163: g_auto_generated_shipset AUTO_SHIPSET_TBL_TYPE ;
164:
165: g_expected_error_code number ;

Line 190: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

186: API for Business logic Processing
187: **********************************/
188:
189: PROCEDURE evaluate_shipset(
190: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
191: , p_auto_generated in boolean
192: , p_process_demand in boolean
193: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
194: , p_model_sourced out boolean

Line 193: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP

189: PROCEDURE evaluate_shipset(
190: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
191: , p_auto_generated in boolean
192: , p_process_demand in boolean
193: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
194: , p_model_sourced out boolean
195: , x_return_status out varchar2
196: );
197:

Line 199: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

195: , x_return_status out varchar2
196: );
197:
198: PROCEDURE populate_cz_shipset(
199: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
200: , p_orig_shipsEt_tracker in out NOCOPY CTO_SHIPSET_TBL_TYPE
201: , p_shipset_contains_model in out boolean
202: , x_return_status out varchar2
203: );

Line 206: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

202: , x_return_status out varchar2
203: );
204:
205: PROCEDURE populate_om_shipset(
206: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
207: , p_orig_shipset_tracker in out NOCOPY CTO_SHIPSET_TBL_TYPE
208: , p_shipset_contains_model in out boolean
209: , x_return_status out varchar2
210: );

Line 255: p_shipset in MRP_ATP_PUB.ATP_REC_TYP

251: API for saving state of shipset and reconstructing it on demand
252: ***********************************************************************/
253:
254: PROCEDURE save_shipset(
255: p_shipset in MRP_ATP_PUB.ATP_REC_TYP
256: , x_return_status out varchar2
257: );
258:
259: PROCEDURE resurrect_shipset(

Line 260: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

256: , x_return_status out varchar2
257: );
258:
259: PROCEDURE resurrect_shipset(
260: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
261: , p_success_flag in boolean
262: , x_return_status out varchar2
263: , x_msg_count out number
264: , x_msg_data out varchar2

Line 270: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

266:
267: PROCEDURE populate_configuration_status ;
268:
269: PROCEDURE populate_visible_demand(
270: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
271: , p_success_flag in boolean
272: , x_return_status out varchar2
273: , x_msg_count out number
274: , x_msg_data out varchar2

Line 278: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

274: , x_msg_data out varchar2
275: );
276:
277: PROCEDURE reconstruct_shipset(
278: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
279: , p_success_flag_tbl in MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE
280: , x_return_status out varchar2
281: , x_msg_count out number
282: , x_msg_data out varchar2

Line 279: , p_success_flag_tbl in MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE

275: );
276:
277: PROCEDURE reconstruct_shipset(
278: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
279: , p_success_flag_tbl in MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE
280: , x_return_status out varchar2
281: , x_msg_count out number
282: , x_msg_data out varchar2
283: );

Line 299: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

295: , x_return_status out varchar2
296: );
297:
298: PROCEDURE populate_error(
299: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
300: , x_return_status out varchar2
301: );
302:
303: /*************************************************************

Line 318: PROCEDURE default_ship_set_name( p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP ) ;

314: p_ship_set_name in varchar2
315: )
316: return number ;
317:
318: PROCEDURE default_ship_set_name( p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP ) ;
319:
320:
321: /***********************************************************
322: Convenience API for Displaying Information to aid debugging

Line 327: PROCEDURE print_shipset( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP ) ;

323: ************************************************************/
324:
325: PROCEDURE show_contents( p_shipset_tracker IN CTO_SHIPSET_TBL_TYPE ) ;
326:
327: PROCEDURE print_shipset( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP ) ;
328:
329: PROCEDURE print_shipset_capacity( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP ) ;
330:
331: FUNCTION get_shipset_status(

Line 329: PROCEDURE print_shipset_capacity( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP ) ;

325: PROCEDURE show_contents( p_shipset_tracker IN CTO_SHIPSET_TBL_TYPE ) ;
326:
327: PROCEDURE print_shipset( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP ) ;
328:
329: PROCEDURE print_shipset_capacity( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP ) ;
330:
331: FUNCTION get_shipset_status(
332: p_shipset_tbl IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,
333: p_shipset_name IN varchar2

Line 332: p_shipset_tbl IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,

328:
329: PROCEDURE print_shipset_capacity( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP ) ;
330:
331: FUNCTION get_shipset_status(
332: p_shipset_tbl IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,
333: p_shipset_name IN varchar2
334: ) RETURN VARCHAR2;
335:
336: FUNCTION get_shipset_source_flag(

Line 346: p_bom_rec in out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP

342: Convenience API for record Cloning/Deletion
343: **************************************************/
344:
345: PROCEDURE remove_elements_from_bom_rec(
346: p_bom_rec in out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
347: );
348:
349: PROCEDURE remove_elements_from_atp_rec(
350: p_atp_rec in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

Line 350: p_atp_rec in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

346: p_bom_rec in out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
347: );
348:
349: PROCEDURE remove_elements_from_atp_rec(
350: p_atp_rec in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
351: );
352:
353: PROCEDURE Assign_Atp_Bom_Rec (
354: p_src_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,

Line 354: p_src_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,

350: p_atp_rec in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
351: );
352:
353: PROCEDURE Assign_Atp_Bom_Rec (
354: p_src_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
355: p_src_location in number ,
356: p_des_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ ,
357: x_return_status out varchar2 ,
358: x_msg_data out varchar2 ,

Line 356: p_des_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ ,

352:
353: PROCEDURE Assign_Atp_Bom_Rec (
354: p_src_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
355: p_src_location in number ,
356: p_des_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ ,
357: x_return_status out varchar2 ,
358: x_msg_data out varchar2 ,
359: x_msg_count out number ) ;
360:

Line 396: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

392: ** 5) store the status of the shipset ( sourced, etc. ) in shipset_status structure
393: ** 6) return appropriate result to caller
394: */
395: PROCEDURE get_atp_bom(
396: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
397: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
398: , x_return_status out varchar2
399: , x_msg_count out number
400: , x_msg_data out varchar2

Line 397: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP

393: ** 6) return appropriate result to caller
394: */
395: PROCEDURE get_atp_bom(
396: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
397: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
398: , x_return_status out varchar2
399: , x_msg_count out number
400: , x_msg_data out varchar2
401: )

Line 405: v_shipset MRP_ATP_PUB.ATP_REC_TYP ;

401: )
402: is
403: l_stmt_num Number ;
404: l_return_status varchar2(1) ;
405: v_shipset MRP_ATP_PUB.ATP_REC_TYP ;
406: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;
407: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
408: v_atp_bom_rec MRP_ATP_PUB.ATP_BOM_REC_TYP ;
409: v_ship_set_name varchar2(200) ;

Line 406: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;

402: is
403: l_stmt_num Number ;
404: l_return_status varchar2(1) ;
405: v_shipset MRP_ATP_PUB.ATP_REC_TYP ;
406: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;
407: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
408: v_atp_bom_rec MRP_ATP_PUB.ATP_BOM_REC_TYP ;
409: v_ship_set_name varchar2(200) ;
410: v_prev_ship_set_name varchar2(200) ;

Line 407: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;

403: l_stmt_num Number ;
404: l_return_status varchar2(1) ;
405: v_shipset MRP_ATP_PUB.ATP_REC_TYP ;
406: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;
407: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
408: v_atp_bom_rec MRP_ATP_PUB.ATP_BOM_REC_TYP ;
409: v_ship_set_name varchar2(200) ;
410: v_prev_ship_set_name varchar2(200) ;
411: v_cto_shipset_count number ;

Line 408: v_atp_bom_rec MRP_ATP_PUB.ATP_BOM_REC_TYP ;

404: l_return_status varchar2(1) ;
405: v_shipset MRP_ATP_PUB.ATP_REC_TYP ;
406: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;
407: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
408: v_atp_bom_rec MRP_ATP_PUB.ATP_BOM_REC_TYP ;
409: v_ship_set_name varchar2(200) ;
410: v_prev_ship_set_name varchar2(200) ;
411: v_cto_shipset_count number ;
412: v_bomrec_count number ;

Line 1098: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

1094: ** may not be passed with the ATO models under it. The code needs to handle both scenarios from a
1095: ** Top Down Model processing perspective.
1096: */
1097: PROCEDURE evaluate_shipset(
1098: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
1099: , p_auto_generated in boolean
1100: , p_process_demand in boolean
1101: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
1102: , p_model_sourced out boolean

Line 1101: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP

1097: PROCEDURE evaluate_shipset(
1098: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
1099: , p_auto_generated in boolean
1100: , p_process_demand in boolean
1101: , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
1102: , p_model_sourced out boolean
1103: , x_return_status out varchar2
1104: )
1105: is

Line 1127: v_shipset MRP_ATP_PUB.ATP_REC_TYP ;

1123: x_msg_data varchar2(2000) ;
1124: x_msg_count number ;
1125: l_stmt_num number ;
1126: v_cto_shipset_flag FLAG_TBL_TYPE;
1127: v_shipset MRP_ATP_PUB.ATP_REC_TYP ;
1128: v_shipset_index number ;
1129: TYPE TABNUM is TABLE of NUMBER index by binary_integer ;
1130: l_pal_array TABNUM ;
1131: l_pal_count number ;

Line 2094: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

2090: ** Model/Component relationships ( link_to_line_id, ato_line_id) need to be established before
2091: ** transformation.
2092: */
2093: PROCEDURE populate_cz_shipset(
2094: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
2095: , p_orig_shipset_tracker in out NOCOPY CTO_SHIPSET_TBL_TYPE
2096: , p_shipset_contains_model in out boolean
2097: , x_return_status out varchar2
2098: )

Line 2536: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

2532: ** This procedure does the preprocessing and data collection for calls
2533: ** originating from OM.
2534: */
2535: PROCEDURE populate_om_shipset(
2536: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
2537: , p_orig_shipset_tracker in out NOCOPY CTO_SHIPSET_TBL_TYPE
2538: , p_shipset_contains_model in out boolean
2539: , x_return_status out varchar2
2540: )

Line 3524: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

3520: ** A set of reduced shipset is passed with a supporting structure to indicate the atp success/failure status.
3521: ** This procedure reconstructs all the shipsets by consulting the saved shipset structure.
3522: */
3523: PROCEDURE reconstruct_shipset(
3524: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
3525: , p_success_flag_tbl in MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE
3526: , x_return_status out varchar2
3527: , x_msg_count out number
3528: , x_msg_data out varchar2

Line 3525: , p_success_flag_tbl in MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE

3521: ** This procedure reconstructs all the shipsets by consulting the saved shipset structure.
3522: */
3523: PROCEDURE reconstruct_shipset(
3524: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
3525: , p_success_flag_tbl in MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE
3526: , x_return_status out varchar2
3527: , x_msg_count out number
3528: , x_msg_data out varchar2
3529: )

Line 3531: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;

3527: , x_msg_count out number
3528: , x_msg_data out varchar2
3529: )
3530: is
3531: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;
3532: v_reduced_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3533: v_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3534: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
3535: v_shipset_loc number ;

Line 3532: v_reduced_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;

3528: , x_msg_data out varchar2
3529: )
3530: is
3531: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;
3532: v_reduced_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3533: v_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3534: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
3535: v_shipset_loc number ;
3536: v_char varchar2(1) := FND_API.G_TRUE ;

Line 3533: v_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;

3529: )
3530: is
3531: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;
3532: v_reduced_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3533: v_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3534: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
3535: v_shipset_loc number ;
3536: v_char varchar2(1) := FND_API.G_TRUE ;
3537: v_success_status boolean ;

Line 3534: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;

3530: is
3531: v_reduced_shipset MRP_ATP_PUB.ATP_REC_TYP ;
3532: v_reduced_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3533: v_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3534: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
3535: v_shipset_loc number ;
3536: v_char varchar2(1) := FND_API.G_TRUE ;
3537: v_success_status boolean ;
3538: l_stmt_num number ;

Line 3835: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

3831: */
3832: /* BUGFIX 2406559 for this procedure at multiple places
3833: */
3834: PROCEDURE resurrect_shipset(
3835: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
3836: , p_success_flag in boolean
3837: , x_return_status out varchar2
3838: , x_msg_count out number
3839: , x_msg_data out varchar2

Line 4152: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

4148:
4149:
4150:
4151: PROCEDURE populate_visible_demand(
4152: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
4153: , p_success_flag in boolean
4154: , x_return_status out varchar2
4155: , x_msg_count out number
4156: , x_msg_data out varchar2

Line 4225: p_atp_rec in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

4221:
4222:
4223:
4224: PROCEDURE remove_elements_from_atp_rec(
4225: p_atp_rec in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
4226: )
4227: is
4228: BEGIN
4229: p_atp_rec.Row_Id.delete ;

Line 4282: p_bom_rec in out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP

4278:
4279:
4280:
4281: PROCEDURE remove_elements_from_bom_rec(
4282: p_bom_rec in out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
4283: )
4284: is
4285: BEGIN
4286: p_bom_rec.assembly_identifier.delete ;

Line 4442: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP

4438: /*
4439: ** This procedure actually populates the errors registered in the g_cto_shipset structure to the actual shipset.
4440: */
4441: PROCEDURE populate_error(
4442: p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
4443: , x_return_status out varchar2
4444: )
4445: is
4446: v_start_loc number ;

Line 4476: p_shipset in MRP_ATP_PUB.ATP_REC_TYP

4472: END populate_error;
4473:
4474:
4475: PROCEDURE save_shipset(
4476: p_shipset in MRP_ATP_PUB.ATP_REC_TYP
4477: , x_return_status out varchar2
4478: )
4479: is
4480: BEGIN

Line 4574: PROCEDURE default_ship_set_name( p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP )

4570:
4571: END show_contents;
4572:
4573:
4574: PROCEDURE default_ship_set_name( p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP )
4575: is
4576: BEGIN
4577: IF( p_shipset.identIFier.count > 0 ) THEN
4578: FOR i IN p_shipset.identifier.first..p_shipset.identifier.last

Line 4595: p_shipset IN MRP_ATP_PUB.ATP_REC_TYP

4591: END default_ship_set_name ;
4592:
4593:
4594: PROCEDURE print_shipset(
4595: p_shipset IN MRP_ATP_PUB.ATP_REC_TYP
4596: )
4597: is
4598: BEGIN
4599:

Line 4695: PROCEDURE print_shipset_capacity( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP )

4691:
4692: END print_shipset ;
4693:
4694:
4695: PROCEDURE print_shipset_capacity( p_shipset IN MRP_ATP_PUB.ATP_REC_TYP )
4696: is
4697: BEGIN
4698:
4699: IF PG_DEBUG <> 0 THEN

Line 4787: p_atp_bom in out NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,

4783: Requires : Global memory structure G_CTO_SPARSE_SHIPSET
4784: Returns :
4785: -----------------------------------------------------------------------*/
4786: PROCEDURE Create_Atp_Bom (
4787: p_atp_bom in out NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
4788: x_Return_Status out varchar2 ,
4789: x_Msg_Data out varchar2 ,
4790: x_Msg_Count out number )
4791: IS

Line 5121: p_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,

5117:
5118:
5119:
5120: PROCEDURE Extend_Atp_Bom (
5121: p_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
5122: x_return_status out varchar2,
5123: x_msg_data out varchar2,
5124: x_msg_count out number)
5125: IS

Line 5172: p_src_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,

5168:
5169:
5170:
5171: PROCEDURE Assign_Atp_Bom_Rec (
5172: p_src_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
5173: p_src_location in number ,
5174: p_des_atp_bom IN OUT MRP_ATP_PUB.atp_bom_rec_typ ,
5175: x_return_status out varchar2 ,
5176: x_msg_data out varchar2 ,

Line 5174: p_des_atp_bom IN OUT MRP_ATP_PUB.atp_bom_rec_typ ,

5170:
5171: PROCEDURE Assign_Atp_Bom_Rec (
5172: p_src_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
5173: p_src_location in number ,
5174: p_des_atp_bom IN OUT MRP_ATP_PUB.atp_bom_rec_typ ,
5175: x_return_status out varchar2 ,
5176: x_msg_data out varchar2 ,
5177: x_msg_count out number )
5178: is

Line 5209: PROCEDURE Populate_Mandatory_Components(p_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,

5205: END assign_atp_bom_rec ;
5206:
5207:
5208:
5209: PROCEDURE Populate_Mandatory_Components(p_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
5210: p_index IN NUMBER,
5211: x_Return_Status OUT VARCHAR2,
5212: x_Msg_Count OUT NUMBER,
5213: x_Msg_Data OUT VARCHAR2)

Line 5553: p_shipset IN OUT NOCOPY MRP_ATP_PUB.ATP_REC_TYP,

5549:
5550: *******************************************************************************************/
5551:
5552: PROCEDURE CREATE_CTO_MODEL_DEMAND(
5553: p_shipset IN OUT NOCOPY MRP_ATP_PUB.ATP_REC_TYP,
5554: p_session_id IN number,
5555: p_shipset_status IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,
5556: xreturn_status OUT varchar2,
5557: xMsgCount OUT number,

Line 5555: p_shipset_status IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,

5551:
5552: PROCEDURE CREATE_CTO_MODEL_DEMAND(
5553: p_shipset IN OUT NOCOPY MRP_ATP_PUB.ATP_REC_TYP,
5554: p_session_id IN number,
5555: p_shipset_status IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,
5556: xreturn_status OUT varchar2,
5557: xMsgCount OUT number,
5558: xMsgData OUT varchar2) is
5559: i number; -- Loop counter

Line 6206: p_shipset_tbl IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,

6202:
6203:
6204:
6205: FUNCTION get_shipset_status(
6206: p_shipset_tbl IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,
6207: p_shipset_name IN varchar2) RETURN VARCHAR2 is
6208: i number := 0;
6209: BEGIN
6210: IF PG_DEBUG <> 0 THEN