APPS.WMS_POSTALLOC_PVT dependencies on WSH_PICK_SLIP_NUMBERS_S

Line 4044: , wsh_pick_slip_numbers_s.NEXTVAL

4040: , l_lot_control_code(jj)
4041: , l_serial_control_code(jj)
4042: , l_serial_allocated_flag(jj)
4043: , l_transaction_batch_id(jj)
4044: , wsh_pick_slip_numbers_s.NEXTVAL
4045: , 'Y')
4046: RETURNING transaction_temp_id BULK COLLECT INTO tbl_transaction_temp_id;
4047:
4048: IF g_debug = 1 AND SQL%ROWCOUNT > 0 THEN

Line 6982: SELECT wsh_pick_slip_numbers_s.NEXTVAL

6978:
6979: FOR ii IN t_grp_crit1.FIRST .. t_grp_crit1.LAST LOOP --{
6980:
6981: -- Get the next pick slip number using the sequence
6982: SELECT wsh_pick_slip_numbers_s.NEXTVAL
6983: INTO l_pick_slip_number
6984: FROM DUAL;
6985:
6986: -- Open cursor to fetch matching MMTT rows based on number of Grouping attributes returned

Line 7179: SET pick_slip_number = wsh_pick_slip_numbers_s.NEXTVAL

7175: EXIT WHEN tbl_transaction_temp_id.COUNT = 0;
7176:
7177: FORALL jj IN tbl_transaction_temp_id.FIRST .. tbl_transaction_temp_id.LAST
7178: UPDATE mtl_material_transactions_temp
7179: SET pick_slip_number = wsh_pick_slip_numbers_s.NEXTVAL
7180: , transaction_source_id = tbl_sales_order_id(jj)
7181: , trx_source_line_id = tbl_oe_line_id(jj)
7182: , demand_source_header_id = tbl_sales_order_id(jj)
7183: , demand_source_line = tbl_oe_line_id(jj)