APPS.WIP_MTL_TXNS_TEMP_CLEANUP dependencies on WIP_SERIAL_NUMBER_CLEANUP

Line 581: p_dyn_sns in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_rec) is

577:
578: procedure fetch_and_delete(
579: p_hdr_id in number,
580: p_act_id in number,
581: p_dyn_sns in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_rec) is
582:
583: i number := 0;
584:
585: cursor get_serials(

Line 763: p_serials in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_mark_rec) is

759:
760: procedure fetch_and_unmark(
761: p_hdr_id in number,
762: p_act_id in number,
763: p_serials in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_mark_rec) is
764: i number := 0;
765:
766: cursor get_serials(
767: c_hdr_id number,

Line 852: p_dyn_serials in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_rec,

848: p_act_id in number default NULL,
849: p_materials in out nocopy mtl_transactions_temp_rec,
850: p_lots in out nocopy wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,
851: p_serials in out nocopy wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,
852: p_dyn_serials in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_rec,
853: p_ser_marks in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_mark_rec) is
854: begin
855: -- get marked serial numbers
856: fetch_and_unmark(

Line 853: p_ser_marks in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_mark_rec) is

849: p_materials in out nocopy mtl_transactions_temp_rec,
850: p_lots in out nocopy wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,
851: p_serials in out nocopy wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,
852: p_dyn_serials in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_rec,
853: p_ser_marks in out nocopy wip_serial_number_cleanup.mtl_serial_numbers_mark_rec) is
854: begin
855: -- get marked serial numbers
856: fetch_and_unmark(
857: p_hdr_id => p_hdr_id,

Line 1233: p_dyn_serials in wip_serial_number_cleanup.mtl_serial_numbers_rec,

1229: procedure insert_rows(
1230: p_materials in mtl_transactions_temp_rec,
1231: p_lots in wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,
1232: p_serials in wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,
1233: p_dyn_serials in wip_serial_number_cleanup.mtl_serial_numbers_rec,
1234: p_ser_marks in wip_serial_number_cleanup.mtl_serial_numbers_mark_rec,
1235: p_retcode out nocopy number,
1236: p_app out nocopy varchar2,
1237: p_msg out nocopy varchar2) is

Line 1234: p_ser_marks in wip_serial_number_cleanup.mtl_serial_numbers_mark_rec,

1230: p_materials in mtl_transactions_temp_rec,
1231: p_lots in wip_lot_temp_cleanup.mtl_transaction_lots_temp_rec,
1232: p_serials in wip_serial_temp_cleanup.mtl_serial_numbers_temp_rec,
1233: p_dyn_serials in wip_serial_number_cleanup.mtl_serial_numbers_rec,
1234: p_ser_marks in wip_serial_number_cleanup.mtl_serial_numbers_mark_rec,
1235: p_retcode out nocopy number,
1236: p_app out nocopy varchar2,
1237: p_msg out nocopy varchar2) is
1238: x_retcode number;

Line 1250: wip_serial_number_cleanup.insert_rows(p_serials => p_dyn_serials);

1246: -- insert serial records
1247: wip_serial_temp_cleanup.insert_rows(p_serials => p_serials);
1248:
1249: -- insert dynamic serial records
1250: wip_serial_number_cleanup.insert_rows(p_serials => p_dyn_serials);
1251:
1252: -- mark serial numbers
1253: wip_serial_number_cleanup.mark(
1254: p_serials => p_ser_marks,

Line 1253: wip_serial_number_cleanup.mark(

1249: -- insert dynamic serial records
1250: wip_serial_number_cleanup.insert_rows(p_serials => p_dyn_serials);
1251:
1252: -- mark serial numbers
1253: wip_serial_number_cleanup.mark(
1254: p_serials => p_ser_marks,
1255: p_retcode => x_retcode);
1256:
1257: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then

Line 1257: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then

1253: wip_serial_number_cleanup.mark(
1254: p_serials => p_ser_marks,
1255: p_retcode => x_retcode);
1256:
1257: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then
1258: p_app := 'INV';
1259: p_msg := 'INV_RPC_CLEANUP_ERROR';
1260: else
1261: p_app := NULL;