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_TB_BALANCE_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 123: l_last_updated_by := xla_environment_pkg.g_usr_id;

119: END IF;
120:
121:
122: l_last_update_date := sysdate;
123: l_last_updated_by := xla_environment_pkg.g_usr_id;
124: l_last_update_login := xla_environment_pkg.g_login_id;
125:
126:
127: --

Line 124: l_last_update_login := xla_environment_pkg.g_login_id;

120:
121:
122: l_last_update_date := sysdate;
123: l_last_updated_by := xla_environment_pkg.g_usr_id;
124: l_last_update_login := xla_environment_pkg.g_login_id;
125:
126:
127: --
128: -- UPDATE - p_process_mode = NULL

Line 854: l_created_by := xla_environment_pkg.g_usr_id;

850: END IF;
851:
852: l_creation_date := sysdate;
853: l_last_update_date := sysdate;
854: l_created_by := xla_environment_pkg.g_usr_id;
855: l_last_updated_by := xla_environment_pkg.g_usr_id;
856: l_last_update_login := xla_environment_pkg.g_login_id;
857:
858: xla_tb_definition_pvt.insert_row

Line 855: l_last_updated_by := xla_environment_pkg.g_usr_id;

851:
852: l_creation_date := sysdate;
853: l_last_update_date := sysdate;
854: l_created_by := xla_environment_pkg.g_usr_id;
855: l_last_updated_by := xla_environment_pkg.g_usr_id;
856: l_last_update_login := xla_environment_pkg.g_login_id;
857:
858: xla_tb_definition_pvt.insert_row
859: (p_rowid => l_rowid

Line 856: l_last_update_login := xla_environment_pkg.g_login_id;

852: l_creation_date := sysdate;
853: l_last_update_date := sysdate;
854: l_created_by := xla_environment_pkg.g_usr_id;
855: l_last_updated_by := xla_environment_pkg.g_usr_id;
856: l_last_update_login := xla_environment_pkg.g_login_id;
857:
858: xla_tb_definition_pvt.insert_row
859: (p_rowid => l_rowid
860: ,p_definition_code => p_definition_rec.definition_code

Line 930: l_created_by := xla_environment_pkg.g_usr_id;

926: END IF;
927:
928: l_creation_date := sysdate;
929: l_last_update_date := sysdate;
930: l_created_by := xla_environment_pkg.g_usr_id;
931: l_last_updated_by := xla_environment_pkg.g_usr_id;
932: l_last_update_login := xla_environment_pkg.g_login_id;
933:
934: INSERT INTO xla_tb_defn_je_sources

Line 931: l_last_updated_by := xla_environment_pkg.g_usr_id;

927:
928: l_creation_date := sysdate;
929: l_last_update_date := sysdate;
930: l_created_by := xla_environment_pkg.g_usr_id;
931: l_last_updated_by := xla_environment_pkg.g_usr_id;
932: l_last_update_login := xla_environment_pkg.g_login_id;
933:
934: INSERT INTO xla_tb_defn_je_sources
935: (definition_code

Line 932: l_last_update_login := xla_environment_pkg.g_login_id;

928: l_creation_date := sysdate;
929: l_last_update_date := sysdate;
930: l_created_by := xla_environment_pkg.g_usr_id;
931: l_last_updated_by := xla_environment_pkg.g_usr_id;
932: l_last_update_login := xla_environment_pkg.g_login_id;
933:
934: INSERT INTO xla_tb_defn_je_sources
935: (definition_code
936: ,je_source_name

Line 1014: l_created_by := xla_environment_pkg.g_usr_id;

1010: END IF;
1011:
1012: l_creation_date := sysdate;
1013: l_last_update_date := sysdate;
1014: l_created_by := xla_environment_pkg.g_usr_id;
1015: l_last_updated_by := xla_environment_pkg.g_usr_id;
1016: l_last_update_login := xla_environment_pkg.g_login_id;
1017:
1018: --

Line 1015: l_last_updated_by := xla_environment_pkg.g_usr_id;

1011:
1012: l_creation_date := sysdate;
1013: l_last_update_date := sysdate;
1014: l_created_by := xla_environment_pkg.g_usr_id;
1015: l_last_updated_by := xla_environment_pkg.g_usr_id;
1016: l_last_update_login := xla_environment_pkg.g_login_id;
1017:
1018: --
1019: -- As record elements (e.g. p_balance_tbl(i).balance_date) is not allowed

Line 1016: l_last_update_login := xla_environment_pkg.g_login_id;

1012: l_creation_date := sysdate;
1013: l_last_update_date := sysdate;
1014: l_created_by := xla_environment_pkg.g_usr_id;
1015: l_last_updated_by := xla_environment_pkg.g_usr_id;
1016: l_last_update_login := xla_environment_pkg.g_login_id;
1017:
1018: --
1019: -- As record elements (e.g. p_balance_tbl(i).balance_date) is not allowed
1020: -- in forall statements, reassgin parameters to local variables

Line 1116: l_created_by := xla_environment_pkg.g_usr_id;

1112: END IF;
1113:
1114: l_creation_date := sysdate;
1115: l_last_update_date := sysdate;
1116: l_created_by := xla_environment_pkg.g_usr_id;
1117: l_last_updated_by := xla_environment_pkg.g_usr_id;
1118: l_last_update_login := xla_environment_pkg.g_login_id;
1119:
1120: SELECT object_version_number

Line 1117: l_last_updated_by := xla_environment_pkg.g_usr_id;

1113:
1114: l_creation_date := sysdate;
1115: l_last_update_date := sysdate;
1116: l_created_by := xla_environment_pkg.g_usr_id;
1117: l_last_updated_by := xla_environment_pkg.g_usr_id;
1118: l_last_update_login := xla_environment_pkg.g_login_id;
1119:
1120: SELECT object_version_number
1121: ,NVL(p_definition_rec.ledger_id,ledger_id)

Line 1118: l_last_update_login := xla_environment_pkg.g_login_id;

1114: l_creation_date := sysdate;
1115: l_last_update_date := sysdate;
1116: l_created_by := xla_environment_pkg.g_usr_id;
1117: l_last_updated_by := xla_environment_pkg.g_usr_id;
1118: l_last_update_login := xla_environment_pkg.g_login_id;
1119:
1120: SELECT object_version_number
1121: ,NVL(p_definition_rec.ledger_id,ledger_id)
1122: ,enabled_flag

Line 1219: l_last_updated_by := xla_environment_pkg.g_usr_id;

1215: END IF;
1216:
1217:
1218: l_last_update_date := sysdate;
1219: l_last_updated_by := xla_environment_pkg.g_usr_id;
1220: l_last_update_login := xla_environment_pkg.g_login_id;
1221:
1222: SELECT COUNT(1)
1223: INTO l_db_cnt

Line 1220: l_last_update_login := xla_environment_pkg.g_login_id;

1216:
1217:
1218: l_last_update_date := sysdate;
1219: l_last_updated_by := xla_environment_pkg.g_usr_id;
1220: l_last_update_login := xla_environment_pkg.g_login_id;
1221:
1222: SELECT COUNT(1)
1223: INTO l_db_cnt
1224: FROM xla_subledgers xs

Line 1290: l_last_updated_by := xla_environment_pkg.g_usr_id;

1286:
1287: END IF;
1288:
1289: l_last_update_date := sysdate;
1290: l_last_updated_by := xla_environment_pkg.g_usr_id;
1291: l_last_update_login := xla_environment_pkg.g_login_id;
1292:
1293: MERGE INTO xla_tb_defn_details dt
1294: USING (SELECT code_combination_id

Line 1291: l_last_update_login := xla_environment_pkg.g_login_id;

1287: END IF;
1288:
1289: l_last_update_date := sysdate;
1290: l_last_updated_by := xla_environment_pkg.g_usr_id;
1291: l_last_update_login := xla_environment_pkg.g_login_id;
1292:
1293: MERGE INTO xla_tb_defn_details dt
1294: USING (SELECT code_combination_id
1295: ,balance_date

Line 1404: ,xla_environment_pkg.g_usr_id

1400: ,1
1401: ,5000
1402: ,1
1403: ,SYSDATE
1404: ,xla_environment_pkg.g_usr_id
1405: ,SYSDATE
1406: ,xla_environment_pkg.g_usr_id
1407: ,xla_environment_pkg.g_login_id
1408: );

Line 1406: ,xla_environment_pkg.g_usr_id

1402: ,1
1403: ,SYSDATE
1404: ,xla_environment_pkg.g_usr_id
1405: ,SYSDATE
1406: ,xla_environment_pkg.g_usr_id
1407: ,xla_environment_pkg.g_login_id
1408: );
1409: WHEN OTHERS THEN
1410: RAISE;

Line 1407: ,xla_environment_pkg.g_login_id

1403: ,SYSDATE
1404: ,xla_environment_pkg.g_usr_id
1405: ,SYSDATE
1406: ,xla_environment_pkg.g_usr_id
1407: ,xla_environment_pkg.g_login_id
1408: );
1409: WHEN OTHERS THEN
1410: RAISE;
1411:

Line 1689: xla_environment_pkg.refresh;

1685: END IF;
1686:
1687:
1688:
1689: xla_environment_pkg.refresh;
1690:
1691: g_mode := NVL(p_mode,'C_CREATE_MODE');
1692:
1693: l_definition_rec.definition_code := p_definition_code;

Line 1847: ,xla_environment_pkg.g_Usr_Id

1843: ,'###'
1844: ,'###'
1845: ,'###'
1846: ,SYSDATE
1847: ,xla_environment_pkg.g_Usr_Id
1848: ,SYSDATE
1849: ,xla_environment_pkg.g_Usr_Id
1850: ,xla_environment_pkg.g_Login_Id
1851: ,xla_environment_pkg.g_req_Id

Line 1849: ,xla_environment_pkg.g_Usr_Id

1845: ,'###'
1846: ,SYSDATE
1847: ,xla_environment_pkg.g_Usr_Id
1848: ,SYSDATE
1849: ,xla_environment_pkg.g_Usr_Id
1850: ,xla_environment_pkg.g_Login_Id
1851: ,xla_environment_pkg.g_req_Id
1852: ,xla_environment_pkg.g_Prog_Appl_Id
1853: ,xla_environment_pkg.g_Prog_Id

Line 1850: ,xla_environment_pkg.g_Login_Id

1846: ,SYSDATE
1847: ,xla_environment_pkg.g_Usr_Id
1848: ,SYSDATE
1849: ,xla_environment_pkg.g_Usr_Id
1850: ,xla_environment_pkg.g_Login_Id
1851: ,xla_environment_pkg.g_req_Id
1852: ,xla_environment_pkg.g_Prog_Appl_Id
1853: ,xla_environment_pkg.g_Prog_Id
1854: ,SYSDATE

Line 1851: ,xla_environment_pkg.g_req_Id

1847: ,xla_environment_pkg.g_Usr_Id
1848: ,SYSDATE
1849: ,xla_environment_pkg.g_Usr_Id
1850: ,xla_environment_pkg.g_Login_Id
1851: ,xla_environment_pkg.g_req_Id
1852: ,xla_environment_pkg.g_Prog_Appl_Id
1853: ,xla_environment_pkg.g_Prog_Id
1854: ,SYSDATE
1855: FROM xla_trial_balances xtb

Line 1852: ,xla_environment_pkg.g_Prog_Appl_Id

1848: ,SYSDATE
1849: ,xla_environment_pkg.g_Usr_Id
1850: ,xla_environment_pkg.g_Login_Id
1851: ,xla_environment_pkg.g_req_Id
1852: ,xla_environment_pkg.g_Prog_Appl_Id
1853: ,xla_environment_pkg.g_Prog_Id
1854: ,SYSDATE
1855: FROM xla_trial_balances xtb
1856: ,xla_tb_definitions_b xtd

Line 1853: ,xla_environment_pkg.g_Prog_Id

1849: ,xla_environment_pkg.g_Usr_Id
1850: ,xla_environment_pkg.g_Login_Id
1851: ,xla_environment_pkg.g_req_Id
1852: ,xla_environment_pkg.g_Prog_Appl_Id
1853: ,xla_environment_pkg.g_Prog_Id
1854: ,SYSDATE
1855: FROM xla_trial_balances xtb
1856: ,xla_tb_definitions_b xtd
1857: ,xla_event_class_attrs xeca

Line 1972: l_usr_id NUMBER := xla_environment_pkg.g_Usr_Id;

1968: l_schema VARCHAR2(30);
1969:
1970: l_count NUMBER;
1971:
1972: l_usr_id NUMBER := xla_environment_pkg.g_Usr_Id;
1973: l_login_id NUMBER := xla_environment_pkg.g_Login_Id;
1974: l_req_id NUMBER := xla_environment_pkg.g_req_Id;
1975: l_prog_appl_id NUMBER := xla_environment_pkg.g_Prog_Appl_Id;
1976: l_prog_id NUMBER := xla_environment_pkg.g_Prog_Id;

Line 1973: l_login_id NUMBER := xla_environment_pkg.g_Login_Id;

1969:
1970: l_count NUMBER;
1971:
1972: l_usr_id NUMBER := xla_environment_pkg.g_Usr_Id;
1973: l_login_id NUMBER := xla_environment_pkg.g_Login_Id;
1974: l_req_id NUMBER := xla_environment_pkg.g_req_Id;
1975: l_prog_appl_id NUMBER := xla_environment_pkg.g_Prog_Appl_Id;
1976: l_prog_id NUMBER := xla_environment_pkg.g_Prog_Id;
1977:

Line 1974: l_req_id NUMBER := xla_environment_pkg.g_req_Id;

1970: l_count NUMBER;
1971:
1972: l_usr_id NUMBER := xla_environment_pkg.g_Usr_Id;
1973: l_login_id NUMBER := xla_environment_pkg.g_Login_Id;
1974: l_req_id NUMBER := xla_environment_pkg.g_req_Id;
1975: l_prog_appl_id NUMBER := xla_environment_pkg.g_Prog_Appl_Id;
1976: l_prog_id NUMBER := xla_environment_pkg.g_Prog_Id;
1977:
1978: BEGIN

Line 1975: l_prog_appl_id NUMBER := xla_environment_pkg.g_Prog_Appl_Id;

1971:
1972: l_usr_id NUMBER := xla_environment_pkg.g_Usr_Id;
1973: l_login_id NUMBER := xla_environment_pkg.g_Login_Id;
1974: l_req_id NUMBER := xla_environment_pkg.g_req_Id;
1975: l_prog_appl_id NUMBER := xla_environment_pkg.g_Prog_Appl_Id;
1976: l_prog_id NUMBER := xla_environment_pkg.g_Prog_Id;
1977:
1978: BEGIN
1979: IF g_log_enabled THEN

Line 1976: l_prog_id NUMBER := xla_environment_pkg.g_Prog_Id;

1972: l_usr_id NUMBER := xla_environment_pkg.g_Usr_Id;
1973: l_login_id NUMBER := xla_environment_pkg.g_Login_Id;
1974: l_req_id NUMBER := xla_environment_pkg.g_req_Id;
1975: l_prog_appl_id NUMBER := xla_environment_pkg.g_Prog_Appl_Id;
1976: l_prog_id NUMBER := xla_environment_pkg.g_Prog_Id;
1977:
1978: BEGIN
1979: IF g_log_enabled THEN
1980: l_log_module := C_DEFAULT_MODULE||'.create_ap_balances';

Line 2391: ,xla_environment_pkg.g_Usr_Id

2387: ,p_balance_side_code
2388: ,'FLEXFIELD'
2389: ,'NEW'
2390: ,sysdate
2391: ,xla_environment_pkg.g_Usr_Id
2392: ,sysdate
2393: ,xla_environment_pkg.g_Usr_Id
2394: ,xla_environment_pkg.g_login_Id
2395: ,xla_environment_pkg.g_Prog_Appl_Id

Line 2393: ,xla_environment_pkg.g_Usr_Id

2389: ,'NEW'
2390: ,sysdate
2391: ,xla_environment_pkg.g_Usr_Id
2392: ,sysdate
2393: ,xla_environment_pkg.g_Usr_Id
2394: ,xla_environment_pkg.g_login_Id
2395: ,xla_environment_pkg.g_Prog_Appl_Id
2396: ,xla_environment_pkg.g_Usr_Id
2397: ,sysdate

Line 2394: ,xla_environment_pkg.g_login_Id

2390: ,sysdate
2391: ,xla_environment_pkg.g_Usr_Id
2392: ,sysdate
2393: ,xla_environment_pkg.g_Usr_Id
2394: ,xla_environment_pkg.g_login_Id
2395: ,xla_environment_pkg.g_Prog_Appl_Id
2396: ,xla_environment_pkg.g_Usr_Id
2397: ,sysdate
2398: ,'S');

Line 2395: ,xla_environment_pkg.g_Prog_Appl_Id

2391: ,xla_environment_pkg.g_Usr_Id
2392: ,sysdate
2393: ,xla_environment_pkg.g_Usr_Id
2394: ,xla_environment_pkg.g_login_Id
2395: ,xla_environment_pkg.g_Prog_Appl_Id
2396: ,xla_environment_pkg.g_Usr_Id
2397: ,sysdate
2398: ,'S');
2399:

Line 2396: ,xla_environment_pkg.g_Usr_Id

2392: ,sysdate
2393: ,xla_environment_pkg.g_Usr_Id
2394: ,xla_environment_pkg.g_login_Id
2395: ,xla_environment_pkg.g_Prog_Appl_Id
2396: ,xla_environment_pkg.g_Usr_Id
2397: ,sysdate
2398: ,'S');
2399:
2400: IF (C_LEVEL_STATEMENT>= g_log_level) THEN

Line 2422: ,xla_environment_pkg.g_Usr_Id

2418: VALUES (l_array_defn_code(i)
2419: ,p_je_source_name
2420: ,1
2421: ,sysdate
2422: ,xla_environment_pkg.g_Usr_Id
2423: ,sysdate
2424: ,xla_environment_pkg.g_Usr_Id
2425: ,xla_environment_pkg.g_login_Id
2426: ,'S');

Line 2424: ,xla_environment_pkg.g_Usr_Id

2420: ,1
2421: ,sysdate
2422: ,xla_environment_pkg.g_Usr_Id
2423: ,sysdate
2424: ,xla_environment_pkg.g_Usr_Id
2425: ,xla_environment_pkg.g_login_Id
2426: ,'S');
2427:
2428: IF (C_LEVEL_STATEMENT>= g_log_level) THEN

Line 2425: ,xla_environment_pkg.g_login_Id

2421: ,sysdate
2422: ,xla_environment_pkg.g_Usr_Id
2423: ,sysdate
2424: ,xla_environment_pkg.g_Usr_Id
2425: ,xla_environment_pkg.g_login_Id
2426: ,'S');
2427:
2428: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2429: trace

Line 2452: ,xla_environment_pkg.g_usr_id

2448: ,1
2449: ,5000
2450: ,1
2451: ,SYSDATE
2452: ,xla_environment_pkg.g_usr_id
2453: ,SYSDATE
2454: ,xla_environment_pkg.g_usr_id
2455: ,xla_environment_pkg.g_login_id
2456: FROM xla_tb_balances_gt xtb

Line 2454: ,xla_environment_pkg.g_usr_id

2450: ,1
2451: ,SYSDATE
2452: ,xla_environment_pkg.g_usr_id
2453: ,SYSDATE
2454: ,xla_environment_pkg.g_usr_id
2455: ,xla_environment_pkg.g_login_id
2456: FROM xla_tb_balances_gt xtb
2457: WHERE NOT EXISTS
2458: (SELECT 1

Line 2455: ,xla_environment_pkg.g_login_id

2451: ,SYSDATE
2452: ,xla_environment_pkg.g_usr_id
2453: ,SYSDATE
2454: ,xla_environment_pkg.g_usr_id
2455: ,xla_environment_pkg.g_login_id
2456: FROM xla_tb_balances_gt xtb
2457: WHERE NOT EXISTS
2458: (SELECT 1
2459: FROM XLA_GL_LEDGERS

Line 2487: ,xla_environment_pkg.g_Usr_Id

2483: SELECT DISTINCT
2484: definition_code
2485: ,definition_name
2486: ,definition_desc
2487: ,xla_environment_pkg.g_Usr_Id
2488: ,sysdate
2489: ,xla_environment_pkg.g_Usr_Id
2490: ,sysdate
2491: ,xla_environment_pkg.g_login_Id

Line 2489: ,xla_environment_pkg.g_Usr_Id

2485: ,definition_name
2486: ,definition_desc
2487: ,xla_environment_pkg.g_Usr_Id
2488: ,sysdate
2489: ,xla_environment_pkg.g_Usr_Id
2490: ,sysdate
2491: ,xla_environment_pkg.g_login_Id
2492: ,l.language_code
2493: ,userenv('LANG')

Line 2491: ,xla_environment_pkg.g_login_Id

2487: ,xla_environment_pkg.g_Usr_Id
2488: ,sysdate
2489: ,xla_environment_pkg.g_Usr_Id
2490: ,sysdate
2491: ,xla_environment_pkg.g_login_Id
2492: ,l.language_code
2493: ,userenv('LANG')
2494: FROM fnd_languages l
2495: ,xla_tb_balances_gt tb

Line 2541: ,xla_environment_pkg.g_Usr_Id

2537: ,owner_code
2538: ,NULL -- balance_date
2539: ,NULL -- balance_amount
2540: ,sysdate
2541: ,xla_environment_pkg.g_Usr_Id
2542: ,sysdate
2543: ,xla_environment_pkg.g_Usr_Id
2544: ,xla_environment_pkg.g_login_Id)
2545: INTO xla_tb_def_seg_ranges

Line 2543: ,xla_environment_pkg.g_Usr_Id

2539: ,NULL -- balance_amount
2540: ,sysdate
2541: ,xla_environment_pkg.g_Usr_Id
2542: ,sysdate
2543: ,xla_environment_pkg.g_Usr_Id
2544: ,xla_environment_pkg.g_login_Id)
2545: INTO xla_tb_def_seg_ranges
2546: (definition_code
2547: ,line_num

Line 2544: ,xla_environment_pkg.g_login_Id)

2540: ,sysdate
2541: ,xla_environment_pkg.g_Usr_Id
2542: ,sysdate
2543: ,xla_environment_pkg.g_Usr_Id
2544: ,xla_environment_pkg.g_login_Id)
2545: INTO xla_tb_def_seg_ranges
2546: (definition_code
2547: ,line_num
2548: ,balance_date

Line 2826: xla_environment_pkg.refresh;

2822: ,p_level => C_LEVEL_PROCEDURE
2823: ,p_module => l_log_module);
2824: END IF;
2825:
2826: xla_environment_pkg.refresh;
2827:
2828: IF NOT validate_je_source
2829: (p_je_source_name => p_je_source_name)
2830: THEN