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_GL_POST_BAL_PKG dependencies on FEM_BAL_POST_INTERIM_GT

Line 20: -- This routine post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES.

16: -- Procedure
17: -- Post_Fem_Balances
18: --
19: -- Purpose
20: -- This routine post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES.
21: --
22: -- If execution mode is Snapshot, this procedure will do an insert into
23: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT.
24: --

Line 23: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT.

19: -- Purpose
20: -- This routine post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES.
21: --
22: -- If execution mode is Snapshot, this procedure will do an insert into
23: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT.
24: --
25: -- If execution mode is Incremental, this procedure will do a merge into
26: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT. It'll update the rows
27: -- if the processing keys between the two tables match. Otherwise, it'll

Line 26: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT. It'll update the rows

22: -- If execution mode is Snapshot, this procedure will do an insert into
23: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT.
24: --
25: -- If execution mode is Incremental, this procedure will do a merge into
26: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT. It'll update the rows
27: -- if the processing keys between the two tables match. Otherwise, it'll
28: -- do an insert into FEM_BALANCES.
29: --
30: -- History

Line 69: -- This routine post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES.

65: -- Procedure
66: -- Post_Fem_Balances
67: --
68: -- Purpose
69: -- This routine post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES.
70: --
71: -- If execution mode is Snapshot, this procedure will do an insert into
72: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT.
73: --

Line 72: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT.

68: -- Purpose
69: -- This routine post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES.
70: --
71: -- If execution mode is Snapshot, this procedure will do an insert into
72: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT.
73: --
74: -- If execution mode is Incremental, this procedure will do a merge into
75: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT. It'll update the rows
76: -- if the processing keys between the two tables match. Otherwise, it'll

Line 75: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT. It'll update the rows

71: -- If execution mode is Snapshot, this procedure will do an insert into
72: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT.
73: --
74: -- If execution mode is Incremental, this procedure will do a merge into
75: -- FEM_BALANCES from FEM_BAL_POST_INTERIM_GT. It'll update the rows
76: -- if the processing keys between the two tables match. Otherwise, it'll
77: -- do an insert into FEM_BALANCES.
78: --
79: -- History

Line 199: -- Insert data from FEM_BAL_POST_INTERIM_GT into FEM_BALANCES

195: ELSE
196: v_req_text := ' param.request_id, ';
197: END IF;
198:
199: -- Insert data from FEM_BAL_POST_INTERIM_GT into FEM_BALANCES
200: v_sql_stmt :=
201: 'INSERT INTO fem_balances '||
202: ' ( '||
203: ' dataset_code, '||

Line 288: ' FROM fem_bal_post_interim_gt bpi';

284: ' sum(bpi.ptd_debit_balance_e), '||
285: ' sum(bpi.ptd_credit_balance_e), '||
286: ' sum(bpi.ytd_debit_balance_e), '||
287: ' sum(bpi.ytd_credit_balance_e) '||
288: ' FROM fem_bal_post_interim_gt bpi';
289:
290: IF p_load_type = 'OGL' THEN
291: v_sql_stmt := v_sql_stmt || ', fem_intg_exec_params_gt param' ||
292: ', gl_code_combinations cc';

Line 409: v_merge_select := 'SELECT * FROM FEM_BAL_POST_INTERIM_GT ' ||

405: END LOOP;
406:
407: -- The select statement to be used in the USING part of the merge statement
408: IF p_load_type = 'XGL' THEN
409: v_merge_select := 'SELECT * FROM FEM_BAL_POST_INTERIM_GT ' ||
410: 'WHERE posting_error_flag = ''N''';
411: v_req_text := ':pv_req_id';
412: ELSE
413: v_merge_select :=

Line 433: 'FROM FEM_BAL_POST_INTERIM_GT pi, ' ||

429: 'sum(pi.ptd_debit_balance_e) ptd_debit_balance_e, ' ||
430: 'sum(pi.ptd_credit_balance_e) ptd_credit_balance_e, ' ||
431: 'sum(pi.ytd_debit_balance_e) ytd_debit_balance_e, ' ||
432: 'sum(pi.ytd_credit_balance_e) ytd_credit_balance_e ' ||
433: 'FROM FEM_BAL_POST_INTERIM_GT pi, ' ||
434: ' FEM_INTG_EXEC_PARAMS_GT param, ' ||
435: ' GL_CODE_COMBINATIONS cc ' ||
436: 'WHERE pi.dataset_code = param.output_dataset_code ' ||
437: 'AND pi.cal_period_id = param.cal_period_id ' ||

Line 461: -- Merge data from FEM_BAL_POST_INTERIM_GT into FEM_BALANCES

457: 'pi.user_dim10_id ';
458: v_req_text := 'int.request_id';
459: END IF;
460:
461: -- Merge data from FEM_BAL_POST_INTERIM_GT into FEM_BALANCES
462: v_sql_stmt_2 :=
463: ' MERGE INTO FEM_BALANCES bal '||
464: ' USING (' || v_merge_select || ') int '||
465: ' ON ( ' || v_key_stmt ||

Line 643: FROM FEM_BAL_POST_INTERIM_GT bpi

639:
640: -- Find out number of rows in the interim table
641: SELECT count(*)
642: INTO v_interim_row_count
643: FROM FEM_BAL_POST_INTERIM_GT bpi
644: WHERE posting_error_flag = 'N'
645: AND NOT EXISTS
646: (SELECT 1
647: FROM FEM_INTG_DELTA_LOADS dl