APPS.GML_RCV_DIR_RCPT_APIS dependencies on DUAL

Line 308: FROM dual;

304: -- default l_group_id ? clear group id after done
305: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
306: SELECT rcv_interface_groups_s.nextval
307: INTO l_group_id
308: FROM dual;
309: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
310: ELSE
311: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
312: END IF;

Line 771: FROM dual;

767: -- default l_group_id ? clear group id after done
768: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
769: SELECT rcv_interface_groups_s.nextval
770: INTO l_group_id
771: FROM dual;
772: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
773: ELSE
774: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
775: END IF;

Line 1332: FROM dual;

1328: -- default l_group_id ? clear group id after done
1329: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
1330: SELECT rcv_interface_groups_s.nextval
1331: INTO l_group_id
1332: FROM dual;
1333: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1334: ELSE
1335: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1336: END IF;

Line 1791: FROM dual;

1787: -- default l_group_id ? clear group id after done
1788: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
1789: SELECT rcv_interface_groups_s.nextval
1790: INTO l_group_id
1791: FROM dual;
1792: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1793: ELSE
1794: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1795: END IF;

Line 2423: FROM dual;

2419: -- default l_group_id ? clear group id after done
2420: IF INV_rcv_common_apis.g_rcv_global_var.interface_group_id is NULL THEN
2421: SELECT rcv_interface_groups_s.nextval
2422: INTO l_group_id
2423: FROM dual;
2424: INV_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2425: ELSE
2426: l_group_id := INV_rcv_common_apis.g_rcv_global_var.interface_group_id;
2427: END IF;

Line 2990: FROM dual;

2986: IF l_serial_txn_temp_id IS NULL THEN -- Not lot controlled
2987: l_progress := '42';
2988: SELECT mtl_material_transactions_s.NEXTVAL
2989: INTO l_serial_txn_temp_id
2990: FROM dual;
2991: l_progress := '44';
2992:
2993: l_transaction_temp_id := l_serial_txn_temp_id;
2994: END IF;