DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on AR_SYSTEM_PARAMETERS

Line 403: ar_system_parameters sp

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

Line 1723: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,

1719: | p_subs_ccid IN Substitute ccid
1720: | p_actual_ccid OUT NOCOPY Actual or return ccid
1721: *==========================================================================*/
1722: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,
1723: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1724: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1725: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS
1726:
1727: l_concat_segs varchar2(240) ;

Line 1724: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,

1720: | p_actual_ccid OUT NOCOPY Actual or return ccid
1721: *==========================================================================*/
1722: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,
1723: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1724: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1725: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS
1726:
1727: l_concat_segs varchar2(240) ;
1728: l_concat_ids varchar2(2000) ;

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

1721: *==========================================================================*/
1722: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,
1723: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1724: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1725: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS
1726:
1727: l_concat_segs varchar2(240) ;
1728: l_concat_ids varchar2(2000) ;
1729: l_concat_descs varchar2(2000) ;

Line 1731: l_actual_gain_loss_ccid ar_system_parameters_all.code_combination_id_gain%TYPE ;

1727: l_concat_segs varchar2(240) ;
1728: l_concat_ids varchar2(2000) ;
1729: l_concat_descs varchar2(2000) ;
1730: l_arerror varchar2(2000) ;
1731: l_actual_gain_loss_ccid ar_system_parameters_all.code_combination_id_gain%TYPE ;
1732: flex_subs_ccid_error EXCEPTION;
1733:
1734: BEGIN
1735:

Line 2061: ar_system_parameters_all sp

2057: FROM DUAL
2058: WHERE EXISTS( SELECT closing_status
2059: FROM gl_period_statuses g,
2060: gl_sets_of_books b,
2061: ar_system_parameters_all sp
2062: WHERE b.set_of_books_id = g.set_of_books_id
2063: AND g.set_of_books_id = sp.set_of_books_id
2064: AND g.period_type = b.accounted_period_type
2065: AND g.application_id = 222

Line 2124: ar_system_parameters_all sp

2120: FROM DUAL
2121: WHERE EXISTS( SELECT closing_status
2122: FROM gl_period_statuses g,
2123: gl_sets_of_books b,
2124: ar_system_parameters_all sp
2125: WHERE b.set_of_books_id = g.set_of_books_id
2126: AND g.set_of_books_id = sp.set_of_books_id
2127: AND g.period_type = b.accounted_period_type
2128: AND g.application_id = 222