DBA Data[Home] [Help]

APPS.INV_PR_PICK_SLIP_NUMBER dependencies on WSH_PR_PICK_SLIP_NUMBER

Line 409: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 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;
413: RETURN;

Line 550: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=

546: -- Print is immediate so check if limit has been reached
547: IF (p_ps_mode = 'I' AND l_limit <> -1) THEN
548: IF (g_pskey_table(l_hash_value).counter >= l_limit) THEN
549: x_ready_to_print := fnd_api.g_true;
550: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
551: x_pick_slip_number;
552: g_pskey_table.DELETE(l_hash_value);
553: END IF;
554: END IF;

Line 1494: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=

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;
1498: RETURN;

Line 1586: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=

1582:
1583: IF (p_ps_mode = 'I' AND l_limit <> -1) THEN
1584: IF l_pick_slip_status = 2 THEN
1585: x_ready_to_print := fnd_api.g_true;
1586: wsh_pr_pick_slip_number.g_print_ps_table(wsh_pr_pick_slip_number.g_print_ps_table.COUNT + 1) :=
1587: x_pick_slip_number;
1588: --<< check if deletion from the table is required, if so we can delete instead of update >>
1589: END IF;
1590: END IF;