APPS.CSP_RECEIVE_PVT dependencies on DUAL

Line 711: FROM sys.dual;

707: l_header_interface_id := p_header_interface_id;
708: If (l_header_interface_id IS NULL) THEN
709: SELECT rcv_headers_interface_s.NEXTVAL
710: INTO l_header_interface_id
711: FROM sys.dual;
712: End If;
713:
714: l_group_id := p_group_id;
715: If (l_group_id IS NULL) THEN

Line 718: FROM sys.dual;

714: l_group_id := p_group_id;
715: If (l_group_id IS NULL) THEN
716: SELECT rcv_interface_groups_s.NEXTVAL
717: INTO l_group_id
718: FROM sys.dual;
719: End If;
720: l_receipt_num := p_receipt_num;
721: If l_receipt_num is NULL Then
722: gen_receipt_num(

Line 981: FROM sys.dual;

977: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;
978: If (l_interface_transaction_id IS NULL) THEN
979: SELECT rcv_transactions_interface_s.NEXTVAL
980: INTO l_interface_transaction_id
981: FROM sys.dual;
982: END IF;
983:
984: -- call defaulting api
985: begin

Line 1763: FROM sys.dual;

1759: l_transaction_interface_id := p_transaction_interface_id;
1760: If (l_transaction_interface_id IS NULL) THEN
1761: SELECT mtl_material_transactions_s.NEXTVAL
1762: INTO l_transaction_interface_id
1763: FROM sys.dual;
1764: END IF;
1765:
1766: OPEN c_mln_attributes(p_lot_number, p_inventory_item_id, p_organization_id);
1767: FETCH c_mln_attributes INTO

Line 2131: FROM sys.dual;

2127: l_transaction_interface_id := px_transaction_interface_id;
2128: IF (l_transaction_interface_id IS NULL) THEN
2129: SELECT mtl_material_transactions_s.NEXTVAL
2130: INTO l_transaction_interface_id
2131: FROM sys.dual;
2132: END IF;
2133:
2134: Insert into MTL_SERIAL_NUMBERS_INTERFACE
2135: (