DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on AR_SYSTEM_PARAMETERS

Line 406: ar_system_parameters sp

402: INTO l_mau,
403: l_precision
404: FROM fnd_currencies c,
405: gl_sets_of_books sob,
406: ar_system_parameters sp
407: WHERE sob.set_of_books_id = sp.set_of_books_id
408: AND c.currency_code = sob.currency_code;
409: END IF;
410: END IF;

Line 1782: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,

1778: | p_subs_ccid IN Substitute ccid
1779: | p_actual_ccid OUT NOCOPY Actual or return ccid
1780: *==========================================================================*/
1781: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,
1782: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1783: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1784: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS
1785:
1786: l_concat_segs varchar2(240) ;

Line 1783: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,

1779: | p_actual_ccid OUT NOCOPY Actual or return ccid
1780: *==========================================================================*/
1781: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,
1782: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1783: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1784: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS
1785:
1786: l_concat_segs varchar2(240) ;
1787: l_concat_ids varchar2(2000) ;

Line 1784: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS

1780: *==========================================================================*/
1781: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,
1782: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1783: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1784: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS
1785:
1786: l_concat_segs varchar2(240) ;
1787: l_concat_ids varchar2(2000) ;
1788: l_concat_descs varchar2(2000) ;

Line 1790: l_actual_gain_loss_ccid ar_system_parameters_all.code_combination_id_gain%TYPE ;

1786: l_concat_segs varchar2(240) ;
1787: l_concat_ids varchar2(2000) ;
1788: l_concat_descs varchar2(2000) ;
1789: l_arerror varchar2(2000) ;
1790: l_actual_gain_loss_ccid ar_system_parameters_all.code_combination_id_gain%TYPE ;
1791: flex_subs_ccid_error EXCEPTION;
1792:
1793: BEGIN
1794:

Line 2120: ar_system_parameters_all sp

2116: FROM DUAL
2117: WHERE EXISTS( SELECT closing_status
2118: FROM gl_period_statuses g,
2119: gl_sets_of_books b,
2120: ar_system_parameters_all sp
2121: WHERE b.set_of_books_id = g.set_of_books_id
2122: AND g.set_of_books_id = sp.set_of_books_id
2123: AND g.period_type = b.accounted_period_type
2124: AND g.application_id = 222

Line 2183: ar_system_parameters_all sp

2179: FROM DUAL
2180: WHERE EXISTS( SELECT closing_status
2181: FROM gl_period_statuses g,
2182: gl_sets_of_books b,
2183: ar_system_parameters_all sp
2184: WHERE b.set_of_books_id = g.set_of_books_id
2185: AND g.set_of_books_id = sp.set_of_books_id
2186: AND g.period_type = b.accounted_period_type
2187: AND g.application_id = 222

Line 2232: from ar_system_parameters;

2228: END IF;
2229: begin
2230: select NVL(automatch_enabled_flag,'F')
2231: into l_automatch_enabled_flag
2232: from ar_system_parameters;
2233: exception
2234: when others then
2235: l_automatch_enabled_flag := 'F';
2236: end;