APPS.AR_GTA_SPLIT_TRX_PROC dependencies on AR_GTA_TRX_HEADERS

Line 192: l_fp_reg_num ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;

188: l_trx_line_index NUMBER; -- loop index of trx lines
189: l_result BOOLEAN;
190:
191: l_trx_type ra_cust_trx_types_all.type%TYPE;
192: l_fp_reg_num ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
193:
194: l_trx_group_number NUMBER;
195:
196: l_functional_price ar_gta_trx_lines_all.unit_price%TYPE; --25-Apr-2006: Jogen Hu bug 5168852

Line 1286: l_gta_header_id ar_gta_trx_headers.gta_trx_header_id%TYPE;

1282: ( p_GTA_TRX_Header_Rec IN AR_GTA_TRX_UTIL.TRX_HEADER_REC_TYPE
1283: , x_GTA_TRX_Header_Rec OUT NOCOPY AR_GTA_TRX_UTIL.TRX_HEADER_REC_TYPE
1284: ) AS
1285: l_procedure_name VARCHAR2(30):= 'Copy_Header';
1286: l_gta_header_id ar_gta_trx_headers.gta_trx_header_id%TYPE;
1287: l_gta_trx_header_rec AR_GTA_TRX_UTIL.TRX_HEADER_REC_TYPE;
1288:
1289: BEGIN
1290: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1299: AR_GTA_TRX_HEADERS_ALL_S.NEXTVAL

1295: END IF;
1296:
1297: l_GTA_TRX_Header_Rec := p_GTA_TRX_Header_Rec;
1298: SELECT
1299: AR_GTA_TRX_HEADERS_ALL_S.NEXTVAL
1300: INTO
1301: l_GTA_TRX_Header_Rec.gta_trx_header_id
1302: FROM
1303: dual;

Line 1304: --x_GTA_TRX_Header_Rec.gta_trx_header_id := AR_GTA_TRX_HEADERS_ALL_S.NEXTVAL;

1300: INTO
1301: l_GTA_TRX_Header_Rec.gta_trx_header_id
1302: FROM
1303: dual;
1304: --x_GTA_TRX_Header_Rec.gta_trx_header_id := AR_GTA_TRX_HEADERS_ALL_S.NEXTVAL;
1305: -- use this if is due to the trx first split and
1306:
1307: l_GTA_TRX_Header_Rec.group_number := p_GTA_TRX_Header_Rec.group_number + 1;
1308:

Line 1681: l_tax_reg_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;

1677: l_procedure_name VARCHAR2(100) := 'split_trx_by_tax_registration_number';
1678: l_gta_rate_trx_line AR_GTA_TRX_UTIL.trx_line_rec_type;
1679: l_gta_rate_trx AR_GTA_TRX_UTIL.trx_rec_type;
1680: l_gta_rate_trx_tbl AR_GTA_TRX_UTIL.TRX_Tbl_TYPE := AR_GTA_TRX_UTIL.TRX_Tbl_TYPE();
1681: l_tax_reg_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
1682: l_add_flag NUMBER := 0;
1683: l_gta_trx AR_GTA_TRX_UTIL.trx_rec_type;
1684: l_gta_trx_line_init AR_GTA_TRX_UTIL.trx_line_rec_type;
1685: l_trx_header_new AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;

Line 2043: l_fp_reg_num ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;

2039: , x_result OUT NOCOPY BOOLEAN)
2040: IS
2041: l_procedure_name VARCHAR2(30) := 'judge_cm_limit';
2042: l_gta_trx AR_Gta_Trx_Util.trx_rec_type;
2043: l_fp_reg_num ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
2044: l_max_amount ar_gta_tax_limits_all.max_amount%TYPE;
2045: l_max_line ar_gta_tax_limits_all.max_num_of_line%TYPE;
2046: l_lines_number NUMBER;
2047: l_sum_of_amount NUMBER;

Line 2049: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE; --added by subba for R12.1

2045: l_max_line ar_gta_tax_limits_all.max_num_of_line%TYPE;
2046: l_lines_number NUMBER;
2047: l_sum_of_amount NUMBER;
2048: l_trx_line_index NUMBER;
2049: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE; --added by subba for R12.1
2050: l_sales_list_flag ar_gta_rule_headers_all.Sales_List_Flag%TYPE;--added by Yao Zhang for bug 7758496
2051: BEGIN
2052: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2053: THEN

Line 2208: l_fp_reg_num ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;

2204: , x_max_line OUT NOCOPY NUMBER)
2205: IS
2206: l_procedure_name VARCHAR2(30) := 'judge_cm_limit';
2207: l_gta_trx AR_Gta_Trx_Util.trx_rec_type;
2208: l_fp_reg_num ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
2209: l_max_amount NUMBER;
2210: l_max_line NUMBER;
2211: l_error_string VARCHAR2(2000); --added by subba.
2212: BEGIN