[Home] [Help]
590: BEGIN
591: IF g_group_id = 0 THEN
592: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
593: INTO g_group_id
594: FROM dual;
595: END IF;
596:
597: RETURN g_group_id;
598: END get_group_id;
1262:
1263: BEGIN
1264: SELECT 'Y'
1265: INTO po_update_flag
1266: FROM dual
1267: WHERE EXISTS (SELECT segment1
1268: FROM po_headers_all
1269: WHERE segment1=p_attributes.po_number
1270: AND org_id=hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1937: BEGIN
1938: -- interface_transaction_id
1939: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
1940: INTO p_rti_row.interface_transaction_id
1941: FROM dual;
1942:
1943: -- job_id
1944: BEGIN
1945: p_rti_row.job_id := get_po_line(p_attributes.po_line_id).job_id;
2020:
2021: -- header_id
2022: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL
2023: INTO l_rhi_row.header_interface_id
2024: FROM dual;
2025:
2026: -- group_id
2027: l_rhi_row.group_id := get_group_id( p_rti_rows );
2028:
2349:
2350: -- get the next rti id for the receive transaction
2351: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
2352: INTO l_rcv_rti_row.interface_transaction_id
2353: FROM dual;
2354:
2355: -- insert into rti table
2356: p_rti_rows(p_rti_rows.COUNT + 1) := l_del_rti_row;
2357: p_rti_rows(p_rti_rows.COUNT + 1) := l_rcv_rti_row;
2360:
2361: -- get the next rti id for the deliver transaction
2362: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
2363: INTO l_del_rti_row.interface_transaction_id
2364: FROM dual;
2365:
2366: -- insert into rti table
2367: p_rti_rows(p_rti_rows.COUNT + 1) := l_rcv_rti_row;
2368: p_rti_rows(p_rti_rows.COUNT + 1) := l_del_rti_row;
2496: -- use lpn_group_id to make sure that the receiving transactions are atomic for this block
2497: BEGIN
2498: SELECT rcv_interface_groups_s.NEXTVAL
2499: INTO p_attributes.lpn_group_id
2500: FROM dual;
2501:
2502: p_old_attributes.lpn_group_id := p_attributes.lpn_group_id;
2503: EXCEPTION
2504: WHEN OTHERS THEN