[Home] [Help]
5938: AND NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') <> 'DELIVER') THEN --{
5939: -- Bug 2551443 Removed po_distributions from the FROM clause
5940: SELECT COUNT(*)
5941: INTO x_temp_count
5942: FROM DUAL
5943: WHERE EXISTS(SELECT 1
5944: FROM po_line_locations pll,
5945: po_lines pl
5946: WHERE pl.po_line_id = temp_cascaded_table(current_n).po_line_id
8219: v_current_interface_id := v_trans_tab(j).interface_transaction_id;
8220: l_ls_table_idx := l_ls_table.COUNT + 1;
8221:
8222: /* SELECT GROUP_SEQUENCE_ID_S.nextval into V_TRANS_TAB(j).GROUP_ID
8223: from dual; -- Check whether this has to be unique */
8224: -- Will use the group_id from the header_record as the pre-processor
8225: -- needs the header and transactions group id to be the same
8226: IF (v_trans_tab(j).transaction_type IN('RECEIVE', 'SHIP')) THEN
8227: v_trans_tab(j).GROUP_ID := v_header_record.header_record.GROUP_ID;
8268: AND v_trans_tab(j).lpn_group_id IS NULL
8269: ) THEN
8270: SELECT rcv_interface_groups_s.NEXTVAL
8271: INTO v_trans_tab(j).lpn_group_id
8272: FROM DUAL;
8273: END IF;
8274:
8275: IF (g_asn_debug = 'Y') THEN
8276: asn_debug.put_line('Inserting new RTI');
8632: AND v_trans_tab(j).lpn_group_id IS NULL
8633: ) THEN
8634: SELECT rcv_interface_groups_s.CURRVAL
8635: INTO v_trans_tab(j).lpn_group_id
8636: FROM DUAL;
8637: END IF;
8638:
8639: IF (g_asn_debug = 'Y') THEN
8640: asn_debug.put_line('category_id ' || v_trans_tab(j).category_id);