[Home] [Help]
341: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;
342: ELSE
343: SELECT rcv_transactions_interface_s.NEXTVAL
344: INTO l_interface_transaction_id
345: FROM DUAL;
346: END IF;
347:
348: IF (l_debug = 1) THEN
349: print_debug('RTI interface id:' || l_interface_transaction_id, 4);
786: -- to generate a new value for header_intf_id to insert in RTI.
787: IF g_shipment_header_id IS NULL THEN
788: SELECT rcv_headers_interface_s.NEXTVAL
789: INTO g_header_intf_id
790: FROM dual;
791: END IF;
792:
793: IF l_rcv_transaction_rec.source_type_code = 'INTERNAL'
794: -- For Bug 7440217
800:
801: IF g_shipment_header_id IS NULL THEN
802: SELECT rcv_shipment_headers_s.NEXTVAL
803: INTO g_shipment_header_id
804: FROM DUAL;
805: END IF;
806:
807: IF (l_debug = 1) THEN
808: print_debug('insert_txn_interface: 4 before rcv_trx_interface_insert_pkg.insert_row '
1824: l_progress := '40';
1825:
1826: SELECT rcv_interface_groups_s.NEXTVAL
1827: INTO l_group_id
1828: FROM DUAL;
1829:
1830: l_progress := '50';
1831:
1832: IF (l_debug = 1) THEN
2210:
2211: BEGIN
2212: SELECT rcv_transactions_interface_s.NEXTVAL
2213: INTO l_rcv_transaction_rec.interface_transaction_id
2214: FROM DUAL;
2215:
2216: l_progress := '83';
2217: /*
2218: We get the project /task from create_std..rec itself and it in turns
2802: -- default l_group_id ? clear group id after done
2803: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2804: SELECT rcv_interface_groups_s.NEXTVAL
2805: INTO l_group_id
2806: FROM DUAL;
2807:
2808: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2809: ELSE
2810: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3547: -- default l_group_id ? clear group id after done
3548: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3549: SELECT rcv_interface_groups_s.NEXTVAL
3550: INTO l_group_id
3551: FROM DUAL;
3552:
3553: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3554: ELSE
3555: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4375: -- default l_group_id ? clear group id after done
4376: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
4377: SELECT rcv_interface_groups_s.NEXTVAL
4378: INTO l_group_id
4379: FROM DUAL;
4380:
4381: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
4382: ELSE
4383: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4749:
4750: BEGIN
4751: SELECT rcv_transactions_interface_s.NEXTVAL
4752: INTO l_rcv_transaction_rec.interface_transaction_id
4753: FROM DUAL;
4754:
4755: l_progress := '83';
4756: l_project_id := p_project_id;
4757: l_task_id := p_task_id;
7510:
7511: IF g_header_intf_id IS NULL THEN
7512: SELECT rcv_headers_interface_s.NEXTVAL
7513: INTO g_header_intf_id
7514: FROM SYS.DUAL;
7515: END IF;
7516:
7517: l_progress := '25';
7518:
8972: l_progress := '20';
8973:
8974: /* bug# 2783559
8975: We dont need to check for incompatible serial/lot/revision codes here,
8976: but in individual lpns
8977: IF l_lpn_count > 0 THEN
8978: -- fix for bug 2403033
8979: BEGIN
8980: SELECT 1
9064: l_progress := '20';
9065:
9066: /* bug# 2783559
9067: We dont need to check for incompatible serial/lot/revision codes here,
9068: but in individual lpns
9069:
9070: IF l_lpn_count > 0 THEN
9071: -- fix for bug 2403033
9072: BEGIN
9283: END LOOP;
9284:
9285: CLOSE c_order_lines;
9286: l_progress := '50';
9287: /* bug 2783559 Dont need to check it here but, in individual lpn
9288: FOR ASN,Int Req and Int Shipment
9289:
9290: IF l_lpn_flag = 1 THEN
9291:
9509:
9510: BEGIN
9511: SELECT count(1)
9512: INTO l_partial_rcpt
9513: FROM dual
9514: WHERE EXISTS ( SELECT 1
9515: FROM rcv_transactions
9516: WHERE shipment_header_id = p_shipment_header_id
9517: AND organization_id = p_rcv_org_id
9524: IF l_partial_rcpt = 0 THEN
9525: BEGIN
9526: SELECT count(1)
9527: INTO l_partial_rcpt
9528: FROM dual
9529: WHERE EXISTS ( SELECT 1
9530: FROM rcv_transactions_interface
9531: WHERE shipment_header_id = p_shipment_header_id
9532: AND to_organization_id = p_rcv_org_id