DBA Data[Home] [Help]

APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on JMF_GTA_RULE_HEADERS_ALL

Line 122: l_sales_list_flag jmf_gta_rule_headers_all.Sales_List_Flag%TYPE;

118:
119: --get from option table,this four variable is the split codition
120: l_max_amount NUMBER;
121: l_max_line NUMBER;
122: l_sales_list_flag jmf_gta_rule_headers_all.Sales_List_Flag%TYPE;
123: l_split_flag jmf_gta_system_parameters.Trx_Line_Split_Flag%TYPE;
124:
125: l_GTA_TRX JMF_GTA_TRX_UTIL.trx_rec_type; -- trx get from input parameter
126: l_gta_trx_succesed JMF_GTA_TRX_UTIL.trx_rec_type; -- trx for insert into temp table for report

Line 231: JMF_GTA_RULE_HEADERS_All

227: sales_list_flag
228: INTO
229: l_sales_list_flag
230: FROM
231: JMF_GTA_RULE_HEADERS_All
232: WHERE org_id = p_org_id
233: AND rule_header_id = p_transfer_id;
234: EXCEPTION
235: -- no data found , raise a data error

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

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

Line 1700: JMF_GTA_RULE_HEADERS_All

1696: sales_list_flag
1697: INTO
1698: l_sales_list_flag
1699: FROM
1700: JMF_GTA_RULE_HEADERS_All
1701: WHERE org_id = p_org_id
1702: AND rule_header_id = p_transfer_id;
1703: EXCEPTION
1704: -- no data found , raise a data error