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.GCS_CONS_ENG_UTILITY_PKG dependencies on GCS_CONS_ENG_UTILITY_PKG

Line 1: PACKAGE BODY GCS_CONS_ENG_UTILITY_PKG as

1: PACKAGE BODY GCS_CONS_ENG_UTILITY_PKG as
2: /* $Header: gcs_eng_utilb.pls 120.15 2007/09/27 21:47:06 rguerrer noship $ */
3:
4: g_api VARCHAR2(80) := 'gcs.plsql.GCS_CONS_ENG_UTILITY_PKG';
5:

Line 4: g_api VARCHAR2(80) := 'gcs.plsql.GCS_CONS_ENG_UTILITY_PKG';

1: PACKAGE BODY GCS_CONS_ENG_UTILITY_PKG as
2: /* $Header: gcs_eng_utilb.pls 120.15 2007/09/27 21:47:06 rguerrer noship $ */
3:
4: g_api VARCHAR2(80) := 'gcs.plsql.GCS_CONS_ENG_UTILITY_PKG';
5:
6: PROCEDURE get_cons_entity_wf_info (itemtype IN VARCHAR2,
7: itemkey IN VARCHAR2,
8: cons_entity_wf_info IN OUT NOCOPY r_cons_entity_wf_info)

Line 124: p_parameter_list IN OUT NOCOPY gcs_cons_eng_utility_pkg.r_module_parameters,

120:
121: END submit_xml_ntf_program;
122:
123: PROCEDURE execute_module (module_code IN VARCHAR2,
124: p_parameter_list IN OUT NOCOPY gcs_cons_eng_utility_pkg.r_module_parameters,
125: p_item_key IN VARCHAR2)
126:
127: IS PRAGMA AUTONOMOUS_TRANSACTION;
128:

Line 381: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;

377: l_curr_category_num NUMBER(15);
378: l_rows_to_process VARCHAR2(1) := 'Y';
379: l_xlate_flag VARCHAR2(1) := 'N';
380: l_entry_id NUMBER(15);
381: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
382:
383: BEGIN
384: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
385: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.BALANCES_PROCESSOR.begin', '<>');

Line 399: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

395: END IF;
396:
397: IF (itemtype = 'GCSOPRWF') THEN
398:
399: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
400: itemkey,
401: cons_entity_wf_info,
402: oper_entity_wf_info);
403:

Line 435: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info (itemtype,

431: END IF;
432:
433: ELSIF (itemtype = 'GCSENGNE') THEN
434:
435: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info (itemtype,
436: itemkey,
437: cons_entity_wf_info);
438:
439: IF (cons_entity_wf_info.prior_run_identifier <> 'NO_PRIOR_RUN') THEN

Line 509: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;

505: oper_entity_wf_info r_oper_entity_wf_info;
506: l_category_count NUMBER(15);
507: l_change_in_data VARCHAR2(1);
508: l_child_entity_id NUMBER(15);
509: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
510: BEGIN
511:
512: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
513: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED.begin', '<>');

Line 518: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

514: END IF;
515:
516:
517: IF (itemtype = 'GCSOPRWF') THEN
518: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
519: itemkey,
520: cons_entity_wf_info,
521: oper_entity_wf_info);
522: l_category_count := gcs_categories_pkg.g_oper_category_info.COUNT;

Line 528: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,

524: l_parameter_list.undo_entity_id := l_child_entity_id;
525: l_parameter_list.undo_entity_type := 'O';
526:
527: ELSE
528: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,
529: itemkey,
530: cons_entity_wf_info);
531: l_category_count := gcs_categories_pkg.g_cons_category_info.COUNT;
532: l_child_entity_id := cons_entity_wf_info.consolidation_entity;

Line 703: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;

699:
700: l_category_code VARCHAR2(30);
701: l_curr_category_number NUMBER(15);
702: l_entity_id NUMBER(15);
703: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
704: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
705: l_entry_id NUMBER(15);
706: l_stat_entry_id NUMBER(15);
707: x_errbuf VARCHAR2(200);

Line 704: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;

700: l_category_code VARCHAR2(30);
701: l_curr_category_number NUMBER(15);
702: l_entity_id NUMBER(15);
703: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
704: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
705: l_entry_id NUMBER(15);
706: l_stat_entry_id NUMBER(15);
707: x_errbuf VARCHAR2(200);
708: x_retcode VARCHAR2(200);

Line 783: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

779:
780: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
781:
782: IF (itemtype = 'GCSOPRWF') THEN
783: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
784: itemkey,
785: cons_entity_wf_info,
786: oper_entity_wf_info);
787: l_entity_id := oper_entity_wf_info.operating_entity;

Line 790: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,

786: oper_entity_wf_info);
787: l_entity_id := oper_entity_wf_info.operating_entity;
788: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_number).category_code;
789: ELSE
790: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,
791: itemkey,
792: cons_entity_wf_info);
793: l_category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_number).category_code;
794: l_entity_id := cons_entity_wf_info.consolidation_entity;

Line 902: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;

898: result IN OUT NOCOPY varchar2)
899:
900: IS
901:
902: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
903: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
904: l_translation_required VARCHAR2(1);
905: l_xlate_mode VARCHAR2(30);
906: l_rate_change_occurred VARCHAR2(1);

Line 903: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;

899:
900: IS
901:
902: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
903: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
904: l_translation_required VARCHAR2(1);
905: l_xlate_mode VARCHAR2(30);
906: l_rate_change_occurred VARCHAR2(1);
907:

Line 914: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

910: l_translation_required := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'TRANSLATION_REQUIRED', FALSE);
911: l_xlate_mode := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'TRANSLATION_MODE', FALSE);
912:
913: IF (itemtype = 'GCSOPRWF') THEN
914: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
915: itemkey,
916: cons_entity_wf_info,
917: oper_entity_wf_info);
918: ELSE

Line 919: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,

915: itemkey,
916: cons_entity_wf_info,
917: oper_entity_wf_info);
918: ELSE
919: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,
920: itemkey,
921: cons_entity_wf_info);
922: END IF;
923:

Line 952: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;

948: x_errbuf VARCHAR2(2000);
949: x_retcode VARCHAR2(2000);
950: l_execution_mode VARCHAR2(30);
951: l_balance_type_code VARCHAR2(30);
952: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
953: l_curr_category_number NUMBER(15);
954: l_category_code VARCHAR2(30);
955:
956: -- Bugfix 3972840 : Remove code to translate adjustment entries

Line 967: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

963: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_TRANSLATION.begin', '<>');
964: END IF;
965:
966: IF (itemtype = 'GCSOPRWF') THEN
967: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
968: itemkey,
969: cons_entity_wf_info,
970: oper_entity_wf_info);
971:

Line 975: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,

971:
972: l_child_entity_id := oper_entity_wf_info.operating_entity;
973:
974: ELSE
975: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,
976: itemkey,
977: cons_entity_wf_info);
978:
979: l_child_entity_id := cons_entity_wf_info.consolidation_entity;

Line 1059: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;

1055: IS
1056: l_category_code VARCHAR2(30);
1057: l_curr_category_num NUMBER(15);
1058: l_status_code VARCHAR2(30);
1059: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
1060: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
1061:
1062: BEGIN
1063: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1060: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;

1056: l_category_code VARCHAR2(30);
1057: l_curr_category_num NUMBER(15);
1058: l_status_code VARCHAR2(30);
1059: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
1060: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
1061:
1062: BEGIN
1063: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1064: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PROCESS_STATUS.begin', '<>');

Line 1068: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

1064: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PROCESS_STATUS.begin', '<>');
1065: END IF;
1066:
1067: IF (itemtype = 'GCSOPRWF') THEN
1068: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
1069: itemkey,
1070: cons_entity_wf_info,
1071: oper_entity_wf_info);
1072: ELSE

Line 1073: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,

1069: itemkey,
1070: cons_entity_wf_info,
1071: oper_entity_wf_info);
1072: ELSE
1073: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,
1074: itemkey,
1075: cons_entity_wf_info);
1076: END IF;
1077:

Line 1129: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;

1125: result IN OUT NOCOPY varchar2)
1126:
1127: IS
1128:
1129: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
1130: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
1131: x_retcode VARCHAR2(2000);
1132: x_errbuf VARCHAR2(200);
1133: l_curr_category_num NUMBER(15);

Line 1130: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;

1126:
1127: IS
1128:
1129: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
1130: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
1131: x_retcode VARCHAR2(2000);
1132: x_errbuf VARCHAR2(200);
1133: l_curr_category_num NUMBER(15);
1134: l_category_code VARCHAR2(30);

Line 1138: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;

1134: l_category_code VARCHAR2(30);
1135: l_currency_code VARCHAR2(30);
1136: l_entity_id NUMBER;
1137: l_elim_mode VARCHAR2(2);
1138: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
1139: l_run_detail_id NUMBER(15);
1140: l_tgt_entity_id NUMBER(15);
1141: l_elim_entity_attr NUMBER(15) :=
1142: gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;

Line 1269: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

1265: END IF;
1266: l_curr_category_num := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
1267:
1268: IF (itemtype = 'GCSOPRWF') THEN
1269: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
1270: itemkey,
1271: cons_entity_wf_info,
1272: oper_entity_wf_info);
1273:

Line 1278: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,

1274: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;
1275: l_entity_id := oper_entity_wf_info.operating_entity;
1276:
1277: ELSE
1278: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,
1279: itemkey,
1280: cons_entity_wf_info);
1281: l_category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_num).category_code;
1282: l_entity_id := cons_entity_wf_info.consolidation_entity;

Line 1538: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;

1534: result IN OUT NOCOPY varchar2)
1535:
1536:
1537: IS
1538: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
1539: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
1540: x_retcode VARCHAR2(2000);
1541: x_errbuf VARCHAR2(200);
1542: l_entity_id NUMBER;

Line 1539: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;

1535:
1536:
1537: IS
1538: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
1539: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
1540: x_retcode VARCHAR2(2000);
1541: x_errbuf VARCHAR2(200);
1542: l_entity_id NUMBER;
1543: l_init_required VARCHAR2(1);

Line 1544: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;

1540: x_retcode VARCHAR2(2000);
1541: x_errbuf VARCHAR2(200);
1542: l_entity_id NUMBER;
1543: l_init_required VARCHAR2(1);
1544: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
1545:
1546: BEGIN
1547:
1548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1553: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,

1549: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_INITIALIZING_JOURNAL.begin', '<>');
1550: END IF;
1551:
1552: IF (itemtype = 'GCSOPRWF') THEN
1553: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
1554: itemkey,
1555: cons_entity_wf_info,
1556: oper_entity_wf_info);
1557:

Line 1574: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,

1570: AND ROWNUM < 2;
1571:
1572:
1573: ELSE
1574: gcs_cons_eng_utility_pkg.get_cons_entity_wf_info(itemtype,
1575: itemkey,
1576: cons_entity_wf_info);
1577: l_parameter_list.bp_post_xlate := 'N';
1578:

Line 1628: END GCS_CONS_ENG_UTILITY_PKG;

1624: WHEN OTHERS THEN
1625: result := 'COMPLETE';
1626: END create_initializing_journal;
1627:
1628: END GCS_CONS_ENG_UTILITY_PKG;
1629: