APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on JMF_GTA_TRX_HEADERS_ALL

Line 155: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;

151: l_trx_line_index NUMBER; -- loop index of trx lines
152: l_result BOOLEAN;
153:
154: l_trx_type ra_cust_trx_types_all.type%TYPE;
155: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;
156:
157: l_trx_group_number NUMBER;
158:
159: l_functional_price jmf_gta_trx_lines_all.unit_price%TYPE; --25-Apr-2006: Jogen Hu bug 5168852

Line 914: JMF_GTA_TRX_HEADERS_ALL_S.NEXTVAL

910: END IF;
911:
912: l_GTA_TRX_Header_Rec := p_GTA_TRX_Header_Rec;
913: SELECT
914: JMF_GTA_TRX_HEADERS_ALL_S.NEXTVAL
915: INTO
916: l_GTA_TRX_Header_Rec.gta_trx_header_id
917: FROM
918: dual;

Line 919: --x_GTA_TRX_Header_Rec.gta_trx_header_id := JMF_GTA_TRX_HEADERS_ALL_S.NEXTVAL;

915: INTO
916: l_GTA_TRX_Header_Rec.gta_trx_header_id
917: FROM
918: dual;
919: --x_GTA_TRX_Header_Rec.gta_trx_header_id := JMF_GTA_TRX_HEADERS_ALL_S.NEXTVAL;
920: -- use this if is due to the trx first split and
921:
922: l_GTA_TRX_Header_Rec.group_number := p_GTA_TRX_Header_Rec.group_number + 1;
923:

Line 1295: l_tax_reg_number jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;

1291: l_procedure_name VARCHAR2(100) := 'split_trx_by_tax_registration_number';
1292: l_gta_rate_trx_line JMF_GTA_TRX_UTIL.trx_line_rec_type;
1293: l_gta_rate_trx JMF_GTA_TRX_UTIL.trx_rec_type;
1294: l_gta_rate_trx_tbl JMF_GTA_TRX_UTIL.TRX_Tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_Tbl_TYPE();
1295: l_tax_reg_number jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;
1296: l_add_flag NUMBER := 0;
1297: l_gta_trx JMF_GTA_TRX_UTIL.trx_rec_type;
1298: l_gta_trx_line_init JMF_GTA_TRX_UTIL.trx_line_rec_type;
1299: l_trx_header_new JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;

Line 1634: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;

1630: , x_result OUT NOCOPY BOOLEAN)
1631: IS
1632: l_procedure_name VARCHAR2(30) := 'judge_cm_limit';
1633: l_gta_trx Jmf_Gta_Trx_Util.trx_rec_type;
1634: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;
1635: l_max_amount jmf_gta_tax_limits_all.max_amount%TYPE;
1636: l_max_line jmf_gta_tax_limits_all.max_num_of_line%TYPE;
1637: l_lines_number NUMBER;
1638: l_sum_of_amount NUMBER;

Line 1640: l_invoice_type jmf_gta_trx_headers_all.invoice_type%TYPE; --added by subba for R12.1

1636: l_max_line jmf_gta_tax_limits_all.max_num_of_line%TYPE;
1637: l_lines_number NUMBER;
1638: l_sum_of_amount NUMBER;
1639: l_trx_line_index NUMBER;
1640: l_invoice_type jmf_gta_trx_headers_all.invoice_type%TYPE; --added by subba for R12.1
1641: l_sales_list_flag jmf_gta_rule_headers_all.Sales_List_Flag%TYPE;--added by Yao Zhang for bug 7758496
1642: BEGIN
1643: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1644: THEN

Line 1797: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;

1793: , x_max_line OUT NOCOPY NUMBER)
1794: IS
1795: l_procedure_name VARCHAR2(30) := 'judge_cm_limit';
1796: l_gta_trx Jmf_Gta_Trx_Util.trx_rec_type;
1797: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;
1798: l_max_amount NUMBER;
1799: l_max_line NUMBER;
1800: l_error_string VARCHAR2(2000); --added by subba.
1801: BEGIN