eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_JE_VALIDATION_PKG dependencies on FND_FLEX_EXT

Line 3652: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)

3648: g_err_hdr_ids(g_err_count) := l_err.ae_header_id;
3649: g_err_event_ids(g_err_count) := l_err.event_id;
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---------------------------------------------------------------------------------

Line 3778: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)

3774: g_err_hdr_ids(g_err_count) := l_err.ae_header_id;
3775: g_err_event_ids(g_err_count) := l_err.event_id;
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);

Line 4189: ,fnd_flex_ext.get_segs('SQLGL', 'GL#', t.ccid_coa_id, t.code_combination_id) account

4185: ,t.event_id
4186: ,t.displayed_line_number
4187: ,t.entity_id
4188: ,bud.budget_name
4189: ,fnd_flex_ext.get_segs('SQLGL', 'GL#', t.ccid_coa_id, t.code_combination_id) account
4190: FROM xla_validation_lines_gt t
4191: JOIN gl_budget_versions bud
4192: ON bud.budget_version_id = t.budget_version_id
4193: LEFT OUTER JOIN gl_budget_assignments b

Line 4407: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', p_coa_id, p_code_combination_id)

4403: FROM xla_validation_lines_gt
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

Line 5432: l_seg FND_FLEX_EXT.SegmentArray;

5428: l_mgt_seg_val VARCHAR2(30);
5429: l_ref3 VARCHAR2(30);
5430: l_seg_number NUMBER;
5431: l_sus_ccid INTEGER;
5432: l_seg FND_FLEX_EXT.SegmentArray;
5433: l_seg2 FND_FLEX_EXT.SegmentArray;
5434: l_coa_id INTEGER;
5435: l_num_segs INTEGER;
5436: l_result INTEGER := 0;

Line 5433: l_seg2 FND_FLEX_EXT.SegmentArray;

5429: l_ref3 VARCHAR2(30);
5430: l_seg_number NUMBER;
5431: l_sus_ccid INTEGER;
5432: l_seg FND_FLEX_EXT.SegmentArray;
5433: l_seg2 FND_FLEX_EXT.SegmentArray;
5434: l_coa_id INTEGER;
5435: l_num_segs INTEGER;
5436: l_result INTEGER := 0;
5437: l_stmt VARCHAR2(4000);

Line 5512: IF (FND_FLEX_EXT.get_segments(

5508: END;
5509:
5510: IF (l_sus_ccid IS NULL) THEN
5511:
5512: IF (FND_FLEX_EXT.get_segments(
5513: application_short_name => 'SQLGL',
5514: key_flex_code => 'GL#',
5515: structure_number => g_ledger_coa_id,
5516: combination_id => g_sla_ledger_cur_bal_sus_ccid,

Line 5549: IF (FND_FLEX_EXT.get_combination_id(

5545: FETCH c_seg_number INTO l_seg_number;
5546: CLOSE c_seg_number;
5547:
5548: l_seg(l_seg_number) := l_bal.bal_seg_val;
5549: IF (FND_FLEX_EXT.get_combination_id(
5550: application_short_name => 'SQLGL',
5551: key_flex_code => 'GL#',
5552: structure_number => g_ledger_coa_id,
5553: validation_date => l_bal.accounting_date,

Line 6146: l_seg FND_FLEX_EXT.SegmentArray;

6142: l_bal c_bal%ROWTYPE;
6143: l_ref3 VARCHAR2(30);
6144: l_mgt_seg_val VARCHAR2(30);
6145: l_seg_number NUMBER;
6146: l_seg FND_FLEX_EXT.SegmentArray;
6147: l_seg2 FND_FLEX_EXT.SegmentArray;
6148: l_num_segs INTEGER;
6149: l_coa_id INTEGER;
6150: l_stmt VARCHAR2(4000);

Line 6147: l_seg2 FND_FLEX_EXT.SegmentArray;

6143: l_ref3 VARCHAR2(30);
6144: l_mgt_seg_val VARCHAR2(30);
6145: l_seg_number NUMBER;
6146: l_seg FND_FLEX_EXT.SegmentArray;
6147: l_seg2 FND_FLEX_EXT.SegmentArray;
6148: l_num_segs INTEGER;
6149: l_coa_id INTEGER;
6150: l_stmt VARCHAR2(4000);
6151: l_entered_cr NUMBER;

Line 6274: IF (FND_FLEX_EXT.get_segments(

6270: END IF;
6271:
6272: IF (l_rounding_ccid IS NULL) THEN
6273:
6274: IF (FND_FLEX_EXT.get_segments(
6275: application_short_name => 'SQLGL',
6276: key_flex_code => 'GL#',
6277: structure_number => g_ledger_coa_id,
6278: combination_id => g_sla_rounding_ccid,

Line 6312: IF (FND_FLEX_EXT.get_combination_id(

6308: FETCH c_seg_number INTO l_seg_number;
6309: CLOSE c_seg_number;
6310:
6311: l_seg(l_seg_number) := l_bal.bal_seg_val;
6312: IF (FND_FLEX_EXT.get_combination_id(
6313: application_short_name => 'SQLGL',
6314: key_flex_code => 'GL#',
6315: structure_number => g_ledger_coa_id,
6316: validation_date => l_bal.accounting_date,

Line 6443: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_rounding_ccid)

6439:
6440: IF (NVL(l_rounding_ccid,-1) > 0 AND
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(

Line 6759: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)

6755: ,p_ae_header_id => l_err.ae_header_id
6756: ,p_ae_line_num => NULL
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(

Line 6785: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)

6781: ,p_ae_header_id => l_err.ae_header_id
6782: ,p_ae_line_num => NULL
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(

Line 7446: l_seg FND_FLEX_EXT.SegmentArray;

7442: PROCEDURE populate_missing_ccid
7443: (p_err_count IN OUT NOCOPY INTEGER
7444: ,p_err_hdr_ids IN OUT NOCOPY t_array_int)
7445: IS
7446: l_seg FND_FLEX_EXT.SegmentArray;
7447: l_result INTEGER;
7448: l_ccids t_array_int;
7449: l_reference3s t_array_varchar30;
7450: l_num_segments INTEGER;

Line 7541: IF ( FND_FLEX_EXT.get_segments(

7537: p_module => l_log_module,
7538: p_level => C_LEVEL_EVENT);
7539: END IF;
7540:
7541: IF ( FND_FLEX_EXT.get_segments(
7542: application_short_name => 'SQLGL',
7543: key_flex_code => 'GL#',
7544: structure_number => g_ledger_coa_id,
7545: combination_id => CASE l_ccid.balance_type_code -- 4458381

Line 7551: trace(p_msg => 'FND_FLEX_EXT.get_segments failed',

7547: ELSE g_sla_entered_cur_bal_sus_ccid END,
7548: n_segments => l_num_segments,
7549: segments => l_seg) = FALSE) THEN
7550: IF (C_LEVEL_ERROR >= g_log_level) THEN
7551: trace(p_msg => 'FND_FLEX_EXT.get_segments failed',
7552: p_module => l_log_module,
7553: p_level => C_LEVEL_ERROR);
7554: END IF;
7555:

Line 7565: IF (FND_FLEX_EXT.get_combination_id(

7561: FETCH c_seg_number INTO l_bal_seg_number;
7562: CLOSE c_seg_number;
7563:
7564: l_seg(l_bal_seg_number) := l_ccid.bal_seg_value;
7565: IF (FND_FLEX_EXT.get_combination_id(
7566: application_short_name => 'SQLGL',
7567: key_flex_code => 'GL#',
7568: structure_number => g_ledger_coa_id,
7569: validation_date => l_ccid.accounting_date,