DBA Data[Home] [Help]

APPS.FUN_BAL_UTILS_GRP dependencies on FUN_BAL_PKG

Line 20: SELECT fun_bal_pkg.get_segment_index(ledgers.chart_of_accounts_id,

16:
17: CURSOR c_get_seg_num(p_ledger_id NUMBER,
18: p_segment_type VARCHAR2)
19: IS
20: SELECT fun_bal_pkg.get_segment_index(ledgers.chart_of_accounts_id,
21: p_segment_type),
22: ledgers.chart_of_accounts_id
23: FROM gl_ledgers ledgers
24: WHERE ledgers.ledger_id = p_ledger_id;

Line 241: 'fun.plsql.fun_bal_pkg.get_inter_intra_account.error',

237: THEN
238: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
239: THEN
240: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
241: 'fun.plsql.fun_bal_pkg.get_inter_intra_account.error',
242: SUBSTR(SQLERRM,1, 4000));
243: END IF;
244:
245: x_status := FND_API.G_RET_STS_ERROR ;

Line 557: x_ccid := fun_bal_pkg.get_ccid (

553: -- Call the procedure to generate the new account
554: -- For eg if from the setup table we get back account 99-00-4350-00-99
555: -- and if the from bsv is 01 and to bsv is 02, this api should return ccid
556: -- for account 01-00-4350-00-02
557: x_ccid := fun_bal_pkg.get_ccid (
558: ccid => l_setup_ccid,
559: chart_of_accounts_id => l_coa,
560: bal_seg_val => p_from_bsv,
561: intercompany_seg_val => p_to_bsv,

Line 631: x_reciprocal_ccid := fun_bal_pkg.get_ccid (

627: -- Call the procedure to generate the new account
628: -- For eg if from the setup table we get back account 99-00-5670-00-99
629: -- and if the from bsv is 01 and to bsv is 02, this api should return ccid
630: -- for account 02-00-5670-00-01
631: x_reciprocal_ccid := fun_bal_pkg.get_ccid (
632: ccid => l_setup_recp_ccid,
633: chart_of_accounts_id => l_recp_coa,
634: bal_seg_val => p_to_bsv,
635: intercompany_seg_val => p_from_bsv,

Line 726: 'fun.plsql.fun_bal_pkg.get_intercompany_account.error',

722: THEN
723: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
724: THEN
725: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
726: 'fun.plsql.fun_bal_pkg.get_intercompany_account.error',
727: SUBSTR(SQLERRM,1, 4000));
728: END IF;
729:
730: x_status := FND_API.G_RET_STS_ERROR ;

Line 1061: x_ccid := fun_bal_pkg.get_ccid (

1057: -- Call the procedure to generate the new account
1058: -- For eg if from the setup table we get back account 99-00-4350-00-99
1059: -- and if the dr bsv is 01 and cr bsv is 02, this api should return ccid
1060: -- for account 01-00-4350-00-02
1061: x_ccid := fun_bal_pkg.get_ccid (
1062: ccid => l_setup_ccid,
1063: chart_of_accounts_id => l_coa,
1064: bal_seg_val => p_dr_bsv,
1065: intercompany_seg_val => p_cr_bsv,

Line 1081: x_reciprocal_ccid := fun_bal_pkg.get_ccid (

1077: -- Call the procedure to generate the new account
1078: -- For eg if from the setup table we get back account 99-00-5670-00-99
1079: -- and if the dr bsv is 01 and cr bsv is 02, this api should return ccid
1080: -- for account 02-00-5670-00-01
1081: x_reciprocal_ccid := fun_bal_pkg.get_ccid (
1082: ccid => l_setup_recp_ccid,
1083: chart_of_accounts_id => l_coa,
1084: bal_seg_val => p_cr_bsv,
1085: intercompany_seg_val => p_dr_bsv,

Line 1113: 'fun.plsql.fun_bal_pkg.Get_Intracompany_Account.error',

1109: THEN
1110: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1111: THEN
1112: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1113: 'fun.plsql.fun_bal_pkg.Get_Intracompany_Account.error',
1114: SUBSTR(SQLERRM,1, 4000));
1115: END IF;
1116:
1117: x_status := FND_API.G_RET_STS_ERROR ;