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.

[Home] [Help]

APPS.GCS_DATASUB_UTILITY_PKG dependencies on GCS_BAL_INTERFACE_T

Line 46: UPDATE gcs_bal_interface_t gbit

42: 'Currency Code : ' || p_currency_code );
43:
44: END IF;
45:
46: UPDATE gcs_bal_interface_t gbit
47: SET (ytd_debit_balance_e,
48: ytd_credit_balance_e,
49: ytd_balance_e,
50: ytd_balance_f) = (

Line 119: UPDATE gcs_bal_interface_t gbit

115: 'Currency Code : ' || p_currency_code );
116:
117: END IF;
118:
119: UPDATE gcs_bal_interface_t gbit
120: SET (ptd_debit_balance_e,
121: ptd_credit_balance_e,
122: ptd_balance_e,
123: ptd_balance_f) = (

Line 213: UPDATE gcs_bal_interface_t gbit

209: 'Currency Code : ' || p_currency_code );
210:
211: END IF;
212:
213: UPDATE gcs_bal_interface_t gbit
214: SET (ptd_debit_balance_e,
215: ptd_credit_balance_e,
216: ptd_balance_e,
217: ptd_balance_f) = (

Line 293: gcs_bal_interface_t

289: END IF;
290:
291:
292: UPDATE
293: gcs_bal_interface_t
294: SET error_message_code = NULL
295: WHERE load_id = p_load_id;
296:
297: SELECT fea.dim_attribute_numeric_member

Line 343: UPDATE gcs_bal_interface_t gbit

339: l_null_err_msg := FND_MESSAGE.get ;
340: l_dim_id_col := l_dim_vs_info(l_counter).dim_id_col ;
341:
342: IF ( l_dim_id_col = 'COMPANY_COST_CENTER_ORG_ID' ) THEN
343: UPDATE gcs_bal_interface_t gbit
344: SET error_message_code = error_message_code
345: || DECODE ( cctr_org_display_code, NULL , l_null_err_msg ,
346: l_invalid_err_msg || '(' || cctr_org_display_code || ').' )
347: WHERE load_id = p_load_id

Line 353: UPDATE gcs_bal_interface_t gbit

349: FROM fem_cctr_orgs_b fcob
350: WHERE fcob.cctr_org_display_code = gbit.cctr_org_display_code
351: AND fcob.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
352: ELSIF ( l_dim_id_col = 'FINANCIAL_ELEM_ID' ) THEN
353: UPDATE gcs_bal_interface_t gbit
354: SET error_message_code = error_message_code
355: || DECODE ( financial_elem_display_code, NULL , l_null_err_msg ,
356: l_invalid_err_msg || '(' || financial_elem_display_code || ').' )
357: WHERE load_id = p_load_id

Line 363: UPDATE gcs_bal_interface_t gbit

359: FROM fem_fin_elems_b ffeb
360: WHERE ffeb.financial_elem_display_code = gbit.financial_elem_display_code
361: AND ffeb.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
362: ELSIF ( l_dim_id_col = 'LINE_ITEM_ID' ) THEN
363: UPDATE gcs_bal_interface_t gbit
364: SET error_message_code = error_message_code
365: || DECODE ( line_item_display_code, NULL , l_null_err_msg ,
366: l_invalid_err_msg || '(' || line_item_display_code || ').' )
367: WHERE load_id = p_load_id

Line 373: UPDATE gcs_bal_interface_t gbit

369: FROM fem_ln_items_b flib
370: WHERE flib.line_item_display_code = gbit.line_item_display_code
371: AND flib.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
372: ELSIF ( l_dim_id_col = 'PRODUCT_ID') THEN
373: UPDATE gcs_bal_interface_t gbit
374: SET error_message_code = error_message_code
375: || DECODE ( product_display_code, NULL , l_null_err_msg ,
376: l_invalid_err_msg || '(' || product_display_code || ').' )
377: WHERE load_id = p_load_id

Line 383: UPDATE gcs_bal_interface_t gbit

379: FROM fem_products_b fpb
380: WHERE fpb.product_display_code = gbit.product_display_code
381: AND fpb.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
382: ELSIF ( l_dim_id_col = 'NATURAL_ACCOUNT_ID' ) THEN
383: UPDATE gcs_bal_interface_t gbit
384: SET error_message_code = error_message_code
385: || DECODE ( natural_account_display_code, NULL , l_null_err_msg ,
386: l_invalid_err_msg || '(' || natural_account_display_code || ').' )
387: WHERE load_id = p_load_id

Line 393: UPDATE gcs_bal_interface_t gbit

389: FROM fem_nat_accts_b fnab
390: WHERE fnab.natural_account_display_code = gbit.natural_account_display_code
391: AND fnab.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
392: ELSIF ( l_dim_id_col = 'CHANNEL_ID') THEN
393: UPDATE gcs_bal_interface_t gbit
394: SET error_message_code = error_message_code
395: || DECODE ( channel_display_code, NULL , l_null_err_msg ,
396: l_invalid_err_msg || '(' || channel_display_code || ').' )
397: WHERE load_id = p_load_id

Line 403: UPDATE gcs_bal_interface_t gbit

399: FROM fem_channels_b fcb
400: WHERE fcb.channel_display_code = gbit.channel_display_code
401: AND fcb.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
402: ELSIF ( l_dim_id_col = 'PROJECT_ID') THEN
403: UPDATE gcs_bal_interface_t gbit
404: SET error_message_code = error_message_code
405: || DECODE ( project_display_code, NULL , l_null_err_msg ,
406: l_invalid_err_msg || '(' || project_display_code || ').' )
407: WHERE load_id = p_load_id

Line 413: UPDATE gcs_bal_interface_t gbit

409: FROM fem_projects_b fpb
410: WHERE fpb.project_display_code = gbit.project_display_code
411: AND fpb.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
412: ELSIF ( l_dim_id_col = 'CUSTOMER_ID' ) THEN
413: UPDATE gcs_bal_interface_t gbit
414: SET error_message_code = error_message_code
415: || DECODE ( customer_display_code, NULL , l_null_err_msg ,
416: l_invalid_err_msg || '(' || customer_display_code || ').' )
417: WHERE load_id = p_load_id

Line 423: UPDATE gcs_bal_interface_t gbit

419: FROM fem_customers_b fcb
420: WHERE fcb.customer_display_code = gbit.customer_display_code
421: AND fcb.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
422: ELSIF ( l_dim_id_col = 'TASK_ID') THEN
423: UPDATE gcs_bal_interface_t gbit
424: SET error_message_code = error_message_code
425: || DECODE ( task_display_code, NULL , l_null_err_msg ,
426: l_invalid_err_msg || '(' || task_display_code || ').' )
427: WHERE load_id = p_load_id

Line 433: UPDATE gcs_bal_interface_t gbit

429: FROM fem_tasks_b ftb
430: WHERE ftb.task_display_code = gbit.task_display_code
431: AND ftb.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
432: ELSIF ( l_dim_id_col = 'USER_DIM1_ID' ) THEN
433: UPDATE gcs_bal_interface_t gbit
434: SET error_message_code = error_message_code
435: || DECODE ( user_dim1_display_code, NULL , l_null_err_msg ,
436: l_invalid_err_msg || '(' || user_dim1_display_code || ').' )
437: WHERE load_id = p_load_id

Line 443: UPDATE gcs_bal_interface_t gbit

439: FROM fem_user_dim1_b fub
440: WHERE fub.user_dim1_display_code = gbit.user_dim1_display_code
441: AND fub.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
442: ELSIF ( l_dim_id_col = 'USER_DIM2_ID' ) THEN
443: UPDATE gcs_bal_interface_t gbit
444: SET error_message_code = error_message_code
445: || DECODE ( user_dim2_display_code, NULL , l_null_err_msg ,
446: l_invalid_err_msg || '(' || user_dim2_display_code || ').' )
447: WHERE load_id = p_load_id

Line 453: UPDATE gcs_bal_interface_t gbit

449: FROM fem_user_dim2_b fub
450: WHERE fub.user_dim2_display_code = gbit.user_dim2_display_code
451: AND fub.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
452: ELSIF ( l_dim_id_col = 'USER_DIM3_ID' ) THEN
453: UPDATE gcs_bal_interface_t gbit
454: SET error_message_code = error_message_code
455: || DECODE ( user_dim3_display_code, NULL , l_null_err_msg ,
456: l_invalid_err_msg || '(' || user_dim3_display_code || ').' )
457: WHERE load_id = p_load_id

Line 463: UPDATE gcs_bal_interface_t gbit

459: FROM fem_user_dim3_b fub
460: WHERE fub.user_dim3_display_code = gbit.user_dim3_display_code
461: AND fub.value_set_id =l_dim_vs_info(l_counter).vs_id ) ;
462: ELSIF ( l_dim_id_col = 'USER_DIM4_ID' ) THEN
463: UPDATE gcs_bal_interface_t gbit
464: SET error_message_code = error_message_code
465: || DECODE ( user_dim4_display_code, NULL , l_null_err_msg ,
466: l_invalid_err_msg || '(' || user_dim4_display_code || ').' )
467: WHERE load_id = p_load_id

Line 473: UPDATE gcs_bal_interface_t gbit

469: FROM fem_user_dim4_b fub
470: WHERE fub.user_dim4_display_code = gbit.user_dim4_display_code
471: AND fub.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
472: ELSIF ( l_dim_id_col = 'USER_DIM5_ID' ) THEN
473: UPDATE gcs_bal_interface_t gbit
474: SET error_message_code = error_message_code
475: || DECODE ( user_dim5_display_code, NULL , l_null_err_msg ,
476: l_invalid_err_msg || '(' || user_dim5_display_code || ').' )
477: WHERE load_id = p_load_id

Line 483: UPDATE gcs_bal_interface_t gbit

479: FROM fem_user_dim5_b fub
480: WHERE fub.user_dim5_display_code = gbit.user_dim5_display_code
481: AND fub.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
482: ELSIF ( l_dim_id_col = 'USER_DIM6_ID' ) THEN
483: UPDATE gcs_bal_interface_t gbit
484: SET error_message_code = error_message_code
485: || DECODE ( user_dim6_display_code, NULL , l_null_err_msg ,
486: l_invalid_err_msg || '(' || user_dim6_display_code || ').' )
487: WHERE load_id = p_load_id

Line 493: UPDATE gcs_bal_interface_t gbit

489: FROM fem_user_dim6_b fub
490: WHERE fub.user_dim6_display_code = gbit.user_dim6_display_code
491: AND fub.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
492: ELSIF ( l_dim_id_col = 'USER_DIM7_ID' ) THEN
493: UPDATE gcs_bal_interface_t gbit
494: SET error_message_code = error_message_code
495: || DECODE ( user_dim7_display_code, NULL , l_null_err_msg ,
496: l_invalid_err_msg || '(' || user_dim7_display_code || ').' )
497: WHERE load_id = p_load_id

Line 503: UPDATE gcs_bal_interface_t gbit

499: FROM fem_user_dim7_b fub
500: WHERE fub.user_dim7_display_code = gbit.user_dim7_display_code
501: AND fub.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
502: ELSIF ( l_dim_id_col = 'USER_DIM8_ID' ) THEN
503: UPDATE gcs_bal_interface_t gbit
504: SET error_message_code = error_message_code
505: || DECODE ( user_dim8_display_code, NULL , l_null_err_msg ,
506: l_invalid_err_msg || '(' || user_dim8_display_code || ').' )
507: WHERE load_id = p_load_id

Line 513: UPDATE gcs_bal_interface_t gbit

509: FROM fem_user_dim8_b fub
510: WHERE fub.user_dim8_display_code = gbit.user_dim8_display_code
511: AND fub.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
512: ELSIF ( l_dim_id_col = 'USER_DIM9_ID' ) THEN
513: UPDATE gcs_bal_interface_t gbit
514: SET error_message_code = error_message_code
515: || DECODE ( user_dim9_display_code, NULL , l_null_err_msg ,
516: l_invalid_err_msg || '(' || user_dim9_display_code || ').' )
517: WHERE load_id = p_load_id

Line 523: UPDATE gcs_bal_interface_t gbit

519: FROM fem_user_dim9_b fub
520: WHERE fub.user_dim9_display_code = gbit.user_dim9_display_code
521: AND fub.value_set_id = l_dim_vs_info(l_counter).vs_id ) ;
522: ELSIF ( l_dim_id_col = 'USER_DIM10_ID' ) THEN
523: UPDATE gcs_bal_interface_t gbit
524: SET error_message_code = error_message_code
525: || DECODE ( user_dim10_display_code, NULL , l_null_err_msg ,
526: l_invalid_err_msg || '(' || user_dim10_display_code || ').' )
527: WHERE load_id = p_load_id