APPS.INV_PR_PICK_SLIP_NUMBER dependencies on DUAL

Line 96: FROM DUAL;

92: ) IS
93: BEGIN
94: SELECT wsh_pick_slip_numbers_s.NEXTVAL
95: INTO x_pick_slip_number
96: FROM DUAL;
97:
98: g_pskey_table(l_hash_value) := l_insert_key_rec;
99: g_pskey_table(l_hash_value).counter := 1;
100: g_pskey_table(l_hash_value).pick_slip_number := x_pick_slip_number;

Line 408: FROM dual;

404: -- Bug 5212435: Store the pick slip number even when limit is 1
405: IF (p_ps_mode = 'I' AND l_limit = 1) THEN
406: SELECT wsh_pick_slip_numbers_s.NEXTVAL
407: INTO x_pick_slip_number
408: FROM dual;
409: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
410: x_pick_slip_number;
411: x_ready_to_print := FND_API.G_TRUE;
412: x_api_status := FND_API.G_RET_STS_SUCCESS;

Line 429: FROM DUAL;

425: /* Cluster Picking:
426: Do not store the pick slip numbers generated, as a new one is required for each line. */
427: SELECT wsh_pick_slip_numbers_s.NEXTVAL
428: INTO x_pick_slip_number
429: FROM DUAL;
430:
431: x_api_status := fnd_api.g_ret_sts_success;
432: RETURN;
433: END IF;

Line 476: FROM DUAL;

472: /* Cluster Picking:
473: Do not store the pick slip numbers generated, as a new one is required for each line. */
474: SELECT wsh_pick_slip_numbers_s.NEXTVAL
475: INTO x_pick_slip_number
476: FROM DUAL;
477: ELSE
478: -- Generate a new PickSlip Number and Insert it for future use.
479: create_hash(
480: p_rule_index => l_rule_index

Line 599: FROM DUAL;

595: ) IS
596: BEGIN
597: SELECT wsh_pick_slip_numbers_s.NEXTVAL
598: INTO x_pick_slip_number
599: FROM DUAL;
600:
601: g_wip_pskey_table(l_hash_value) := l_insert_key_rec;
602: g_wip_pskey_table(l_hash_value).pick_slip_number := x_pick_slip_number;
603: EXCEPTION

Line 839: FROM DUAL;

835: /* Cluster Picking:
836: Do not store the pick slip numbers generated, as a new one is required for each line. */
837: SELECT wsh_pick_slip_numbers_s.NEXTVAL
838: INTO x_pick_slip_number
839: FROM DUAL;
840:
841: x_api_status := fnd_api.g_ret_sts_success;
842: RETURN;
843: END IF;

Line 879: FROM DUAL;

875: /* Cluster Picking:
876: Do not store the pick slip numbers generated, as a new one is required for each line. */
877: SELECT wsh_pick_slip_numbers_s.NEXTVAL
878: INTO x_pick_slip_number
879: FROM DUAL;
880: ELSE
881: -- Generate a new PickSlip Number and Insert it for future use.
882: create_hash(
883: p_rule_index => l_rule_index

Line 1327: FROM dual;

1323:
1324: IF (NOT l_success) AND l_pick_slip_number IS NULL THEN
1325: SELECT wsh_pick_slip_numbers_s.nextval
1326: INTO l_pick_slip_number
1327: FROM dual;
1328: l_pick_slip_status := 2;
1329: IF (l_debug = 1) THEN
1330: inv_log_util.trace('Failed to INSERT or LOCK pick slip record. Returning next value: '
1331: || l_pick_slip_number,

Line 1493: FROM dual;

1489:
1490: IF (p_ps_mode = 'I' AND l_limit = 1) THEN
1491: SELECT wsh_pick_slip_numbers_s.NEXTVAL
1492: INTO x_pick_slip_number
1493: FROM dual;
1494: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
1495: x_pick_slip_number;
1496: x_ready_to_print := FND_API.G_TRUE;
1497: x_api_status := FND_API.G_RET_STS_SUCCESS;

Line 1541: FROM DUAL;

1537:
1538: IF (g_rule_table(l_rule_index).pick_method = g_cluster_pick_method) THEN
1539: SELECT wsh_pick_slip_numbers_s.NEXTVAL
1540: INTO x_pick_slip_number
1541: FROM DUAL;
1542:
1543: x_api_status := fnd_api.g_ret_sts_success;
1544: RETURN;
1545: END IF;