APPS.AR_GTA_SPLIT_TRX_PROC dependencies on AR_GTA_TRANSFER_TEMP

Line 38: --| 14-Dec-2005: Jim Zheng Add gta_inv_number into temp table ar_gta_transfer_temp

34: --| procedure Split_transactions
35: --| 06-Dec-2005: Jim Zheng Change the tax rate -- 0.17 to l_GTA_Trx_line.tax_rate
36: --| when split a trx line
37: --| 08-Dec-2005: Jim Zheng Add output log for debug
38: --| 14-Dec-2005: Jim Zheng Add gta_inv_number into temp table ar_gta_transfer_temp
39: --| 15-Dec-2005: Jim Zheng Add transaction id for successful transaction in add_succ_to_temp
40: --| 17-Feb-2006: Jogen Hu Replace fnd_file.put_line(fnd_file.log by log procedure
41: --| 25-Apr-2006: Jogen Hu Modify Split_Transactions for bug 5168852
42: --| 12-Jun-2006: Shujuan Yan Modify Split_trx_by_taxreg_num for bug 5258345

Line 1596: ar_gta_transfer_temp temp

1592: COUNT(*)
1593: INTO
1594: l_warning_record_count
1595: FROM
1596: ar_gta_transfer_temp temp
1597: WHERE temp.transaction_id = l_customer_trx_id
1598: AND temp.succeeded = 'W';
1599:
1600: IF l_warning_record_count = 0

Line 1603: ar_gta_transfer_temp t

1599:
1600: IF l_warning_record_count = 0
1601: THEN
1602: INSERT INTO
1603: ar_gta_transfer_temp t
1604: (t.seq
1605: , t.succeeded
1606: , t.transaction_id
1607: , t.transaction_num

Line 1615: ar_gta_transfer_temp_s.NEXTVAL

1611: , t.failedreason
1612: , t.gta_invoice_num
1613: )
1614: SELECT
1615: ar_gta_transfer_temp_s.NEXTVAL
1616: , 'Y'
1617: , l_customer_trx_id
1618: , l_trx_num
1619: , l_trx_type

Line 1629: ar_gta_transfer_temp temp

1625: dual;
1626: ELSIF l_warning_record_count = 1
1627: THEN
1628: UPDATE
1629: ar_gta_transfer_temp temp
1630: SET
1631: temp.amount = l_amount
1632: WHERE temp.transaction_id = l_customer_trx_id
1633: AND temp.succeeded = 'W';

Line 2461: --delete warning data from ar_gta_transfer_temp

2457:
2458: EXCEPTION
2459: WHEN l_cm_exceed_limit
2460: THEN
2461: --delete warning data from ar_gta_transfer_temp
2462: DELETE
2463: ar_gta_transfer_temp temp
2464: WHERE temp.transaction_id = l_gta_trx.trx_header.ra_trx_id
2465: AND temp.succeeded = 'W';

Line 2463: ar_gta_transfer_temp temp

2459: WHEN l_cm_exceed_limit
2460: THEN
2461: --delete warning data from ar_gta_transfer_temp
2462: DELETE
2463: ar_gta_transfer_temp temp
2464: WHERE temp.transaction_id = l_gta_trx.trx_header.ra_trx_id
2465: AND temp.succeeded = 'W';
2466:
2467: -- error message into temp table.

Line 2469: ar_gta_transfer_temp t

2465: AND temp.succeeded = 'W';
2466:
2467: -- error message into temp table.
2468: INSERT INTO
2469: ar_gta_transfer_temp t
2470: (t.seq
2471: , t.transaction_id
2472: , t.succeeded
2473: , t.transaction_num

Line 2481: ar_gta_transfer_temp_s.NEXTVAL

2477: , t.failedreason
2478: , t.gta_invoice_num
2479: )
2480: SELECT
2481: ar_gta_transfer_temp_s.NEXTVAL
2482: , l_gta_trx.trx_header.ra_trx_id
2483: , 'N'
2484: , l_gta_trx.trx_header.ra_trx_number
2485: , 'CM'