APPS.INV_TXN_MANAGER_PUB dependencies on INV_SERIAL_NUMBER_PUB

Line 365: AND inv_serial_number_pub.get_serial_diff (msni.fm_serial_number

361: WHERE msni.transaction_interface_id =
362: (SELECT serial_transaction_temp_id
363: FROM mtl_transaction_lots_interface mtli
364: WHERE mtli.transaction_interface_id = p_parent_id)
365: AND inv_serial_number_pub.get_serial_diff (msni.fm_serial_number
366: , p_serial_number
367: ) <> -1
368: AND inv_serial_number_pub.get_serial_diff (msni.fm_serial_number
369: , NVL (msni.to_serial_number

Line 368: AND inv_serial_number_pub.get_serial_diff (msni.fm_serial_number

364: WHERE mtli.transaction_interface_id = p_parent_id)
365: AND inv_serial_number_pub.get_serial_diff (msni.fm_serial_number
366: , p_serial_number
367: ) <> -1
368: AND inv_serial_number_pub.get_serial_diff (msni.fm_serial_number
369: , NVL (msni.to_serial_number
370: , msni.fm_serial_number
371: )
372: ) >=

Line 373: inv_serial_number_pub.get_serial_diff (msni.fm_serial_number

369: , NVL (msni.to_serial_number
370: , msni.fm_serial_number
371: )
372: ) >=
373: inv_serial_number_pub.get_serial_diff (msni.fm_serial_number
374: , p_serial_number
375: );
376: l_msni_csr msni_csr%ROWTYPE;
377:

Line 847: inv_serial_number_pub.get_serial_diff

843: );
844: END IF;
845:
846: l_serial_diff :=
847: inv_serial_number_pub.get_serial_diff
848: (l_msni_rs_serials_csr.fm_serial_number
849: , l_msni_rs_serials_csr.to_serial_number
850: );
851:

Line 890: inv_serial_number_pub.increment_ser_num (l_old_serial

886:
887: l_rs_serial_tbl (l_next_serial) := l_next_serial;
888: l_old_serial := l_next_serial;
889: l_next_serial :=
890: inv_serial_number_pub.increment_ser_num (l_old_serial
891: , 1);
892:
893: IF (l_debug = 1)
894: THEN

Line 932: inv_serial_number_pub.get_serial_diff

928: );
929: END IF;
930:
931: l_serial_diff :=
932: inv_serial_number_pub.get_serial_diff
933: (l_msni_st_serials_csr.fm_serial_number
934: , l_msni_st_serials_csr.to_serial_number
935: );
936:

Line 996: inv_serial_number_pub.increment_ser_num (l_old_serial

992: END IF;
993: END;
994: l_old_serial := l_next_serial;
995: l_next_serial :=
996: inv_serial_number_pub.increment_ser_num (l_old_serial
997: , 1);
998:
999: IF (l_old_serial = l_next_serial)
1000: THEN