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_CONS_ENG_UTILITY_PKG dependencies on GCS_CATEGORIES_PKG

Line 421: l_parameter_list.category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;

417: l_parameter_list.entry_id := oper_entity_wf_info.xlate_entry_id;
418: ELSIF (l_parameter_list.category_code = 'ADJUSTMENT') THEN
419: l_curr_category_num := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
420: l_parameter_list.child_entity_id := oper_entity_wf_info.operating_entity;
421: l_parameter_list.category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;
422: l_parameter_list.bp_undo_prior := 'N';
423:
424: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
425: INTO l_rows_to_process

Line 455: l_parameter_list.category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_num).category_code;

451:
452: ELSIF (l_parameter_list.category_code = 'ADJUSTMENT') THEN
453:
454: l_curr_category_num := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
455: l_parameter_list.category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_num).category_code;
456: l_parameter_list.bp_undo_prior := 'N';
457:
458: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
459: INTO l_rows_to_process

Line 522: l_category_count := gcs_categories_pkg.g_oper_category_info.COUNT;

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;
523: l_child_entity_id := oper_entity_wf_info.operating_entity;
524: l_parameter_list.undo_entity_id := l_child_entity_id;
525: l_parameter_list.undo_entity_type := 'O';
526:

Line 531: l_category_count := gcs_categories_pkg.g_cons_category_info.COUNT;

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;
533: l_parameter_list.undo_entity_id := cons_entity_wf_info.consolidation_entity;
534: l_parameter_list.undo_entity_type := 'E';
535: END IF;

Line 788: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_number).category_code;

784: itemkey,
785: cons_entity_wf_info,
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);

Line 793: l_category_code := gcs_categories_pkg.g_cons_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;
795:
796: -- Bugfix 3870959 : Extract Appropriate Entity based off of Target Entity Code
797: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_number).target_entity_code = 'ELIMINATION') THEN

Line 797: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_number).target_entity_code = 'ELIMINATION') THEN

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;
795:
796: -- Bugfix 3870959 : Extract Appropriate Entity based off of Target Entity Code
797: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_number).target_entity_code = 'ELIMINATION') THEN
798: SELECT fea.dim_attribute_numeric_member
799: INTO l_entity_id
800: FROM fem_entities_attr fea
801: WHERE fea.entity_id = cons_entity_wf_info.consolidation_entity

Line 1100: l_category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_num).category_code;

1096: (itemtype = 'GCSOPRWF' AND l_status_code = 'IN_PROGRESS')) THEN
1097:
1098: l_curr_category_num := WF_Engine.GetItemAttrText(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
1099: IF (itemtype = 'GCSENGNE') THEN
1100: l_category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_num).category_code;
1101: ELSE
1102: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;
1103: END IF;
1104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1102: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;

1098: l_curr_category_num := WF_Engine.GetItemAttrText(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
1099: IF (itemtype = 'GCSENGNE') THEN
1100: l_category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_num).category_code;
1101: ELSE
1102: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;
1103: END IF;
1104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1105: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Actual Category Code : ' || l_category_code);
1106: END IF;

Line 1274: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;

1270: itemkey,
1271: cons_entity_wf_info,
1272: oper_entity_wf_info);
1273:
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,

Line 1281: l_category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_num).category_code;

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;
1283:
1284: END IF;
1285:

Line 1472: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_num).support_multi_parents_flag = 'Y' ) THEN

1468: END;
1469: END LOOP;
1470:
1471: --Bugfix 4122843: Special Code to Handle Multiple Parent Entries
1472: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_num).support_multi_parents_flag = 'Y' ) THEN
1473: BEGIN
1474: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_num).target_entity_code = 'ELIMINATION') THEN
1475: SELECT dim_attribute_numeric_member
1476: INTO l_tgt_entity_id

Line 1474: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_num).target_entity_code = 'ELIMINATION') THEN

1470:
1471: --Bugfix 4122843: Special Code to Handle Multiple Parent Entries
1472: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_num).support_multi_parents_flag = 'Y' ) THEN
1473: BEGIN
1474: IF (gcs_categories_pkg.g_cons_category_info(l_curr_category_num).target_entity_code = 'ELIMINATION') THEN
1475: SELECT dim_attribute_numeric_member
1476: INTO l_tgt_entity_id
1477: FROM fem_entities_attr
1478: WHERE entity_id = cons_entity_wf_info.consolidation_entity