DBA Data[Home] [Help]

APPS.AR_GTA_SPLIT_TRX_PROC dependencies on AR_GTA_RULE_HEADERS_ALL

Line 159: l_sales_list_flag ar_gta_rule_headers_all.Sales_List_Flag%TYPE;

155:
156: --get from option table,this four variable is the split codition
157: l_max_amount NUMBER;
158: l_max_line NUMBER;
159: l_sales_list_flag ar_gta_rule_headers_all.Sales_List_Flag%TYPE;
160: l_split_flag ar_gta_system_parameters.Trx_Line_Split_Flag%TYPE;
161:
162: l_GTA_TRX AR_GTA_TRX_UTIL.trx_rec_type; -- trx get from input parameter
163: l_gta_trx_succesed AR_GTA_TRX_UTIL.trx_rec_type; -- trx for insert into temp table for report

Line 273: AR_GTA_RULE_HEADERS_All

269: sales_list_flag
270: INTO
271: l_sales_list_flag
272: FROM
273: AR_GTA_RULE_HEADERS_All
274: WHERE org_id = p_org_id
275: AND rule_header_id = p_transfer_id;
276: EXCEPTION
277: -- no data found , raise a data error

Line 2050: l_sales_list_flag ar_gta_rule_headers_all.Sales_List_Flag%TYPE;--added by Yao Zhang for bug 7758496

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
2054: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

Line 2110: AR_GTA_RULE_HEADERS_All

2106: sales_list_flag
2107: INTO
2108: l_sales_list_flag
2109: FROM
2110: AR_GTA_RULE_HEADERS_All
2111: WHERE org_id = p_org_id
2112: AND rule_header_id = p_transfer_id;
2113: EXCEPTION
2114: -- no data found , raise a data error