[Home] [Help]
339: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;
340: ELSE
341: SELECT rcv_transactions_interface_s.NEXTVAL
342: INTO l_interface_transaction_id
343: FROM DUAL;
344: END IF;
345:
346: IF (l_debug = 1) THEN
347: print_debug('RTI interface id:' || l_interface_transaction_id, 4);
752: -- to generate a new value for header_intf_id to insert in RTI.
753: IF g_shipment_header_id IS NULL THEN
754: SELECT rcv_headers_interface_s.NEXTVAL
755: INTO g_header_intf_id
756: FROM dual;
757: END IF;
758:
759: IF l_rcv_transaction_rec.source_type_code = 'INTERNAL'
760: -- For Bug 7440217
766:
767: IF g_shipment_header_id IS NULL THEN
768: SELECT rcv_shipment_headers_s.NEXTVAL
769: INTO g_shipment_header_id
770: FROM DUAL;
771: END IF;
772:
773: IF (l_debug = 1) THEN
774: print_debug('insert_txn_interface: 4 before rcv_trx_interface_insert_pkg.insert_row '
1775: l_progress := '40';
1776:
1777: SELECT rcv_interface_groups_s.NEXTVAL
1778: INTO l_group_id
1779: FROM DUAL;
1780:
1781: l_progress := '50';
1782:
1783: IF (l_debug = 1) THEN
2157:
2158: BEGIN
2159: SELECT rcv_transactions_interface_s.NEXTVAL
2160: INTO l_rcv_transaction_rec.interface_transaction_id
2161: FROM DUAL;
2162:
2163: l_progress := '83';
2164: /*
2165: We get the project /task from create_std..rec itself and it in turns
2744: -- default l_group_id ? clear group id after done
2745: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2746: SELECT rcv_interface_groups_s.NEXTVAL
2747: INTO l_group_id
2748: FROM DUAL;
2749:
2750: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2751: ELSE
2752: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
3384: -- default l_group_id ? clear group id after done
3385: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3386: SELECT rcv_interface_groups_s.NEXTVAL
3387: INTO l_group_id
3388: FROM DUAL;
3389:
3390: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3391: ELSE
3392: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4191: -- default l_group_id ? clear group id after done
4192: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
4193: SELECT rcv_interface_groups_s.NEXTVAL
4194: INTO l_group_id
4195: FROM DUAL;
4196:
4197: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
4198: ELSE
4199: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4482:
4483: BEGIN
4484: SELECT rcv_transactions_interface_s.NEXTVAL
4485: INTO l_rcv_transaction_rec.interface_transaction_id
4486: FROM DUAL;
4487:
4488: l_progress := '83';
4489: l_project_id := p_project_id;
4490: l_task_id := p_task_id;
7125:
7126: IF g_header_intf_id IS NULL THEN
7127: SELECT rcv_headers_interface_s.NEXTVAL
7128: INTO g_header_intf_id
7129: FROM SYS.DUAL;
7130: END IF;
7131:
7132: l_progress := '25';
7133:
8576: l_progress := '20';
8577:
8578: /* bug# 2783559
8579: We dont need to check for incompatible serial/lot/revision codes here,
8580: but in individual lpns
8581: IF l_lpn_count > 0 THEN
8582: -- fix for bug 2403033
8583: BEGIN
8584: SELECT 1
8668: l_progress := '20';
8669:
8670: /* bug# 2783559
8671: We dont need to check for incompatible serial/lot/revision codes here,
8672: but in individual lpns
8673:
8674: IF l_lpn_count > 0 THEN
8675: -- fix for bug 2403033
8676: BEGIN
8887: END LOOP;
8888:
8889: CLOSE c_order_lines;
8890: l_progress := '50';
8891: /* bug 2783559 Dont need to check it here but, in individual lpn
8892: FOR ASN,Int Req and Int Shipment
8893:
8894: IF l_lpn_flag = 1 THEN
8895:
9113:
9114: BEGIN
9115: SELECT count(1)
9116: INTO l_partial_rcpt
9117: FROM dual
9118: WHERE EXISTS ( SELECT 1
9119: FROM rcv_transactions
9120: WHERE shipment_header_id = p_shipment_header_id
9121: AND organization_id = p_rcv_org_id
9128: IF l_partial_rcpt = 0 THEN
9129: BEGIN
9130: SELECT count(1)
9131: INTO l_partial_rcpt
9132: FROM dual
9133: WHERE EXISTS ( SELECT 1
9134: FROM rcv_transactions_interface
9135: WHERE shipment_header_id = p_shipment_header_id
9136: AND to_organization_id = p_rcv_org_id