APPS.INV_RCV_DIR_RCPT_APIS dependencies on DUAL

Line 445: FROM DUAL;

441: -- default l_group_id ? clear group id after done
442: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
443: SELECT rcv_interface_groups_s.NEXTVAL
444: INTO l_group_id
445: FROM DUAL;
446:
447: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
448:
449: IF (l_debug = 1) THEN

Line 1070: FROM DUAL;

1066: -- default l_group_id ? clear group id after done
1067: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1068: SELECT rcv_interface_groups_s.NEXTVAL
1069: INTO l_group_id
1070: FROM DUAL;
1071:
1072: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1073:
1074: IF (l_debug = 1) THEN

Line 1858: FROM DUAL;

1854: -- default l_group_id ? clear group id after done
1855: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1856: SELECT rcv_interface_groups_s.NEXTVAL
1857: INTO l_group_id
1858: FROM DUAL;
1859:
1860: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1861:
1862: IF (l_debug = 1) THEN

Line 2572: FROM DUAL;

2568: -- default l_group_id ? clear group id after done
2569: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2570: SELECT rcv_interface_groups_s.NEXTVAL
2571: INTO l_group_id
2572: FROM DUAL;
2573:
2574: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2575:
2576: IF (l_debug = 1) THEN

Line 3432: FROM DUAL;

3428: -- default l_group_id ? clear group id after done
3429: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3430: SELECT rcv_interface_groups_s.NEXTVAL
3431: INTO l_group_id
3432: FROM DUAL;
3433:
3434: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3435: ELSE
3436: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 4303: FROM DUAL;

4299: l_progress := '42';
4300:
4301: SELECT mtl_material_transactions_s.NEXTVAL
4302: INTO l_serial_txn_temp_id
4303: FROM DUAL;
4304:
4305: l_progress := '44';
4306: l_transaction_temp_id := l_serial_txn_temp_id;
4307: END IF;