APPS.AR_GTA_ARTRX_PROC dependencies on AR_GTA_RULE_HEADERS_ALL

Line 413: l_transfer_rule ar_gta_rule_headers_all.rule_name%TYPE;

409:
410: l_length NUMBER;
411:
412: l_operation_unit hr_operating_units.name%TYPE;
413: l_transfer_rule ar_gta_rule_headers_all.rule_name%TYPE;
414: l_final_output CLOB;
415: -- parameters
416: l_customer_num_from VARCHAR2(30) := nvl(p_conc_parameters.CUSTOMER_NUM_FROM,
417: ' ');

Line 493: FROM ar_gta_rule_headers_all rule

489: --get rult name by rule id
490: BEGIN
491: SELECT rule.rule_name
492: INTO l_transfer_rule
493: FROM ar_gta_rule_headers_all rule
494: WHERE rule.rule_header_id = p_transfer_id;
495: EXCEPTION
496: WHEN no_data_found THEN
497:

Line 1162: FROM ar_gta_rule_headers_all jgrha

1158: -- BEGIN
1159:
1160: SELECT jgrha.invoice_type
1161: INTO l_invoice_type_code
1162: FROM ar_gta_rule_headers_all jgrha
1163: WHERE jgrha.rule_header_id = p_transfer_id;
1164:
1165: /* EXCEPTION
1166: -- no data found , raise a data error

Line 1806: l_specific_currency_code ar_gta_rule_headers_all.specific_currency_code%TYPE;

1802:
1803: l_parameter_token VARCHAR2(10) := ':currency';
1804: l_ar_currency_code ra_customer_trx_all.Invoice_Currency_Code%TYPE;
1805:
1806: l_specific_currency_code ar_gta_rule_headers_all.specific_currency_code%TYPE;
1807: l_gta_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
1808:
1809: -- if currency_option = A then the rule is transfer all AR trx
1810: -- if currency_option = G

Line 1816: l_gta_currency_option ar_gta_rule_headers_all.currency_option%TYPE;

1812: -- if currency_option = O
1813: -- then the rule is transfer AR trx which currency code is not same as gta
1814: -- if currency_option = S
1815: -- then the rule is transfer AR trx which currency code is specific.
1816: l_gta_currency_option ar_gta_rule_headers_all.currency_option%TYPE;
1817: BEGIN
1818:
1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1820: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

Line 1839: FROM ar_gta_rule_headers_all rule

1835: --select currency option and specific currency code.
1836: BEGIN
1837: SELECT rule.currency_option, rule.specific_currency_code
1838: INTO l_gta_currency_option, l_specific_currency_code
1839: FROM ar_gta_rule_headers_all rule
1840: WHERE rule.rule_header_id = p_transfer_id;
1841: EXCEPTION
1842: -- no data found , raise a data error
1843: WHEN no_data_found THEN

Line 2298: FROM ar_gta_rule_headers_all

2294: -- select sales_list_flag from rule_table
2295: BEGIN
2296: SELECT sales_list_flag
2297: INTO l_sales_list_flag
2298: FROM ar_gta_rule_headers_all
2299: WHERE ar_gta_rule_headers_all.rule_header_id = p_transfer_id;
2300: EXCEPTION
2301: -- no data found , raise a data error
2302: WHEN no_data_found THEN

Line 2299: WHERE ar_gta_rule_headers_all.rule_header_id = p_transfer_id;

2295: BEGIN
2296: SELECT sales_list_flag
2297: INTO l_sales_list_flag
2298: FROM ar_gta_rule_headers_all
2299: WHERE ar_gta_rule_headers_all.rule_header_id = p_transfer_id;
2300: EXCEPTION
2301: -- no data found , raise a data error
2302: WHEN no_data_found THEN
2303: fnd_message.SET_NAME('AR', 'AR_GTA_SYS_CONFIG_MISSING');

Line 3186: FROM ar_gta_rule_headers_all jgrha

3182:
3183: /* get the invoice type code defined in transfer rule. */
3184: SELECT jgrha.invoice_type
3185: INTO l_invoice_type_code
3186: FROM ar_gta_rule_headers_all jgrha
3187: WHERE jgrha.rule_header_id = p_transfer_id;
3188:
3189: /* check if the rule invoice type code matches the AR invoice type code. No match, no proceed. */
3190: IF l_invoice_type_code IS NOT NULL THEN