DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on DUAL

Line 3654: FROM dual;

3650:
3651: -- Check if the balancing segment value is valid for the ledger
3652: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)
3653: INTO l_account
3654: FROM dual;
3655:
3656: -- 4262811---------------------------------------------------------------------------------
3657: IF g_caller = C_CALLER_MPA_PROGRAM THEN
3658: g_message_name := 'XLA_MA_INVALID_BAL_SEG';

Line 3780: FROM dual;

3776:
3777: -- Check if the management segment value is valid for the ledger
3778: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)
3779: INTO l_account
3780: FROM dual;
3781:
3782: OPEN c_coa_structure_name(l_err.ccid_coa_id);
3783: FETCH c_coa_structure_name INTO l_coa_structure_name;
3784: CLOSE c_coa_structure_name;

Line 4408: FROM dual;

4404: WHERE error_flag = 'Y';
4405:
4406: CURSOR c_account(p_coa_id INTEGER, p_code_combination_id INTEGER) IS
4407: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', p_coa_id, p_code_combination_id)
4408: FROM dual;
4409:
4410: CURSOR c_je_source_name(l_lookup_code VARCHAR2) IS
4411: SELECT meaning
4412: FROM fnd_lookups

Line 6445: FROM dual;

6441: NVL(l_ref3,'N') <> 'N') THEN
6442:
6443: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_rounding_ccid)
6444: INTO l_account
6445: FROM dual;
6446:
6447: xla_accounting_err_pkg.build_message(
6448: p_appli_s_name => 'XLA'
6449: ,p_msg_name => 'XLA_AP_ROUNDING_CONT_ACCT'

Line 6761: FROM dual;

6757: ,p_accounting_batch_id => NULL);
6758: ELSIF (l_err.error_code = 'FUN_INTRA_CC_NOT_VALID') THEN
6759: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)
6760: INTO l_account
6761: FROM dual;
6762:
6763: xla_accounting_err_pkg.build_message(
6764: p_appli_s_name => 'XLA'
6765: ,p_msg_name => 'XLA_INTRA_CC_NOT_VALID'

Line 6787: FROM dual;

6783: ,p_accounting_batch_id => NULL);
6784: ELSIF (l_err.error_code = 'FUN_INTRA_CC_NOT_ACTIVE') THEN
6785: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)
6786: INTO l_account
6787: FROM dual;
6788:
6789: xla_accounting_err_pkg.build_message(
6790: p_appli_s_name => 'XLA'
6791: ,p_msg_name => 'XLA_INTRA_CC_NOT_ACTIVE'