APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on WSH_PICK_SLIP_NUMBERS_S

Line 543: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL

539: if customer has applied INV-H and WSH-I, it should still
540: continue to work.
541:
542: */
543: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL
544: INTO x_pick_slip_number
545: FROM DUAL;
546:
547: g_pskey_table(l_hash_value) := l_Insert_key_Rec;

Line 871: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL

867: IF ((l_found) AND (g_rule_table(l_rule_index).pick_method = '3')) THEN -- Cluster Picking
868: /* Do not store the pick slip numbers generated for cluster picking
869: as we want to generate a new one for each line
870: */
871: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL
872: INTO x_pick_slip_number
873: FROM DUAL;
874:
875: x_api_status := FND_API.G_RET_STS_SUCCESS;

Line 912: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL

908: IF (g_rule_table(l_rule_index).pick_method = '3') THEN -- Cluster Picking
909: /* Do not store the pick slip numbers generated for cluster picking
910: as we want to generate a new one for each line
911: */
912: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL
913: INTO x_pick_slip_number
914: FROM DUAL;
915: ELSE
916: -- Insert new key to table based on grouping rule