APPS.AR_GTA_TRX_UTIL dependencies on AR_GTA_TRX_LINES

Line 534: -- AND AR_GTA_TRX_LINES_ALL.

530: --
531: -- DESCRIPTION:
532: --
533: -- This package can insert a set of trx to AR_GTA_TRX_HEADS_ALL
534: -- AND AR_GTA_TRX_LINES_ALL.
535: --
536: -- PARAMETERS:
537: -- In: p_gta_trxs trx_tbl_type
538: --

Line 752: ar_gta_trx_lines_all_pkg.insert_row

748: log( 'begin create_trx_line '||p_gta_trx.trx_lines(l_count).ar_trx_line_id);
749: END IF;
750: -- end log
751:
752: ar_gta_trx_lines_all_pkg.insert_row
753: (p_rowid => line_row_id
754: ,p_org_id => p_gta_trx.trx_lines(l_count).org_id
755: ,p_gta_trx_header_id => p_gta_trx.trx_lines(l_count).gta_trx_header_id
756: ,p_gta_trx_line_id => p_gta_trx.trx_lines(l_count).gta_trx_line_id

Line 879: l_gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE;

875: IS
876: l_procedure_name VARCHAR2(100) :='Get_Trx';
877: l_trx_rec trx_rec_type;
878: l_line_count NUMBER;
879: l_gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE;
880: CURSOR c_trx_lines(l_header_id IN NUMBER) IS
881: SELECT gta_trx_line_id
882: FROM ar_gta_trx_lines_all
883: WHERE gta_trx_header_id = l_header_id;

Line 882: FROM ar_gta_trx_lines_all

878: l_line_count NUMBER;
879: l_gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE;
880: CURSOR c_trx_lines(l_header_id IN NUMBER) IS
881: SELECT gta_trx_line_id
882: FROM ar_gta_trx_lines_all
883: WHERE gta_trx_header_id = l_header_id;
884:
885: BEGIN
886: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 911: AR_GTA_TRX_LINES_ALL_PKG.Query_Row

907: THEN
908: log('get trx_line_id: '||l_gta_trx_line_id);
909: END IF;
910: l_trx_rec.trx_lines.EXTEND;
911: AR_GTA_TRX_LINES_ALL_PKG.Query_Row
912: (p_trx_line_id =>l_gta_trx_line_id
913: ,x_trx_line_rec =>l_trx_rec.trx_lines(l_trx_rec.trx_lines.count));
914:
915: END LOOP;

Line 968: FROM ar_gta_trx_lines_all

964: IF p_tax_flag = 'Y' THEN
965: SELECT SUM(nvl(amount, 0) + nvl(tax_amount, 0) +
966: nvl(discount_amount, 0) + nvl(discount_tax_amount, 0))
967: INTO l_ret
968: FROM ar_gta_trx_lines_all
969: WHERE gta_trx_header_id = p_header_id
970: AND enabled_flag = 'Y';
971: ELSE
972: --added by Jixun for bug#16007984 end

Line 977: FROM ar_gta_trx_lines_all

973: SELECT
974: --SUM(nvl(amount,0))
975: SUM(nvl(amount, 0) + nvl(discount_amount, 0)) --Yao Modified for R12.1.2 to support discount line
976: INTO l_ret
977: FROM ar_gta_trx_lines_all
978: WHERE gta_trx_header_id = p_header_id
979: AND enabled_flag = 'Y';
980: END IF; --added by Jixun for bug#16007984
981:

Line 1017: ar_gta_trx_lines_all

1013: CURSOR c_original_amount IS
1014: SELECT
1015: SUM(nvl(original_currency_amount,0))
1016: FROM
1017: ar_gta_trx_lines_all
1018: WHERE gta_trx_header_id = p_header_id
1019: AND enabled_flag = 'Y';
1020: BEGIN
1021: OPEN c_original_amount;

Line 1056: DELETE ar_gta_trx_lines_all

1052: (p_gta_trx_header_id IN NUMBER)
1053: IS
1054: BEGIN
1055: --Delete lines
1056: DELETE ar_gta_trx_lines_all
1057: WHERE gta_trx_header_id = p_gta_trx_header_id;
1058:
1059: --Delete Headers
1060: DELETE ar_gta_trx_headers_all

Line 1095: FROM ar_gta_trx_lines

1091: BEGIN
1092: SELECT --SUM(nvl(tax_amount,0))
1093: SUM(nvl(tax_amount,0)+nvl(discount_tax_amount,0))--Yao Modified for R12.1.2
1094: INTO l_ret
1095: FROM ar_gta_trx_lines
1096: WHERE gta_trx_header_id = p_header_id
1097: AND enabled_flag = 'Y';
1098: RETURN l_ret;
1099: END get_gtainvoice_tax_amount;

Line 4563: FROM ar_gta_trx_lines_all JGTLA

4559: WHERE JGTM.Limitation_Id = JGTL.LIMITATION_ID)
4560: AND (JGTL.invoice_type IN ('0', '2') OR
4561: (JGTL.invoice_type = '1' AND NOT EXISTS
4562: ( SELECT *
4563: FROM ar_gta_trx_lines_all JGTLA
4564: WHERE JGTLA.GTA_TRX_HEADER_ID = l_gta_trx_header_id
4565: AND JGTLA.Org_Id = l_org_id
4566: AND (JGTLA.Tax_Rate <> 0 OR
4567: JGTLA.Tax_Amount <> 0))));

Line 4645: FROM ar_gta_trx_lines_all JGTLA

4641: WHERE JGTM.Limitation_Id = JGTL.LIMITATION_ID)
4642: AND (JGTL.invoice_type IN ('0', '2') OR
4643: (JGTL.invoice_type = '1' AND NOT EXISTS
4644: ( SELECT *
4645: FROM ar_gta_trx_lines_all JGTLA
4646: WHERE JGTLA.GTA_TRX_HEADER_ID =
4647: JGTH.GTA_TRX_HEADER_ID
4648: AND JGTH.Org_Id = JGTLA.Org_Id
4649: AND (JGTLA.Tax_Rate <> 0 OR