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_GL_POST_PROCESS_PKG

Line 55: WHERE lgr.ledger_id = FEM_GL_POST_PROCESS_PKG.pv_ledger_id

51: FROM gl_ledgers lgr,
52: fnd_segment_attribute_values sav,
53: fnd_id_flex_segments ifs,
54: fnd_flex_value_sets fvs
55: WHERE lgr.ledger_id = FEM_GL_POST_PROCESS_PKG.pv_ledger_id
56: AND sav.application_id = 101
57: AND sav.id_flex_code = 'GL#'
58: AND sav.id_flex_num = lgr.chart_of_accounts_id
59: AND sav.segment_attribute_type = 'GL_BALANCING'

Line 167: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_ext_acct_type_dim_id,

163: x_completion_code := 0;
164: x_num_rows_inserted := 0;
165:
166: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id(
167: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_ext_acct_type_dim_id,
168: p_attr_label => 'BASIC_ACCOUNT_TYPE_CODE',
169: x_attr_id => v_xat_basic_type_attr_id,
170: x_ver_id => v_xat_basic_type_v_id,
171: x_err_code => v_error_code);

Line 174: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_ext_acct_type_dim_id,

170: x_ver_id => v_xat_basic_type_v_id,
171: x_err_code => v_error_code);
172:
173: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id(
174: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_ext_acct_type_dim_id,
175: p_attr_label => 'SIGN',
176: x_attr_id => v_xat_sign_attr_id,
177: x_ver_id => v_xat_sign_v_id,
178: x_err_code => v_error_code);

Line 216: 'AND ccmap.global_vs_combo_id (+)= ' || FEM_GL_POST_PROCESS_PKG.pv_global_vs_combo_id || pv_nl ||

212: ' ccmap.USER_DIM9_ID,' || pv_nl ||
213: ' ccmap.USER_DIM10_ID,' || pv_nl;
214:
215: v_ccmap_join :=
216: 'AND ccmap.global_vs_combo_id (+)= ' || FEM_GL_POST_PROCESS_PKG.pv_global_vs_combo_id || pv_nl ||
217: 'AND ccmap.COMPANY_COST_CENTER_ORG_ID (+)<> -1' || pv_nl ||
218: 'AND ccmap.NATURAL_ACCOUNT_ID (+)<> -1' || pv_nl ||
219: 'AND ccmap.LINE_ITEM_ID (+)<> -1' || pv_nl ||
220: 'AND ccmap.PRODUCT_ID (+)<> -1' || pv_nl ||

Line 240: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN

236: 'AND ccmap.TASK_ID (+)<> -1' || pv_nl;
237:
238:
239: v_ccy_join := '';
240: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
241: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
242: v_ccy_join :=
243: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||
244: ' glb.translated_flag = ''R'' OR' || pv_nl ||

Line 241: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN

237:
238:
239: v_ccy_join := '';
240: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
241: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
242: v_ccy_join :=
243: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||
244: ' glb.translated_flag = ''R'' OR' || pv_nl ||
245: ' (glb.translated_flag IN (''Y'', ''N'') AND' || pv_nl ||

Line 249: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

245: ' (glb.translated_flag IN (''Y'', ''N'') AND' || pv_nl ||
246: ' EXISTS' || pv_nl ||
247: ' (SELECT 1' || pv_nl ||
248: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
249: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
250: ' AND ccy.xlated_currency_code = glb.currency_code)))' || pv_nl;
251: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'NONE' THEN
252: v_ccy_join :=
253: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||

Line 251: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'NONE' THEN

247: ' (SELECT 1' || pv_nl ||
248: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
249: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
250: ' AND ccy.xlated_currency_code = glb.currency_code)))' || pv_nl;
251: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'NONE' THEN
252: v_ccy_join :=
253: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||
254: ' glb.translated_flag = ''R'')' || pv_nl;
255: END IF;

Line 256: ELSIF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'FUNCTIONAL' THEN

252: v_ccy_join :=
253: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||
254: ' glb.translated_flag = ''R'')' || pv_nl;
255: END IF;
256: ELSIF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'FUNCTIONAL' THEN
257: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
258: v_ccy_join :=
259: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||
260: ' (glb.translated_flag IN (''Y'', ''N'') AND' || pv_nl ||

Line 257: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN

253: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||
254: ' glb.translated_flag = ''R'')' || pv_nl;
255: END IF;
256: ELSIF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'FUNCTIONAL' THEN
257: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
258: v_ccy_join :=
259: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||
260: ' (glb.translated_flag IN (''Y'', ''N'') AND' || pv_nl ||
261: ' EXISTS' || pv_nl ||

Line 264: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

260: ' (glb.translated_flag IN (''Y'', ''N'') AND' || pv_nl ||
261: ' EXISTS' || pv_nl ||
262: ' (SELECT 1' || pv_nl ||
263: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
264: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
265: ' AND ccy.xlated_currency_code = glb.currency_code)))' || pv_nl;
266: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN
267: v_ccy_join :=
268: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||

Line 266: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN

262: ' (SELECT 1' || pv_nl ||
263: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
264: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
265: ' AND ccy.xlated_currency_code = glb.currency_code)))' || pv_nl;
266: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN
267: v_ccy_join :=
268: 'AND (glb.translated_flag IS NULL OR' || pv_nl ||
269: ' glb.translated_flag IN (''Y'', ''N''))' || pv_nl;
270: ELSE -- No translated balances

Line 275: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN

271: v_ccy_join :=
272: 'AND glb.translated_flag IS NULL' || pv_nl;
273: END IF;
274: ELSE -- Translated only
275: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
276: v_ccy_join :=
277: 'AND glb.translated_flag IN (''Y'', ''N'')' || pv_nl ||
278: 'AND EXISTS' || pv_nl ||
279: ' (SELECT 1' || pv_nl ||

Line 281: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

277: 'AND glb.translated_flag IN (''Y'', ''N'')' || pv_nl ||
278: 'AND EXISTS' || pv_nl ||
279: ' (SELECT 1' || pv_nl ||
280: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
281: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
282: ' AND ccy.xlated_currency_code = glb.currency_code)' || pv_nl;
283: ELSE -- All translated balances
284: v_ccy_join :=
285: 'AND glb.translated_flag IN (''Y'', ''N'')' || pv_nl;

Line 291: IF FEM_GL_POST_PROCESS_PKG.pv_from_gl_bal_flag = 'Y' THEN

287: END IF;
288:
289:
290: -- If we are doing any snapshots, do it here
291: IF FEM_GL_POST_PROCESS_PKG.pv_from_gl_bal_flag = 'Y' THEN
292: v_sql :=
293: v_insert ||
294: 'SELECT' || pv_nl ||
295: ' glb.ROWID,' || pv_nl ||

Line 300: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||

296: ' null,' || pv_nl ||
297: ' ''R'',' || pv_nl ||
298: ' param.OUTPUT_DATASET_CODE,' || pv_nl ||
299: ' param.CAL_PERIOD_ID,' || pv_nl ||
300: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
301: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||
302: ' ccmap.COMPANY_COST_CENTER_ORG_ID,' || pv_nl ||
303: ' decode(glb.currency_code,' || pv_nl ||
304: ' ''STAT'', 10000,' || pv_nl ||

Line 301: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||

297: ' ''R'',' || pv_nl ||
298: ' param.OUTPUT_DATASET_CODE,' || pv_nl ||
299: ' param.CAL_PERIOD_ID,' || pv_nl ||
300: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
301: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||
302: ' ccmap.COMPANY_COST_CENTER_ORG_ID,' || pv_nl ||
303: ' decode(glb.currency_code,' || pv_nl ||
304: ' ''STAT'', 10000,' || pv_nl ||
305: ' decode(xat_acct.dim_attribute_varchar_member,' || pv_nl ||

Line 400: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN

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 ||
402: ' FEM_INTG_BAL_DEF_BSVS bsv,' || pv_nl;
403: END IF;
404:

Line 412: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd <> 'BUDGET' THEN

408: ' FEM_EXT_ACCT_TYPES_ATTR xat_acct,' || pv_nl ||
409: ' FEM_EXT_ACCT_TYPES_ATTR xat_sign' || pv_nl ||
410: 'WHERE param.error_code IS NULL' || pv_nl;
411:
412: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd <> 'BUDGET' THEN
413: v_sql := v_sql ||
414: 'AND param.load_method_code = ''S''' || pv_nl;
415: END IF;
416:

Line 419: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

415: END IF;
416:
417: v_sql := v_sql ||
418: 'AND param.request_id IS NOT NULL' || pv_nl ||
419: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
420: 'AND glb.period_name = param.period_name' || pv_nl;
421:
422: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN
423: v_sql := v_sql ||

Line 422: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN

418: 'AND param.request_id IS NOT NULL' || pv_nl ||
419: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
420: 'AND glb.period_name = param.period_name' || pv_nl;
421:
422: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN
423: v_sql := v_sql ||
424: 'AND glb.actual_flag = ''A''' || pv_nl;
425: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN
426: v_sql := v_sql ||

Line 425: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN

421:
422: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN
423: v_sql := v_sql ||
424: 'AND glb.actual_flag = ''A''' || pv_nl;
425: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN
426: v_sql := v_sql ||
427: 'AND glb.actual_flag = ''B''' || pv_nl ||
428: 'AND glb.budget_version_id = param.budget_id' || pv_nl;
429: ELSE -- encumbrances

Line 435: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN

431: 'AND glb.actual_flag = ''E''' || pv_nl ||
432: 'AND glb.encumbrance_type_id = param.encumbrance_type_id' || pv_nl;
433: END IF;
434:
435: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
436: v_sql := v_sql ||
437: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
438: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
439: END IF;

Line 437: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

433: END IF;
434:
435: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
436: v_sql := v_sql ||
437: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
438: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
439: END IF;
440:
441:

Line 438: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;

434:
435: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
436: v_sql := v_sql ||
437: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
438: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
439: END IF;
440:
441:
442: v_sql := v_sql ||

Line 460: ' WHERE fb_curr.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

456: v_sql := v_sql ||
457: 'AND (NOT EXISTS' || pv_nl ||
458: ' (SELECT 1' || pv_nl ||
459: ' FROM fem_balances fb_curr' || pv_nl ||
460: ' WHERE fb_curr.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
461: ' AND fb_curr.dataset_code = param.output_dataset_code' || pv_nl ||
462: ' AND fb_curr.cal_period_id = param.cal_period_id)' || pv_nl ||
463: ' OR cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' BETWEEN ' || p_bsv_range_low || ' AND ' || p_bsv_range_high || ')' || pv_nl;
464: END IF;

Line 463: ' OR cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' BETWEEN ' || p_bsv_range_low || ' AND ' || p_bsv_range_high || ')' || pv_nl;

459: ' FROM fem_balances fb_curr' || pv_nl ||
460: ' WHERE fb_curr.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
461: ' AND fb_curr.dataset_code = param.output_dataset_code' || pv_nl ||
462: ' AND fb_curr.cal_period_id = param.cal_period_id)' || pv_nl ||
463: ' OR cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' BETWEEN ' || p_bsv_range_low || ' AND ' || p_bsv_range_high || ')' || pv_nl;
464: END IF;
465:
466: -- Add the joins for the currency information here
467: v_sql := v_sql || v_ccy_join;

Line 500: IF FEM_GL_POST_PROCESS_PKG.pv_from_gl_delta_flag = 'Y' THEN

496:
497:
498:
499: -- If we are doing any incremental loads, do them here
500: IF FEM_GL_POST_PROCESS_PKG.pv_from_gl_delta_flag = 'Y' THEN
501:
502: --start bug fix 5585720
503: v_flex_query_stmt := get_flex_values_query;
504:

Line 519: FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

515: ' ,LAST_UPDATED_BY' || pv_nl ||
516: ' ,LAST_UPDATE_LOGIN' || pv_nl ||
517: ' ,BALANCE_SEG_VALUE)' || pv_nl ||
518: ' SELECT '|| pv_nl ||
519: FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
520: ' ,param_in.output_dataset_code' || pv_nl ||
521: ' ,param_in.cal_period_id' || pv_nl ||
522: ' ,-1' || pv_nl ||
523: ' ,''Y''' || pv_nl ||

Line 525: ' ,'|| FEM_GL_POST_PROCESS_PKG.pv_user_id|| pv_nl ||

521: ' ,param_in.cal_period_id' || pv_nl ||
522: ' ,-1' || pv_nl ||
523: ' ,''Y''' || pv_nl ||
524: ' ,sysdate' || pv_nl ||
525: ' ,'|| FEM_GL_POST_PROCESS_PKG.pv_user_id|| 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 ||

Line 527: ' ,'|| FEM_GL_POST_PROCESS_PKG.pv_user_id || pv_nl ||

523: ' ,''Y''' || pv_nl ||
524: ' ,sysdate' || pv_nl ||
525: ' ,'|| FEM_GL_POST_PROCESS_PKG.pv_user_id|| 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 ||

Line 528: ' ,'||FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||

524: ' ,sysdate' || pv_nl ||
525: ' ,'|| FEM_GL_POST_PROCESS_PKG.pv_user_id|| 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 ||

Line 537: ' WHERE LEDGER_ID= '||FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

533: 'AND param_in.request_id IS NOT NULL' || pv_nl ||
534: 'AND param_in.load_method_code = ''I''' || pv_nl ||
535: 'AND NOT EXISTS ( SELECT 1' || pv_nl ||
536: ' FROM FEM_INTG_DELTA_LOADS' || pv_nl ||
537: ' WHERE LEDGER_ID= '||FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
538: ' AND DATASET_CODE = param_in.output_dataset_code' || pv_nl ||
539: ' AND CAL_PERIOD_ID = param_in.cal_period_id' || pv_nl ||
540: ' AND BALANCE_SEG_VALUE = flex.flex_value)';
541:

Line 563: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||

559: ' glb.delta_run_id,' || pv_nl ||
560: ' ''A'',' || pv_nl ||
561: ' param.OUTPUT_DATASET_CODE,' || pv_nl ||
562: ' param.CAL_PERIOD_ID,' || pv_nl ||
563: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
564: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||
565: ' ccmap.COMPANY_COST_CENTER_ORG_ID,' || pv_nl ||
566: ' decode(glb.currency_code,' || pv_nl ||
567: ' ''STAT'', 10000,' || pv_nl ||

Line 564: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||

560: ' ''A'',' || pv_nl ||
561: ' param.OUTPUT_DATASET_CODE,' || pv_nl ||
562: ' param.CAL_PERIOD_ID,' || pv_nl ||
563: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
564: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||
565: ' ccmap.COMPANY_COST_CENTER_ORG_ID,' || pv_nl ||
566: ' decode(glb.currency_code,' || pv_nl ||
567: ' ''STAT'', 10000,' || pv_nl ||
568: ' decode(xat_acct.dim_attribute_varchar_member,' || pv_nl ||

Line 660: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN

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
661: v_sql := v_sql ||
662: ' FEM_INTG_BAL_DEF_BSVS bsv,' || pv_nl;
663: END IF;
664:

Line 673: 'AND dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

669: ' FEM_EXT_ACCT_TYPES_ATTR xat_sign' || pv_nl ||
670: 'WHERE param.load_method_code = ''I''' || pv_nl ||
671: 'AND param.error_code IS NULL' || pv_nl ||
672: 'AND param.request_id IS NOT NULL' || pv_nl ||
673: 'AND dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
674: 'AND dl.dataset_code = param.output_dataset_code' || pv_nl ||
675: 'AND dl.cal_period_id = param.cal_period_id' || pv_nl ||
676: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
677: 'AND glb.period_name = param.period_name' || pv_nl;

Line 676: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

672: 'AND param.request_id IS NOT NULL' || pv_nl ||
673: 'AND dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
674: 'AND dl.dataset_code = param.output_dataset_code' || pv_nl ||
675: 'AND dl.cal_period_id = param.cal_period_id' || pv_nl ||
676: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
677: 'AND glb.period_name = param.period_name' || pv_nl;
678:
679: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN
680: v_sql := v_sql ||

Line 679: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN

675: 'AND dl.cal_period_id = param.cal_period_id' || pv_nl ||
676: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
677: 'AND glb.period_name = param.period_name' || pv_nl;
678:
679: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN
680: v_sql := v_sql ||
681: 'AND glb.actual_flag = ''A''' || pv_nl;
682: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN
683: v_sql := v_sql ||

Line 682: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN

678:
679: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN
680: v_sql := v_sql ||
681: 'AND glb.actual_flag = ''A''' || pv_nl;
682: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN
683: v_sql := v_sql ||
684: 'AND glb.actual_flag = ''B''' || pv_nl ||
685: 'AND glb.budget_version_id = param.budget_id' || pv_nl;
686: ELSE -- encumbrances

Line 692: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN

688: 'AND glb.actual_flag = ''E''' || pv_nl ||
689: 'AND glb.encumbrance_type_id = param.encumbrance_type_id' || pv_nl;
690: END IF;
691:
692: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
693: v_sql := v_sql ||
694: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
695: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
696: END IF;

Line 694: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

690: END IF;
691:
692: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
693: v_sql := v_sql ||
694: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
695: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
696: END IF;
697:
698: -- If there is a range specified, only pull data in that range

Line 695: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;

691:
692: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
693: v_sql := v_sql ||
694: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
695: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
696: END IF;
697:
698: -- If there is a range specified, only pull data in that range
699: v_sql := v_sql ||

Line 700: 'AND cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' = dl.balance_seg_value' || pv_nl;

696: END IF;
697:
698: -- If there is a range specified, only pull data in that range
699: v_sql := v_sql ||
700: 'AND cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' = dl.balance_seg_value' || pv_nl;
701:
702: v_sql := v_sql ||
703: 'AND cc.code_combination_id = glb.code_combination_id' || pv_nl ||
704: 'AND cc.template_id IS NULL' || pv_nl ||

Line 758: 'AND glb.delta_run_id BETWEEN dl.delta_run_id + 1 AND ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id;

754:
755:
756: v_sql_incr := v_sql ||
757: 'AND dl.loaded_flag = ''Y''' || pv_nl ||
758: 'AND glb.delta_run_id BETWEEN dl.delta_run_id + 1 AND ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id;
759:
760: -- Print the incremental upload statement
761: FOR iterator IN 1..trunc((length(v_sql_incr)+1499)/1500) LOOP
762: FEM_ENGINES_PKG.Tech_Message

Line 854: AND ps.ledger_id = FEM_GL_POST_PROCESS_PKG.pv_ledger_id

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
854: AND ps.ledger_id = FEM_GL_POST_PROCESS_PKG.pv_ledger_id
855: AND ps.period_name = param.period_name;
856:
857: v_end_date DATE; -- Date to be used in calculating average balances
858:

Line 881: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_ext_acct_type_dim_id,

877: x_completion_code := 0;
878: x_num_rows_inserted := 0;
879:
880: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id(
881: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_ext_acct_type_dim_id,
882: p_attr_label => 'BASIC_ACCOUNT_TYPE_CODE',
883: x_attr_id => v_xat_basic_type_attr_id,
884: x_ver_id => v_xat_basic_type_v_id,
885: x_err_code => v_error_code);

Line 888: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_ext_acct_type_dim_id,

884: x_ver_id => v_xat_basic_type_v_id,
885: x_err_code => v_error_code);
886:
887: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id(
888: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_ext_acct_type_dim_id,
889: p_attr_label => 'SIGN',
890: x_attr_id => v_xat_sign_attr_id,
891: x_ver_id => v_xat_sign_v_id,
892: x_err_code => v_error_code);

Line 926: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||

922: ' glb.ROWID,' || pv_nl ||
923: ' ''R'',' || pv_nl ||
924: ' param.OUTPUT_DATASET_CODE,' || pv_nl ||
925: ' param.CAL_PERIOD_ID,' || pv_nl ||
926: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
927: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||
928: ' ccmap.COMPANY_COST_CENTER_ORG_ID,' || pv_nl ||
929: ' 140,' || pv_nl ||
930: ' ccmap.PRODUCT_ID,' || pv_nl ||

Line 927: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||

923: ' ''R'',' || pv_nl ||
924: ' param.OUTPUT_DATASET_CODE,' || pv_nl ||
925: ' param.CAL_PERIOD_ID,' || pv_nl ||
926: ' ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
927: ' ' || FEM_GL_POST_PROCESS_PKG.pv_gl_source_system_code || ',' || pv_nl ||
928: ' ccmap.COMPANY_COST_CENTER_ORG_ID,' || pv_nl ||
929: ' 140,' || pv_nl ||
930: ' ccmap.PRODUCT_ID,' || pv_nl ||
931: ' ccmap.NATURAL_ACCOUNT_ID,' || pv_nl ||

Line 977: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN

973: ' decode(glb.currency_type,' || pv_nl ||
974: ' ''T'', null,' || pv_nl ||
975: ' ''O'', null,' || pv_nl;
976:
977: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
978: v_sql_template := v_sql_template ||
979: ' ''E'', nvl(glbc.period_aggregate<<>>,0),' || pv_nl;
980: END IF;
981:

Line 990: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN

986: ' decode(glb.currency_type,' || pv_nl ||
987: ' ''T'', null,' || pv_nl ||
988: ' ''O'', null,' || pv_nl;
989:
990: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
991: v_sql_template := v_sql_template ||
992: ' ''E'', nvl(glbc.opening_quarter_aggregate,0) +' || pv_nl ||
993: ' nvl(glbc.period_aggregate<<>>,0),' || pv_nl;
994: END IF;

Line 1005: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN

1001: ' decode(glb.currency_type,' || pv_nl ||
1002: ' ''T'', null,' || pv_nl ||
1003: ' ''O'', null,' || pv_nl;
1004:
1005: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1006: v_sql_template := v_sql_template ||
1007: ' ''E'', nvl(glbc.opening_year_aggregate,0) +' || pv_nl ||
1008: ' nvl(glbc.period_aggregate<<>>,0),' || pv_nl;
1009: END IF;

Line 1049: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN

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 ||
1051: ' GL_DAILY_BALANCES glbc,' || pv_nl;
1052: END IF;
1053:

Line 1054: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN

1050: v_sql_template := v_sql_template ||
1051: ' GL_DAILY_BALANCES glbc,' || pv_nl;
1052: END IF;
1053:
1054: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
1055: v_sql_template := v_sql_template ||
1056: ' FEM_INTG_BAL_DEF_BSVS bsv,' || pv_nl;
1057: END IF;
1058:

Line 1074: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN

1070: 'AND param.request_id IS NOT NULL' || pv_nl ||
1071: 'AND param.period_name = ''<<>>''' || pv_nl ||
1072: 'AND ccy_mau.currency_code = glb.currency_code' || pv_nl;
1073:
1074: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1075: v_sql_template := v_sql_template ||
1076: 'AND ccy_mau_c.currency_code (+)= glbc.currency_code' || pv_nl;
1077: ELSE
1078: v_sql_template := v_sql_template ||

Line 1083: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

1079: 'AND ccy_mau_c.currency_code = glb.currency_code' || pv_nl;
1080: END IF;
1081:
1082: v_sql_template := v_sql_template ||
1083: 'AND glb.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1084: 'AND glb.period_name = param.period_name' || pv_nl ||
1085: 'AND glb.actual_flag = ''A''' || pv_nl ||
1086: 'AND glb.currency_code <> ''STAT''' || pv_nl;
1087:

Line 1088: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN

1084: 'AND glb.period_name = param.period_name' || pv_nl ||
1085: 'AND glb.actual_flag = ''A''' || pv_nl ||
1086: 'AND glb.currency_code <> ''STAT''' || pv_nl;
1087:
1088: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1089: v_sql_template := v_sql_template ||
1090: 'AND glbc.ledger_id (+)= ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1091: 'AND glbc.code_combination_id (+)= glb.code_combination_id' || pv_nl ||
1092: 'AND glbc.currency_code (+)= ''' || FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code || '''' || pv_nl ||

Line 1090: 'AND glbc.ledger_id (+)= ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

1086: 'AND glb.currency_code <> ''STAT''' || pv_nl;
1087:
1088: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1089: v_sql_template := v_sql_template ||
1090: 'AND glbc.ledger_id (+)= ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1091: 'AND glbc.code_combination_id (+)= glb.code_combination_id' || pv_nl ||
1092: 'AND glbc.currency_code (+)= ''' || FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code || '''' || pv_nl ||
1093: 'AND glbc.currency_type (+)= ''C''' || pv_nl ||
1094: 'AND glbc.actual_flag (+)= ''A''' || pv_nl ||

Line 1092: 'AND glbc.currency_code (+)= ''' || FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code || '''' || pv_nl ||

1088: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1089: v_sql_template := v_sql_template ||
1090: 'AND glbc.ledger_id (+)= ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1091: 'AND glbc.code_combination_id (+)= glb.code_combination_id' || pv_nl ||
1092: 'AND glbc.currency_code (+)= ''' || FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code || '''' || pv_nl ||
1093: 'AND glbc.currency_type (+)= ''C''' || pv_nl ||
1094: 'AND glbc.actual_flag (+)= ''A''' || pv_nl ||
1095: 'AND glbc.period_name (+)= glb.period_name' || pv_nl ||
1096: 'AND glbc.converted_from_currency (+)= glb.currency_code' || pv_nl;

Line 1099: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN

1095: 'AND glbc.period_name (+)= glb.period_name' || pv_nl ||
1096: 'AND glbc.converted_from_currency (+)= glb.currency_code' || pv_nl;
1097: END IF;
1098:
1099: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
1100: v_sql_template := v_sql_template ||
1101: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
1102: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
1103: END IF;

Line 1101: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

1097: END IF;
1098:
1099: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
1100: v_sql_template := v_sql_template ||
1101: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
1102: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
1103: END IF;
1104:
1105: v_sql_template := v_sql_template ||

Line 1102: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;

1098:
1099: IF FEM_GL_POST_PROCESS_PKG.pv_bsv_option = 'SPECIFIC' THEN
1100: v_sql_template := v_sql_template ||
1101: 'AND bsv.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
1102: 'AND bsv.balance_seg_value = cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || pv_nl;
1103: END IF;
1104:
1105: v_sql_template := v_sql_template ||
1106: 'AND cc.code_combination_id = glb.code_combination_id' || pv_nl ||

Line 1109: 'AND ccmap.global_vs_combo_id (+)= ' || FEM_GL_POST_PROCESS_PKG.pv_global_vs_combo_id || pv_nl ||

1105: v_sql_template := v_sql_template ||
1106: 'AND cc.code_combination_id = glb.code_combination_id' || pv_nl ||
1107: 'AND cc.template_id IS NULL' || pv_nl ||
1108: 'AND ccmap.code_combination_id (+)= cc.code_combination_id' || pv_nl ||
1109: 'AND ccmap.global_vs_combo_id (+)= ' || FEM_GL_POST_PROCESS_PKG.pv_global_vs_combo_id || pv_nl ||
1110: 'AND ccmap.COMPANY_COST_CENTER_ORG_ID (+)<> -1' || pv_nl ||
1111: 'AND ccmap.NATURAL_ACCOUNT_ID (+)<> -1' || pv_nl ||
1112: 'AND ccmap.LINE_ITEM_ID (+)<> -1' || pv_nl ||
1113: 'AND ccmap.PRODUCT_ID (+)<> -1' || pv_nl ||

Line 1141: ' WHERE fb_curr.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

1137: v_sql_template := v_sql_template ||
1138: 'AND (NOT EXISTS' || pv_nl ||
1139: ' (SELECT 1' || pv_nl ||
1140: ' FROM fem_balances fb_curr' || pv_nl ||
1141: ' WHERE fb_curr.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1142: ' AND fb_curr.dataset_code = param.output_dataset_code' || pv_nl ||
1143: ' AND fb_curr.cal_period_id = param.cal_period_id)' || pv_nl ||
1144: ' OR cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' BETWEEN ' || p_bsv_range_low || ' AND ' || p_bsv_range_high || ')' || pv_nl;
1145: END IF;

Line 1144: ' OR cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' BETWEEN ' || p_bsv_range_low || ' AND ' || p_bsv_range_high || ')' || pv_nl;

1140: ' FROM fem_balances fb_curr' || pv_nl ||
1141: ' WHERE fb_curr.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1142: ' AND fb_curr.dataset_code = param.output_dataset_code' || pv_nl ||
1143: ' AND fb_curr.cal_period_id = param.cal_period_id)' || pv_nl ||
1144: ' OR cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' BETWEEN ' || p_bsv_range_low || ' AND ' || p_bsv_range_high || ')' || pv_nl;
1145: END IF;
1146:
1147: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1148: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN

Line 1147: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN

1143: ' AND fb_curr.cal_period_id = param.cal_period_id)' || pv_nl ||
1144: ' OR cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' BETWEEN ' || p_bsv_range_low || ' AND ' || p_bsv_range_high || ')' || pv_nl;
1145: END IF;
1146:
1147: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1148: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
1149: v_sql_template := v_sql_template ||
1150: 'AND (glb.currency_type IN (''U'', ''E'') OR' || pv_nl ||
1151: ' (glb.currency_type IN (''T'', ''O'') AND' || pv_nl ||

Line 1148: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN

1144: ' OR cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name || ' BETWEEN ' || p_bsv_range_low || ' AND ' || p_bsv_range_high || ')' || pv_nl;
1145: END IF;
1146:
1147: IF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'ENTERED' THEN
1148: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
1149: v_sql_template := v_sql_template ||
1150: 'AND (glb.currency_type IN (''U'', ''E'') OR' || pv_nl ||
1151: ' (glb.currency_type IN (''T'', ''O'') AND' || pv_nl ||
1152: ' EXISTS' || pv_nl ||

Line 1155: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

1151: ' (glb.currency_type IN (''T'', ''O'') AND' || pv_nl ||
1152: ' EXISTS' || pv_nl ||
1153: ' (SELECT 1' || pv_nl ||
1154: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
1155: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
1156: ' AND ccy.xlated_currency_code = glb.currency_code)))' || pv_nl;
1157: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN
1158: v_sql_template := v_sql_template ||
1159: 'AND glb.currency_type IN (''U'', ''E'', ''T'', ''O'')' || pv_nl;

Line 1157: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN

1153: ' (SELECT 1' || pv_nl ||
1154: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
1155: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
1156: ' AND ccy.xlated_currency_code = glb.currency_code)))' || pv_nl;
1157: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN
1158: v_sql_template := v_sql_template ||
1159: 'AND glb.currency_type IN (''U'', ''E'', ''T'', ''O'')' || pv_nl;
1160: ELSE -- no translated balances
1161: v_sql_template := v_sql_template ||

Line 1164: ELSIF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'FUNCTIONAL' THEN

1160: ELSE -- no translated balances
1161: v_sql_template := v_sql_template ||
1162: 'AND glb.currency_type IN (''U'', ''E'')' || pv_nl;
1163: END IF;
1164: ELSIF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'FUNCTIONAL' THEN
1165: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
1166: v_sql_template := v_sql_template ||
1167: 'AND (glb.currency_type = ''U'' OR' || pv_nl ||
1168: ' (glb.currency_type IN (''T'', ''O'') AND' || pv_nl ||

Line 1165: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN

1161: v_sql_template := v_sql_template ||
1162: 'AND glb.currency_type IN (''U'', ''E'')' || pv_nl;
1163: END IF;
1164: ELSIF FEM_GL_POST_PROCESS_PKG.pv_curr_option = 'FUNCTIONAL' THEN
1165: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
1166: v_sql_template := v_sql_template ||
1167: 'AND (glb.currency_type = ''U'' OR' || pv_nl ||
1168: ' (glb.currency_type IN (''T'', ''O'') AND' || pv_nl ||
1169: ' EXISTS' || pv_nl ||

Line 1172: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

1168: ' (glb.currency_type IN (''T'', ''O'') AND' || pv_nl ||
1169: ' EXISTS' || pv_nl ||
1170: ' (SELECT 1' || pv_nl ||
1171: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
1172: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
1173: ' AND ccy.xlated_currency_code = glb.currency_code)))' || pv_nl;
1174: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN
1175: v_sql_template := v_sql_template ||
1176: 'AND glb.currency_type IN (''U'', ''T'', ''O'')' || pv_nl;

Line 1174: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN

1170: ' (SELECT 1' || pv_nl ||
1171: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
1172: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
1173: ' AND ccy.xlated_currency_code = glb.currency_code)))' || pv_nl;
1174: ELSIF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'ALL' THEN
1175: v_sql_template := v_sql_template ||
1176: 'AND glb.currency_type IN (''U'', ''T'', ''O'')' || pv_nl;
1177: ELSE -- no translated balances
1178: v_sql_template := v_sql_template ||

Line 1182: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN

1178: v_sql_template := v_sql_template ||
1179: 'AND glb.currency_type = ''U''' || pv_nl;
1180: END IF;
1181: ELSE -- Translated balances only
1182: IF FEM_GL_POST_PROCESS_PKG.pv_xlated_bal_option = 'SPECIFIC' THEN
1183: v_sql_template := v_sql_template ||
1184: 'AND glb.currency_type IN (''T'', ''O'')' || pv_nl ||
1185: 'AND EXISTS' || pv_nl ||
1186: ' (SELECT 1' || pv_nl ||

Line 1188: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||

1184: 'AND glb.currency_type IN (''T'', ''O'')' || pv_nl ||
1185: 'AND EXISTS' || pv_nl ||
1186: ' (SELECT 1' || pv_nl ||
1187: ' FROM FEM_INTG_BAL_DEF_CURRS ccy' || pv_nl ||
1188: ' WHERE ccy.bal_rule_obj_def_id = ' || FEM_GL_POST_PROCESS_PKG.pv_rule_obj_def_id || pv_nl ||
1189: ' AND ccy.xlated_currency_code = glb.currency_code)' || pv_nl;
1190: ELSE -- All translated balances
1191: v_sql_template := v_sql_template ||
1192: 'AND glb.currency_type IN (''T'', ''O'')' || pv_nl;

Line 1321: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code',

1317: p_module => v_module,
1318: p_app_name => 'FEM',
1319: p_msg_name => 'FEM_GL_POST_204',
1320: p_token1 => 'VAR_NAME',
1321: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code',
1322: p_token2 => 'VAR_VAL',
1323: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code);
1324:
1325: INSERT INTO fem_intg_bpi_curr_gt(

Line 1323: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code);

1319: p_msg_name => 'FEM_GL_POST_204',
1320: p_token1 => 'VAR_NAME',
1321: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code',
1322: p_token2 => 'VAR_VAL',
1323: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code);
1324:
1325: INSERT INTO fem_intg_bpi_curr_gt(
1326: dataset_code, cal_period_id, code_combination_id, financial_elem_id,
1327: delta_run_id, xtd_balance_f_sum, qtd_balance_f_sum, ytd_balance_f_sum)

Line 1335: WHERE currency_code <> FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code

1331: SUM(nvl(xtd_balance_f,0)),
1332: SUM(nvl(qtd_balance_f,0)),
1333: SUM(nvl(ytd_balance_f,0))
1334: FROM fem_bal_post_interim_gt
1335: WHERE currency_code <> FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code
1336: AND currency_code <> 'STAT'
1337: AND currency_type_code = 'ENTERED'
1338: AND posting_error_flag = 'N'
1339: GROUP BY dataset_code, cal_period_id, code_combination_id,

Line 1364: WHERE bpi.currency_code = FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code

1360: AND bpi_beq.financial_elem_id = bpi.financial_elem_id
1361: AND ((bpi_beq.delta_run_id IS NULL AND bpi.delta_run_id IS NULL) OR
1362: bpi_beq.delta_run_id = bpi.delta_run_id)
1363: )
1364: WHERE bpi.currency_code = FEM_GL_POST_PROCESS_PKG.pv_func_ccy_code
1365: AND bpi.posting_error_flag = 'N'
1366: AND EXISTS
1367: (SELECT 1
1368: FROM fem_intg_bpi_curr_gt bpi_beq

Line 1436: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_nat_acct_dim_id,

1432:
1433: x_completion_code := 0;
1434:
1435: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id(
1436: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_nat_acct_dim_id,
1437: p_attr_label => 'FINANCIAL_ELEMENT',
1438: x_attr_id => v_na_fe_attr_id,
1439: x_ver_id => v_na_fe_v_id,
1440: x_err_code => v_error_code);

Line 1443: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_nat_acct_dim_id,

1439: x_ver_id => v_na_fe_v_id,
1440: x_err_code => v_error_code);
1441:
1442: FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id(
1443: p_dim_id => FEM_GL_POST_PROCESS_PKG.pv_nat_acct_dim_id,
1444: p_attr_label => 'LINE_ITEM',
1445: x_attr_id => v_na_li_attr_id,
1446: x_ver_id => v_na_li_v_id,
1447: x_err_code => v_error_code);

Line 1527: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN

1523: v_module := 'fem.plsql.fem_intg_bal_eng_load.mark_posted_incr_bal';
1524:
1525: x_completion_code := 0;
1526:
1527: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN
1528: v_actual_flag := 'A';
1529: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN
1530: v_actual_flag := 'B';
1531: ELSE -- Encumbrance

Line 1529: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN

1525: x_completion_code := 0;
1526:
1527: IF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'ACTUAL' THEN
1528: v_actual_flag := 'A';
1529: ELSIF FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd = 'BUDGET' THEN
1530: v_actual_flag := 'B';
1531: ELSE -- Encumbrance
1532: v_actual_flag := 'E';
1533: END IF;

Line 1542: SELECT DISTINCT FEM_GL_POST_PROCESS_PKG.pv_ledger_id,

1538: INSERT INTO GL_TRACK_DELTA_BALANCES(
1539: ledger_id, program_code, period_name, actual_flag,
1540: extract_level_code, currency_type_code, enabled_flag, last_update_date,
1541: last_updated_by, creation_date, created_by, last_update_login)
1542: SELECT DISTINCT FEM_GL_POST_PROCESS_PKG.pv_ledger_id,
1543: 'FEM',
1544: param.period_name,
1545: v_actual_flag,
1546: 'DTL',

Line 1550: FEM_GL_POST_PROCESS_PKG.pv_user_id,

1546: 'DTL',
1547: 'B',
1548: 'Y',
1549: sysdate,
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

Line 1552: FEM_GL_POST_PROCESS_PKG.pv_user_id,

1548: 'Y',
1549: sysdate,
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

Line 1553: FEM_GL_POST_PROCESS_PKG.pv_login_id

1549: sysdate,
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

Line 1560: WHERE tdb.ledger_id = FEM_GL_POST_PROCESS_PKG.pv_ledger_id

1556: AND param.request_id IS NOT NULL
1557: AND NOT EXISTS
1558: (SELECT 1
1559: FROM GL_TRACK_DELTA_BALANCES tdb
1560: WHERE tdb.ledger_id = FEM_GL_POST_PROCESS_PKG.pv_ledger_id
1561: AND tdb.program_code = 'FEM'
1562: AND tdb.period_name = param.period_name
1563: AND tdb.actual_flag = v_actual_flag
1564: AND tdb.extract_level_code = 'DTL'

Line 1579: 'WHERE dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

1575: -- Now, remove rows from FEM_INTG_DELTA_LOADS if previously errored
1576: -- delta runs were successfully loaded
1577: v_delete_stmt :=
1578: 'DELETE FROM FEM_INTG_DELTA_LOADS dl' || pv_nl ||
1579: 'WHERE dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1580: 'AND dl.loaded_flag = ''N''' || pv_nl;
1581:
1582: -- Now, remove rows from FEM_INTG_DELTA_LOADS if previously errored
1583: -- delta runs were successfully loaded

Line 1605: ' AND from_cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name ||

1601: ' GL_CODE_COMBINATIONS from_cc' || pv_nl ||
1602: ' WHERE bpi.delta_run_id = dl.delta_run_id' || pv_nl ||
1603: ' AND bpi.posting_error_flag = ''Y''' || pv_nl ||
1604: ' AND from_cc.code_combination_id = bpi.code_combination_id' || pv_nl ||
1605: ' AND from_cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name ||
1606: ' = dl.balance_seg_value)';
1607:
1608: -- Print the statement
1609: FOR iterator IN 1..trunc((length(v_delete_stmt)+1499)/1500) LOOP

Line 1636: 'SELECT DISTINCT ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||

1632: v_insert_stmt :=
1633: 'INSERT INTO FEM_INTG_DELTA_LOADS(LEDGER_ID, DATASET_CODE, CAL_PERIOD_ID, ' ||
1634: 'DELTA_RUN_ID, BALANCE_SEG_VALUE, LOADED_FLAG, CREATION_DATE, CREATED_BY, ' ||
1635: 'LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)' || pv_nl ||
1636: 'SELECT DISTINCT ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
1637: ' param.output_dataset_code,' || pv_nl ||
1638: ' param.cal_period_id,' || pv_nl ||
1639: ' bpi.delta_run_id,' || pv_nl ||
1640: ' dl.balance_seg_value,' || pv_nl ||

Line 1643: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||

1639: ' bpi.delta_run_id,' || pv_nl ||
1640: ' dl.balance_seg_value,' || pv_nl ||
1641: ' ''N'',' || pv_nl ||
1642: ' sysdate,' || 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 ||

Line 1645: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||

1641: ' ''N'',' || pv_nl ||
1642: ' sysdate,' || 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 ||

Line 1646: ' ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||

1642: ' sysdate,' || 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 ||

Line 1654: 'AND dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

1650: ' FEM_INTG_DELTA_LOADS dl' || pv_nl ||
1651: 'WHERE param.load_method_code = ''I''' || pv_nl ||
1652: 'AND param.error_code IS NULL' || pv_nl ||
1653: 'AND param.request_id IS NOT NULL' || pv_nl ||
1654: 'AND dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1655: 'AND dl.dataset_code = param.output_dataset_code' || pv_nl ||
1656: 'AND dl.cal_period_id = param.cal_period_id' || pv_nl ||
1657: 'AND dl.loaded_flag = ''Y''' || pv_nl;
1658:

Line 1667: 'AND from_cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name ||

1663: END IF;
1664:
1665: v_insert_stmt := v_insert_stmt ||
1666: 'AND from_cc.code_combination_id = bpi.code_combination_id' || pv_nl ||
1667: 'AND from_cc.' || FEM_GL_POST_PROCESS_PKG.pv_bsv_app_col_name ||
1668: ' = dl.balance_seg_value' || pv_nl ||
1669: 'AND bpi.dataset_code = param.output_dataset_code' || pv_nl ||
1670: 'AND bpi.cal_period_id = param.cal_period_id' || pv_nl ||
1671: 'AND bpi.bal_post_type_code = ''A''' || pv_nl ||

Line 1674: FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id;

1670: 'AND bpi.cal_period_id = param.cal_period_id' || pv_nl ||
1671: 'AND bpi.bal_post_type_code = ''A''' || pv_nl ||
1672: 'AND bpi.posting_error_flag = ''Y''' || pv_nl ||
1673: 'AND bpi.delta_run_id BETWEEN dl.delta_run_id + 1 AND ' ||
1674: FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id;
1675:
1676:
1677: -- Print the statement
1678: FOR iterator IN 1..trunc((length(v_insert_stmt)+1499)/1500) LOOP

Line 1710: 'ON (dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ' AND' || 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 ||
1710: 'ON (dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ' AND' || pv_nl ||
1711: ' dl.dataset_code = param.output_dataset_code AND' || pv_nl ||
1712: ' dl.cal_period_id = param.cal_period_id AND' || pv_nl ||
1713: ' dl.balance_seg_value = param.flex_value AND' || pv_nl ||
1714: ' dl.loaded_flag = ''Y'')' || pv_nl ||

Line 1716: ' UPDATE SET dl.delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||

1712: ' dl.cal_period_id = param.cal_period_id AND' || pv_nl ||
1713: ' dl.balance_seg_value = param.flex_value AND' || pv_nl ||
1714: ' dl.loaded_flag = ''Y'')' || pv_nl ||
1715: 'WHEN MATCHED THEN' || pv_nl ||
1716: ' UPDATE SET dl.delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1717: ' dl.last_update_date = sysdate,' || pv_nl ||
1718: ' dl.last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1719: ' dl.last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
1720: 'WHEN NOT MATCHED THEN' || pv_nl ||

Line 1718: ' dl.last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||

1714: ' dl.loaded_flag = ''Y'')' || pv_nl ||
1715: 'WHEN MATCHED THEN' || pv_nl ||
1716: ' UPDATE SET dl.delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1717: ' dl.last_update_date = sysdate,' || pv_nl ||
1718: ' dl.last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1719: ' dl.last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
1720: 'WHEN NOT MATCHED THEN' || pv_nl ||
1721: ' INSERT(LEDGER_ID, DATASET_CODE, CAL_PERIOD_ID, DELTA_RUN_ID, ' ||
1722: 'BALANCE_SEG_VALUE, LOADED_FLAG, CREATION_DATE, CREATED_BY, ' ||

Line 1719: ' dl.last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||

1715: 'WHEN MATCHED THEN' || pv_nl ||
1716: ' UPDATE SET dl.delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1717: ' dl.last_update_date = sysdate,' || pv_nl ||
1718: ' dl.last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1719: ' dl.last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
1720: 'WHEN NOT MATCHED THEN' || pv_nl ||
1721: ' INSERT(LEDGER_ID, DATASET_CODE, CAL_PERIOD_ID, DELTA_RUN_ID, ' ||
1722: 'BALANCE_SEG_VALUE, LOADED_FLAG, CREATION_DATE, CREATED_BY, ' ||
1723: 'LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)' || pv_nl ||

Line 1725: ' (' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||

1721: ' INSERT(LEDGER_ID, DATASET_CODE, CAL_PERIOD_ID, DELTA_RUN_ID, ' ||
1722: 'BALANCE_SEG_VALUE, LOADED_FLAG, CREATION_DATE, CREATED_BY, ' ||
1723: 'LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)' || pv_nl ||
1724: ' VALUES' || pv_nl ||
1725: ' (' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
1726: ' param.output_dataset_code,' || pv_nl ||
1727: ' param.cal_period_id,' || pv_nl ||
1728: ' ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1729: ' param.flex_value,' || pv_nl ||

Line 1728: ' ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||

1724: ' VALUES' || pv_nl ||
1725: ' (' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || ',' || pv_nl ||
1726: ' param.output_dataset_code,' || pv_nl ||
1727: ' param.cal_period_id,' || pv_nl ||
1728: ' ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1729: ' param.flex_value,' || pv_nl ||
1730: ' ''Y'',' || pv_nl ||
1731: ' sysdate,' || pv_nl ||
1732: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||

Line 1732: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||

1728: ' ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1729: ' param.flex_value,' || pv_nl ||
1730: ' ''Y'',' || pv_nl ||
1731: ' sysdate,' || pv_nl ||
1732: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1733: ' sysdate,' || pv_nl ||
1734: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1735: ' ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || ')';
1736:

Line 1734: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||

1730: ' ''Y'',' || pv_nl ||
1731: ' sysdate,' || pv_nl ||
1732: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1733: ' sysdate,' || pv_nl ||
1734: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1735: ' ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || ')';
1736:
1737:
1738: FOR iterator IN 1..trunc((length(v_merge_stmt)+1499)/1500) LOOP

Line 1735: ' ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || ')';

1731: ' sysdate,' || pv_nl ||
1732: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1733: ' sysdate,' || pv_nl ||
1734: ' ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1735: ' ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || ')';
1736:
1737:
1738: FOR iterator IN 1..trunc((length(v_merge_stmt)+1499)/1500) LOOP
1739: FEM_ENGINES_PKG.Tech_Message

Line 1760: 'SET delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||

1756: ' rows into FEM_INTG_DELTA_LOADS');
1757:
1758: v_update_stmt :=
1759: 'UPDATE fem_intg_delta_loads dl' || pv_nl ||
1760: 'SET delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1761: ' last_update_date = sysdate,' || pv_nl ||
1762: ' last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1763: ' last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
1764: 'WHERE dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

Line 1762: ' last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||

1758: v_update_stmt :=
1759: 'UPDATE fem_intg_delta_loads dl' || pv_nl ||
1760: 'SET delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1761: ' last_update_date = sysdate,' || pv_nl ||
1762: ' last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1763: ' last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
1764: 'WHERE dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1765: 'AND dl.loaded_flag = ''Y''' || pv_nl;
1766:

Line 1763: ' last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||

1759: 'UPDATE fem_intg_delta_loads dl' || pv_nl ||
1760: 'SET delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1761: ' last_update_date = sysdate,' || pv_nl ||
1762: ' last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1763: ' last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
1764: 'WHERE dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1765: 'AND dl.loaded_flag = ''Y''' || pv_nl;
1766:
1767: IF p_bsv_range_low IS NOT NULL AND p_bsv_range_high IS NOT NULL THEN

Line 1764: 'WHERE dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||

1760: 'SET delta_run_id = ' || FEM_GL_POST_PROCESS_PKG.pv_max_delta_run_id || ',' || pv_nl ||
1761: ' last_update_date = sysdate,' || pv_nl ||
1762: ' last_updated_by = ' || FEM_GL_POST_PROCESS_PKG.pv_user_id || ',' || pv_nl ||
1763: ' last_update_login = ' || FEM_GL_POST_PROCESS_PKG.pv_login_id || pv_nl ||
1764: 'WHERE dl.ledger_id = ' || FEM_GL_POST_PROCESS_PKG.pv_ledger_id || pv_nl ||
1765: 'AND dl.loaded_flag = ''Y''' || pv_nl;
1766:
1767: IF p_bsv_range_low IS NOT NULL AND p_bsv_range_high IS NOT NULL THEN
1768: v_update_stmt := v_update_stmt ||