APPS.CSP_RECEIVE_PVT dependencies on DUAL

Line 597: FROM sys.dual;

593: l_header_interface_id := p_header_interface_id;
594: If (l_header_interface_id IS NULL) THEN
595: SELECT rcv_headers_interface_s.NEXTVAL
596: INTO l_header_interface_id
597: FROM sys.dual;
598: End If;
599:
600: l_group_id := p_group_id;
601: If (l_group_id IS NULL) THEN

Line 604: FROM sys.dual;

600: l_group_id := p_group_id;
601: If (l_group_id IS NULL) THEN
602: SELECT rcv_interface_groups_s.NEXTVAL
603: INTO l_group_id
604: FROM sys.dual;
605: End If;
606: l_receipt_num := p_receipt_num;
607: If l_receipt_num is NULL Then
608: gen_receipt_num(

Line 867: FROM sys.dual;

863: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;
864: If (l_interface_transaction_id IS NULL) THEN
865: SELECT rcv_transactions_interface_s.NEXTVAL
866: INTO l_interface_transaction_id
867: FROM sys.dual;
868: END IF;
869:
870: -- call defaulting api
871: begin

Line 1649: FROM sys.dual;

1645: l_transaction_interface_id := p_transaction_interface_id;
1646: If (l_transaction_interface_id IS NULL) THEN
1647: SELECT mtl_material_transactions_s.NEXTVAL
1648: INTO l_transaction_interface_id
1649: FROM sys.dual;
1650: END IF;
1651:
1652: OPEN c_mln_attributes(p_lot_number, p_inventory_item_id, p_organization_id);
1653: FETCH c_mln_attributes INTO

Line 2017: FROM sys.dual;

2013: l_transaction_interface_id := px_transaction_interface_id;
2014: IF (l_transaction_interface_id IS NULL) THEN
2015: SELECT mtl_material_transactions_s.NEXTVAL
2016: INTO l_transaction_interface_id
2017: FROM sys.dual;
2018: END IF;
2019:
2020: Insert into MTL_SERIAL_NUMBERS_INTERFACE
2021: (