APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on JMF_GTA_TRANSFER_TEMP

Line 38: --| 14-Dec-2005: Jim Zheng Add gta_inv_number into temp table jmf_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 jmf_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 1210: jmf_gta_transfer_temp temp

1206: COUNT(*)
1207: INTO
1208: l_warning_record_count
1209: FROM
1210: jmf_gta_transfer_temp temp
1211: WHERE temp.transaction_id = l_customer_trx_id
1212: AND temp.succeeded = 'W';
1213:
1214: IF l_warning_record_count = 0

Line 1217: jmf_gta_transfer_temp t

1213:
1214: IF l_warning_record_count = 0
1215: THEN
1216: INSERT INTO
1217: jmf_gta_transfer_temp t
1218: (t.seq
1219: , t.succeeded
1220: , t.transaction_id
1221: , t.transaction_num

Line 1229: jmf_gta_transfer_temp_s.NEXTVAL

1225: , t.failedreason
1226: , t.gta_invoice_num
1227: )
1228: SELECT
1229: jmf_gta_transfer_temp_s.NEXTVAL
1230: , 'Y'
1231: , l_customer_trx_id
1232: , l_trx_num
1233: , l_trx_type

Line 1243: jmf_gta_transfer_temp temp

1239: dual;
1240: ELSIF l_warning_record_count = 1
1241: THEN
1242: UPDATE
1243: jmf_gta_transfer_temp temp
1244: SET
1245: temp.amount = l_amount
1246: WHERE temp.transaction_id = l_customer_trx_id
1247: AND temp.succeeded = 'W';

Line 2049: --delete warning data from jmf_gta_transfer_temp

2045:
2046: EXCEPTION
2047: WHEN l_cm_exceed_limit
2048: THEN
2049: --delete warning data from jmf_gta_transfer_temp
2050: DELETE
2051: jmf_gta_transfer_temp temp
2052: WHERE temp.transaction_id = l_gta_trx.trx_header.ra_trx_id
2053: AND temp.succeeded = 'W';

Line 2051: jmf_gta_transfer_temp temp

2047: WHEN l_cm_exceed_limit
2048: THEN
2049: --delete warning data from jmf_gta_transfer_temp
2050: DELETE
2051: jmf_gta_transfer_temp temp
2052: WHERE temp.transaction_id = l_gta_trx.trx_header.ra_trx_id
2053: AND temp.succeeded = 'W';
2054:
2055: -- error message into temp table.

Line 2057: jmf_gta_transfer_temp t

2053: AND temp.succeeded = 'W';
2054:
2055: -- error message into temp table.
2056: INSERT INTO
2057: jmf_gta_transfer_temp t
2058: (t.seq
2059: , t.transaction_id
2060: , t.succeeded
2061: , t.transaction_num

Line 2069: jmf_gta_transfer_temp_s.NEXTVAL

2065: , t.failedreason
2066: , t.gta_invoice_num
2067: )
2068: SELECT
2069: jmf_gta_transfer_temp_s.NEXTVAL
2070: , l_gta_trx.trx_header.ra_trx_id
2071: , 'N'
2072: , l_gta_trx.trx_header.ra_trx_number
2073: , 'CM'