APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on WSH_PICK_SLIP_NUMBERS_S

Line 542: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL

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

Line 870: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL

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

Line 911: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL

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