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.FEM_INTG_BAL_ENG_LOAD_PKG dependencies on FEM_INTG_EXEC_PARAMS_GT

Line 397: ' FEM_INTG_EXEC_PARAMS_GT param,' || pv_nl ||

393: ' nvl(glb.period_net_cr,0),' || pv_nl ||
394: ' nvl(glb.begin_balance_dr,0) + nvl(glb.period_net_dr,0),' || pv_nl ||
395: ' nvl(glb.begin_balance_cr,0) + nvl(glb.period_net_cr,0)' || pv_nl ||
396: 'FROM' || pv_nl ||
397: ' FEM_INTG_EXEC_PARAMS_GT param,' || pv_nl ||
398: ' GL_BALANCES glb,' || pv_nl;
399:
400: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
401: v_sql := v_sql ||

Line 530: 'FROM FEM_INTG_EXEC_PARAMS_GT param_in,' || pv_nl ||

526: ' ,sysdate' || pv_nl ||
527: ' ,'|| FEM_GL_POST_PROCESS_PKG.pv_user_id || pv_nl ||
528: ' ,'||FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
529: ' ,flex.flex_value' || pv_nl ||
530: 'FROM FEM_INTG_EXEC_PARAMS_GT param_in,' || pv_nl ||
531: ' ( '||v_flex_query_stmt||' ) flex' || pv_nl ||
532: 'WHERE param_in.error_code IS NULL' || pv_nl ||
533: 'AND param_in.request_id IS NOT NULL' || pv_nl ||
534: 'AND param_in.load_method_code = ''I''' || pv_nl ||

Line 656: ' FEM_INTG_EXEC_PARAMS_GT param,' || pv_nl ||

652: ' nvl(glb.period_net_cr,0),' || pv_nl ||
653: ' nvl(glb.begin_balance_dr,0) + nvl(glb.period_net_dr,0),' || pv_nl ||
654: ' nvl(glb.begin_balance_cr,0) + nvl(glb.period_net_cr,0)' || pv_nl ||
655: 'FROM' || pv_nl ||
656: ' FEM_INTG_EXEC_PARAMS_GT param,' || pv_nl ||
657: ' GL_BALANCES_DELTA glb,' || pv_nl ||
658: ' FEM_INTG_DELTA_LOADS dl,' || pv_nl;
659:
660: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN

Line 849: FROM FEM_INTG_EXEC_PARAMS_GT param,

845: ps.end_date period_end_date,
846: ps.start_date period_start_date,
847: ps.quarter_start_date,
848: ps.year_start_date
849: FROM FEM_INTG_EXEC_PARAMS_GT param,
850: GL_PERIOD_STATUSES ps
851: WHERE param.error_code IS NULL
852: AND param.request_id IS NOT NULL
853: AND ps.application_id = 101

Line 1046: ' FEM_INTG_EXEC_PARAMS_GT param,' || pv_nl ||

1042: ' nvl(glb.period_aggregate<<>>,0)) /' || pv_nl ||
1043: ' <<>> / ccy_mau.mau) * ccy_mau.mau,' || pv_nl ||
1044: ' null)' || pv_nl ||
1045: 'FROM' || pv_nl ||
1046: ' FEM_INTG_EXEC_PARAMS_GT param,' || pv_nl ||
1047: ' GL_DAILY_BALANCES glb,' || pv_nl;
1048:
1049: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1050: v_sql_template := v_sql_template ||

Line 1554: FROM FEM_INTG_EXEC_PARAMS_GT param

1550: FEM_GL_POST_PROCESS_PKG.pv_user_id,
1551: sysdate,
1552: FEM_GL_POST_PROCESS_PKG.pv_user_id,
1553: FEM_GL_POST_PROCESS_PKG.pv_login_id
1554: FROM FEM_INTG_EXEC_PARAMS_GT param
1555: WHERE param.error_code IS NULL
1556: AND param.request_id IS NOT NULL
1557: AND NOT EXISTS
1558: (SELECT 1

Line 1593: ' FROM FEM_INTG_EXEC_PARAMS_GT param' || pv_nl ||

1589:
1590: v_delete_stmt := v_delete_stmt ||
1591: 'AND EXISTS' || pv_nl ||
1592: ' (SELECT 1' || pv_nl ||
1593: ' FROM FEM_INTG_EXEC_PARAMS_GT param' || pv_nl ||
1594: ' WHERE param.output_dataset_code = dl.dataset_code' || pv_nl ||
1595: ' AND param.cal_period_id = dl.cal_period_id' || pv_nl ||
1596: ' AND param.error_code IS NULL' || pv_nl ||
1597: ' AND param.request_id IS NOT NULL)' || pv_nl ||

Line 1647: 'FROM FEM_INTG_EXEC_PARAMS_GT param,' || pv_nl ||

1643: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1644: ' sysdate,' || pv_nl ||
1645: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1646: ' ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
1647: 'FROM FEM_INTG_EXEC_PARAMS_GT param,' || pv_nl ||
1648: ' FEM_BAL_POST_INTERIM_GT bpi,' || pv_nl ||
1649: ' GL_CODE_COMBINATIONS from_cc,' || pv_nl ||
1650: ' FEM_INTG_DELTA_LOADS dl' || pv_nl ||
1651: 'WHERE param.load_method_code = ''I''' || pv_nl ||

Line 1705: ' FROM FEM_INTG_EXEC_PARAMS_GT param_in,' || pv_nl ||

1701: 'MERGE INTO FEM_INTG_DELTA_LOADS dl' || pv_nl ||
1702: 'USING (SELECT param_in.output_dataset_code,' || pv_nl ||
1703: ' param_in.cal_period_id,' || pv_nl ||
1704: ' flex.flex_value' || pv_nl ||
1705: ' FROM FEM_INTG_EXEC_PARAMS_GT param_in,' || pv_nl ||
1706: ' (' || v_flex_query_stmt || ') flex' || pv_nl ||
1707: ' WHERE param_in.error_code IS NULL' || pv_nl ||
1708: ' AND param_in.request_id IS NOT NULL' || pv_nl ||
1709: ' AND param_in.load_method_code = ''S'') param' || pv_nl ||

Line 1777: ' FROM fem_intg_exec_params_gt param' || pv_nl ||

1773: v_update_stmt := v_update_stmt ||
1774: 'AND (dataset_code, cal_period_id) IN' || pv_nl ||
1775: ' (SELECT param.output_dataset_code,' || pv_nl ||
1776: ' param.cal_period_id' || pv_nl ||
1777: ' FROM fem_intg_exec_params_gt param' || pv_nl ||
1778: ' WHERE param.error_code IS NULL' || pv_nl ||
1779: ' AND param.request_id IS NOT NULL' || pv_nl ||
1780: ' AND param.load_method_code = ''I'')';
1781: