[Home] [Help]
2705: End If;
2706:
2707: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
2708:
2709: INSERT INTO pa_transaction_interface_all(
2710: transaction_source
2711: , user_transaction_source
2712: , system_linkage
2713: , batch_name
2853: write_log(LOG, 'Inserting adjustment records..');
2854:
2855:
2856: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
2857: INSERT INTO pa_transaction_interface_all(
2858: transaction_source
2859: , user_transaction_source
2860: , system_linkage
2861: , batch_name
3011: FOR i in l_rev_child_dist_id_tbl.FIRST ..l_rev_child_dist_id_tbl.LAST LOOP
3012:
3013: IF l_rev_child_dist_id_tbl(i) > 0 THEN
3014:
3015: UPDATE pa_transaction_interface_all xface
3016: SET xface.net_zero_adjustment_flag ='Y',
3017: xface.adjusted_txn_interface_id =
3018: (select xface1.txn_interface_id
3019: from pa_transaction_interface xface1
4026: ,transaction_status_code
4027: ,project_id
4028: ,l_pa_addflag
4029: ,l_assets_addflag
4030: FROM pa_transaction_interface_all txnintf
4031: WHERE txnintf.transaction_source = p_txn_src
4032: AND txnintf.batch_name = p_batch_name
4033: AND txnintf.interface_id = p_interface_id;
4034:
4755:
4756: --FORALL i IN l_inv_pay_id_tbl.FIRST..l_inv_pay_id_tbl.LAST
4757: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
4758:
4759: INSERT INTO pa_transaction_interface_all(
4760: transaction_source
4761: , user_transaction_source
4762: , system_linkage
4763: , batch_name
4894: write_log(LOG, 'Inserting adjustment records..');
4895: --FORALL i IN l_inv_pay_id_tbl.FIRST..l_inv_pay_id_tbl.LAST
4896: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
4897:
4898: INSERT INTO pa_transaction_interface_all(
4899: transaction_source
4900: , user_transaction_source
4901: , system_linkage
4902: , batch_name
5045: FOR i in l_rev_child_dist_id_tbl.FIRST ..l_rev_child_dist_id_tbl.LAST LOOP
5046:
5047: IF l_rev_child_dist_id_tbl(i) > 0 THEN
5048:
5049: UPDATE pa_transaction_interface_all xface
5050: SET xface.net_zero_adjustment_flag ='Y',
5051: xface.adjusted_txn_interface_id =
5052: (select xface1.txn_interface_id
5053: from pa_transaction_interface xface1
5791: BEGIN
5792:
5793: FORALL i IN l_rcv_txn_id_tbl.FIRST..l_rcv_txn_id_tbl.LAST
5794:
5795: INSERT INTO pa_transaction_interface_all(
5796: transaction_source
5797: , user_transaction_source
5798: , system_linkage
5799: , batch_name
5931: write_log(LOG, 'Inserting adjustment records..');
5932:
5933: FORALL i IN l_rcv_txn_id_tbl.FIRST..l_rcv_txn_id_tbl.LAST
5934:
5935: INSERT INTO pa_transaction_interface_all(
5936: transaction_source
5937: , user_transaction_source
5938: , system_linkage
5939: , batch_name
7101: ,project_id
7102: ,l_pa_addflag
7103: ,orig_exp_txn_reference2 -- pricing changes
7104: ,dr_code_combination_id
7105: FROM pa_transaction_interface_all txnintf
7106: WHERE txnintf.transaction_source = p_txn_src
7107: AND txnintf.batch_name = p_batch_name
7108: AND txnintf.interface_id = p_interface_id;
7109:
7333: for NRTAX */
7334:
7335: write_log(LOG,'Batch Name and Interface Id is : '||G_RCVTAX_BATCH_NAME||' '||G_UNIQUE_ID);
7336:
7337: UPDATE pa_transaction_interface_all
7338: SET transaction_status_code = 'T'
7339: WHERE batch_name = G_RCVTAX_BATCH_NAME /* p_batch_name changed for #2912545 */
7340: AND interface_id = G_RCVNRT_INTERFACE_ID /* p_interface_id changed for #2912545 */
7341: AND transaction_source = 'PO RECEIPT NRTAX' /* PO RECEIPT TAX. changed for #2912545 */
7343: AND cdl_system_reference3 = v_po_dist_id
7344: AND cdl_system_reference4 = v_txn_id;
7345:
7346: -- pricing changes
7347: UPDATE pa_transaction_interface_all
7348: SET transaction_status_code = 'T'
7349: WHERE batch_name = G_RCVTAX_BATCH_NAME /* p_batch_name changed for #2912545 */
7350: AND interface_id = G_RCVNRT_INTERFACE_ID /* p_interface_id changed for #2912545 */
7351: AND transaction_source = 'PO RECEIPT NRTAX PRICE ADJ' /* PO RECEIPT TAX. changed for #2912545 */
7831: BEGIN
7832:
7833: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
7834:
7835: INSERT INTO pa_transaction_interface_all(
7836: transaction_source
7837: , user_transaction_source
7838: , system_linkage
7839: , batch_name
7975: write_log(LOG, 'Inserting adjustment records..');
7976: End if;
7977:
7978: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
7979: INSERT INTO pa_transaction_interface_all(
7980: transaction_source
7981: , user_transaction_source
7982: , system_linkage
7983: , batch_name
8502: ,transaction_status_code
8503: ,project_id
8504: ,l_pa_addflag
8505: ,l_assets_addflag
8506: FROM pa_transaction_interface_all txnintf
8507: WHERE txnintf.transaction_source = p_txn_src
8508: AND txnintf.batch_name = p_batch_name
8509: AND txnintf.interface_id = p_interface_id;
8510:
9492: BEGIN
9493:
9494: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
9495:
9496: INSERT INTO pa_transaction_interface_all(
9497: transaction_source
9498: , user_transaction_source
9499: , system_linkage
9500: , batch_name
9638: write_log(LOG, 'Inserting adjustment records..');
9639:
9640: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
9641:
9642: INSERT INTO pa_transaction_interface_all(
9643: transaction_source
9644: , user_transaction_source
9645: , system_linkage
9646: , batch_name
9795: write_log(LOG, 'Updating adjustment records..');
9796: IF l_rev_child_dist_id_tbl.exists(1) THEN
9797: FOR i in l_rev_child_dist_id_tbl.FIRST ..l_rev_child_dist_id_tbl.LAST LOOP
9798: IF l_rev_child_dist_id_tbl(i) > 0 THEN
9799: UPDATE pa_transaction_interface_all xface
9800: SET xface.net_zero_adjustment_flag ='Y',
9801: xface.adjusted_txn_interface_id =
9802: (select xface1.txn_interface_id
9803: from pa_transaction_interface xface1
10793: ,transaction_status_code
10794: ,project_id
10795: ,l_pa_addflag
10796: ,l_assets_addflag
10797: FROM pa_transaction_interface_all txnintf
10798: WHERE txnintf.transaction_source = p_txn_src
10799: AND txnintf.batch_name = p_batch_name
10800: AND txnintf.interface_id = p_interface_id;
10801: