APPS.JMF_GTA_ARTRX_PROC dependencies on JMF_GTA_RULE_HEADERS_ALL

Line 385: l_transfer_rule jmf_gta_rule_headers_all.rule_name%TYPE;

381:
382: l_length NUMBER;
383:
384: l_operation_unit hr_operating_units.name%TYPE;
385: l_transfer_rule jmf_gta_rule_headers_all.rule_name%TYPE;
386: l_final_output CLOB;
387: -- parameters
388: l_customer_num_from VARCHAR2(30) := nvl(p_conc_parameters.CUSTOMER_NUM_FROM,
389: ' ');

Line 465: FROM jmf_gta_rule_headers_all rule

461: --get rult name by rule id
462: BEGIN
463: SELECT rule.rule_name
464: INTO l_transfer_rule
465: FROM jmf_gta_rule_headers_all rule
466: WHERE rule.rule_header_id = p_transfer_id;
467: EXCEPTION
468: WHEN no_data_found THEN
469:

Line 1125: FROM jmf_gta_rule_headers_all jgrha

1121: -- BEGIN
1122:
1123: SELECT jgrha.invoice_type
1124: INTO l_invoice_type_code
1125: FROM jmf_gta_rule_headers_all jgrha
1126: WHERE jgrha.rule_header_id = p_transfer_id;
1127:
1128: /* EXCEPTION
1129: -- no data found , raise a data error

Line 1770: l_specific_currency_code jmf_gta_rule_headers_all.specific_currency_code%TYPE;

1766:
1767: l_parameter_token VARCHAR2(10) := ':currency';
1768: l_ar_currency_code ra_customer_trx_all.Invoice_Currency_Code%TYPE;
1769:
1770: l_specific_currency_code jmf_gta_rule_headers_all.specific_currency_code%TYPE;
1771: l_gta_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1772:
1773: -- if currency_option = A then the rule is transfer all AR trx
1774: -- if currency_option = G

Line 1780: l_gta_currency_option jmf_gta_rule_headers_all.currency_option%TYPE;

1776: -- if currency_option = O
1777: -- then the rule is transfer AR trx which currency code is not same as gta
1778: -- if currency_option = S
1779: -- then the rule is transfer AR trx which currency code is specific.
1780: l_gta_currency_option jmf_gta_rule_headers_all.currency_option%TYPE;
1781: BEGIN
1782:
1783: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1784: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

Line 1803: FROM jmf_gta_rule_headers_all rule

1799: --select currency option and specific currency code.
1800: BEGIN
1801: SELECT rule.currency_option, rule.specific_currency_code
1802: INTO l_gta_currency_option, l_specific_currency_code
1803: FROM jmf_gta_rule_headers_all rule
1804: WHERE rule.rule_header_id = p_transfer_id;
1805: EXCEPTION
1806: -- no data found , raise a data error
1807: WHEN no_data_found THEN

Line 2202: FROM jmf_gta_rule_headers_all

2198: -- select sales_list_flag from rule_table
2199: BEGIN
2200: SELECT sales_list_flag
2201: INTO l_sales_list_flag
2202: FROM jmf_gta_rule_headers_all
2203: WHERE jmf_gta_rule_headers_all.rule_header_id = p_transfer_id;
2204: EXCEPTION
2205: -- no data found , raise a data error
2206: WHEN no_data_found THEN

Line 2203: WHERE jmf_gta_rule_headers_all.rule_header_id = p_transfer_id;

2199: BEGIN
2200: SELECT sales_list_flag
2201: INTO l_sales_list_flag
2202: FROM jmf_gta_rule_headers_all
2203: WHERE jmf_gta_rule_headers_all.rule_header_id = p_transfer_id;
2204: EXCEPTION
2205: -- no data found , raise a data error
2206: WHEN no_data_found THEN
2207: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');