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_BALANCES

Line 17: -- Post_Fem_Balances

13:
14:
15: -- =========================================================================
16: -- Procedure
17: -- Post_Fem_Balances
18: --
19: -- Purpose
20: -- This routine post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES.
21: --

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 28: -- do an insert into FEM_BALANCES.

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
31: -- 10-15-2003 W Wong Created
32: --

Line 40: -- FEM_BALANCES

36: -- subrequest process number and the data slice id
37: -- for distinguishing messages logged by different
38: -- executions of FEM_XGL_ENGINE_PKG.Process_Data_Slice.
39: -- x_rows_posted Total number of rows inserted/merged into
40: -- FEM_BALANCES
41: -- x_completion_code 0 for success, 2 for failure
42: -- ==========================================================================
43:
44: PROCEDURE Post_Fem_Balances

Line 44: PROCEDURE Post_Fem_Balances

40: -- FEM_BALANCES
41: -- x_completion_code 0 for success, 2 for failure
42: -- ==========================================================================
43:
44: PROCEDURE Post_Fem_Balances
45: (p_execution_mode IN VARCHAR2,
46: p_process_slice IN VARCHAR2,
47: x_rows_posted IN OUT NOCOPY NUMBER,
48: x_completion_code IN OUT NOCOPY NUMBER) IS

Line 50: Post_Fem_Balances(

46: p_process_slice IN VARCHAR2,
47: x_rows_posted IN OUT NOCOPY NUMBER,
48: x_completion_code IN OUT NOCOPY NUMBER) IS
49: BEGIN
50: Post_Fem_Balances(
51: p_execution_mode => p_execution_mode,
52: p_process_slice => p_process_slice,
53: p_load_type => 'XGL',
54: p_maintain_qtd => 'N',

Line 59: END Post_Fem_Balances;

55: p_bsv_range_low => NULL,
56: p_bsv_range_high => NULL,
57: x_rows_posted => x_rows_posted,
58: x_completion_code => x_completion_code);
59: END Post_Fem_Balances;
60:
61:
62:
63:

Line 66: -- Post_Fem_Balances

62:
63:
64: -- =========================================================================
65: -- Procedure
66: -- Post_Fem_Balances
67: --
68: -- Purpose
69: -- This routine post data from FEM_BAL_POST_INTERIM_GT to FEM_BALANCES.
70: --

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 77: -- do an insert into FEM_BALANCES.

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
80: -- 10-15-2003 W Wong Created
81: --

Line 93: -- FEM_BALANCES

89: -- values to be filtered in
90: -- p_bsv_range_high High value for the range of balancing segment
91: -- values to be filtered in
92: -- x_rows_posted Total number of rows inserted/merged into
93: -- FEM_BALANCES
94: -- x_completion_code 0 for success, 2 for failure
95: -- ==========================================================================
96:
97: PROCEDURE Post_Fem_Balances

Line 97: PROCEDURE Post_Fem_Balances

93: -- FEM_BALANCES
94: -- x_completion_code 0 for success, 2 for failure
95: -- ==========================================================================
96:
97: PROCEDURE Post_Fem_Balances
98: (p_execution_mode IN VARCHAR2,
99: p_process_slice IN VARCHAR2,
100: p_load_type IN VARCHAR2,
101: p_maintain_qtd IN VARCHAR2,

Line 164: p_msg_text => 'BEGIN FEM_GL_POST_BAL_PKG.Post_FEM_Balances');

160:
161: FEM_ENGINES_PKG.Tech_Message
162: (p_severity => v_log_level_2,
163: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
164: p_msg_text => 'BEGIN FEM_GL_POST_BAL_PKG.Post_FEM_Balances');
165:
166: IF p_load_type = 'OGL' THEN
167: fem_gl_post_process_pkg.get_proc_key_info(p_process_slice, v_completion_code);
168: IF v_completion_code = 2 THEN

Line 176: -- the FEM_BALANCES table

172: END IF;
173: -----------------------------------------------------------------------
174: -- Retrive package variables from FEM_GL_POST_PROCESS_PKG and find
175: -- out some attribute information before we insert/merge data into
176: -- the FEM_BALANCES table
177: -----------------------------------------------------------------------
178: pv_req_id := FEM_GL_POST_PROCESS_PKG.pv_req_id;
179: pv_rule_obj_id := FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id;
180: pv_proc_key_dim_num := FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num;

Line 185: -- the interim table to FEM_BALANCES.

181: pv_ledger_id := FEM_GL_POST_PROCESS_PKG.pv_ledger_id;
182:
183: -----------------------------------------------------------------------
184: -- IF the executaion mode is Snapshot mode, we will insert data from
185: -- the interim table to FEM_BALANCES.
186: -- ELSE if the execution mode is Incremental, we will try to merge
187: -- data into FEM_BALANCES if the processing keys between the interim
188: -- table and FEM_BALANCES matches. Otherwise we'll insert the data.
189: -----------------------------------------------------------------------

Line 187: -- data into FEM_BALANCES if the processing keys between the interim

183: -----------------------------------------------------------------------
184: -- IF the executaion mode is Snapshot mode, we will insert data from
185: -- the interim table to FEM_BALANCES.
186: -- ELSE if the execution mode is Incremental, we will try to merge
187: -- data into FEM_BALANCES if the processing keys between the interim
188: -- table and FEM_BALANCES matches. Otherwise we'll insert the data.
189: -----------------------------------------------------------------------
190:
191: IF (p_execution_mode = 'S') THEN

Line 188: -- table and FEM_BALANCES matches. Otherwise we'll insert the data.

184: -- IF the executaion mode is Snapshot mode, we will insert data from
185: -- the interim table to FEM_BALANCES.
186: -- ELSE if the execution mode is Incremental, we will try to merge
187: -- data into FEM_BALANCES if the processing keys between the interim
188: -- table and FEM_BALANCES matches. Otherwise we'll insert the data.
189: -----------------------------------------------------------------------
190:
191: IF (p_execution_mode = 'S') THEN
192:

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 201: 'INSERT INTO fem_balances '||

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, '||
204: ' cal_period_id, '||
205: ' creation_row_sequence, '||

Line 383: p_value2 => 'FEM_BALANCES');

379: p_msg_name => 'FEM_GL_POST_216',
380: p_token1 => 'NUM',
381: p_value1 => TO_CHAR(x_rows_posted),
382: p_token2 => 'TABLE',
383: p_value2 => 'FEM_BALANCES');
384:
385: ELSE
386: -- Find out primary keys for FEM_BALANCES and construct the ON clause for
387: -- the Merge statement

Line 386: -- Find out primary keys for FEM_BALANCES and construct the ON clause for

382: p_token2 => 'TABLE',
383: p_value2 => 'FEM_BALANCES');
384:
385: ELSE
386: -- Find out primary keys for FEM_BALANCES and construct the ON clause for
387: -- the Merge statement
388: v_first_time := 'Y';
389: v_key_stmt := '';
390:

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 463: ' MERGE INTO FEM_BALANCES bal '||

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 ||
466: ')' ||
467: ' WHEN MATCHED THEN UPDATE SET '||

Line 636: ' rows into FEM_BALANCES');

632: ( p_severity => v_log_level_1,
633: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
634: p_app_name => 'FEM',
635: p_msg_text => 'Merged ' || TO_CHAR(x_rows_posted) ||
636: ' rows into FEM_BALANCES');
637:
638: END IF;
639:
640: -- Find out number of rows in the interim table

Line 709: UPDATE FEM_BALANCES fb

705: INTO v_ps_name, v_period_type
706: FROM gl_ledgers
707: WHERE ledger_id = pv_ledger_id;
708:
709: UPDATE FEM_BALANCES fb
710: SET (qtd_balance_e, qtd_balance_f) =
711: (SELECT
712: fb.xtd_balance_e + nvl(sum(nvl(fb_in.xtd_balance_e,0)),0),
713: fb.xtd_balance_f + nvl(sum(nvl(fb_in.xtd_balance_f,0)),0)

Line 714: FROM FEM_BALANCES fb_in,

710: SET (qtd_balance_e, qtd_balance_f) =
711: (SELECT
712: fb.xtd_balance_e + nvl(sum(nvl(fb_in.xtd_balance_e,0)),0),
713: fb.xtd_balance_f + nvl(sum(nvl(fb_in.xtd_balance_f,0)),0)
714: FROM FEM_BALANCES fb_in,
715: FEM_CAL_PERIODS_B cp_curr,
716: FEM_CAL_PERIODS_B cp_prev,
717: FEM_CAL_PERIODS_ATTR cpa_curr,
718: FEM_CAL_PERIODS_ATTR cpa_prev,

Line 803: ' rows in FEM_BALANCES');

799: ( p_severity => v_log_level_1,
800: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
801: p_app_name => 'FEM',
802: p_msg_text => 'Updated ' || TO_CHAR(x_rows_posted) ||
803: ' rows in FEM_BALANCES');
804: END IF;
805: END IF;
806:
807:

Line 814: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');

810:
811: FEM_ENGINES_PKG.Tech_Message
812: (p_severity => v_log_level_2,
813: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
814: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');
815:
816: EXCEPTION
817: WHEN DATA_CORRUPTION THEN
818:

Line 828: p_msg_text => 'Data corruption in FEM_BALANCES!');

824:
825: FEM_ENGINES_PKG.Tech_Message
826: (p_severity => v_log_level_6,
827: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
828: p_msg_text => 'Data corruption in FEM_BALANCES!');
829:
830: FEM_ENGINES_PKG.User_Message
831: (p_app_name => 'FEM',
832: p_msg_name => 'FEM_GL_POST_401');

Line 837: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');

833:
834: FEM_ENGINES_PKG.Tech_Message
835: (p_severity => v_log_level_2,
836: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
837: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');
838:
839: WHEN PROC_KEY_ERROR THEN
840:
841: FEM_ENGINES_PKG.Tech_Message

Line 844: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');

840:
841: FEM_ENGINES_PKG.Tech_Message
842: (p_severity => v_log_level_2,
843: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
844: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');
845:
846: WHEN OTHERS THEN
847:
848: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := SQLERRM;

Line 873: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');

869:
870: FEM_ENGINES_PKG.Tech_Message
871: (p_severity => v_log_level_2,
872: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
873: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');
874:
875: END post_fem_balances;
876:
877: END FEM_GL_POST_BAL_PKG;

Line 875: END post_fem_balances;

871: (p_severity => v_log_level_2,
872: p_module => 'fem.plsql.gl_post_bal.pfb.' || p_process_slice,
873: p_msg_text => 'END FEM_GL_POST_BAL_PKG.Post_FEM_Balances');
874:
875: END post_fem_balances;
876:
877: END FEM_GL_POST_BAL_PKG;