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 1869: FROM DUAL;

1865: -- default l_group_id ? clear group id after done
1866: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1867: SELECT rcv_interface_groups_s.NEXTVAL
1868: INTO l_group_id
1869: FROM DUAL;
1870:
1871: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1872:
1873: IF (l_debug = 1) THEN

Line 2657: FROM DUAL;

2653: -- default l_group_id ? clear group id after done
2654: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2655: SELECT rcv_interface_groups_s.NEXTVAL
2656: INTO l_group_id
2657: FROM DUAL;
2658:
2659: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2660:
2661: IF (l_debug = 1) THEN

Line 3536: FROM DUAL;

3532: -- default l_group_id ? clear group id after done
3533: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3534: SELECT rcv_interface_groups_s.NEXTVAL
3535: INTO l_group_id
3536: FROM DUAL;
3537:
3538: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3539: ELSE
3540: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 4447: FROM DUAL;

4443: l_progress := '42';
4444:
4445: SELECT mtl_material_transactions_s.NEXTVAL
4446: INTO l_serial_txn_temp_id
4447: FROM DUAL;
4448:
4449: l_progress := '44';
4450: l_transaction_temp_id := l_serial_txn_temp_id;
4451: END IF;