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.ENG_CHANGE_ATTR_UTIL dependencies on ENG_PENDING_CHANGE_CTX

Line 345: from ENG_PENDING_CHANGE_CTX

341:
342: SELECT CHANGE_B_TABLE_NAME ,
343: CHANGE_TL_TABLE_NAME
344: INTO l_pending_base_tbl,l_pending_tl_tbl
345: from ENG_PENDING_CHANGE_CTX
346: where CHANGE_ATTRIBUTE_GROUP_TYPE= p_attr_group_type
347: AND APPLICATION_ID = p_application_id;
348:
349: if (FND_PROFILE.value('FND_DIAGNOSTICS')='Y')

Line 545: from ENG_PENDING_CHANGE_CTX

541: BEGIN
542:
543: SELECT CHANGE_B_TABLE_NAME , CHANGE_TL_TABLE_NAME
544: INTO l_pending_base_tbl, l_pending_tl_tbl
545: from ENG_PENDING_CHANGE_CTX
546: where CHANGE_ATTRIBUTE_GROUP_TYPE= p_attr_group_type
547: AND APPLICATION_ID = p_application_id;
548:
549: if (FND_PROFILE.value('FND_DIAGNOSTICS')='Y')

Line 1365: FROM ENG_PENDING_CHANGE_CTX

1361: , CHANGE_VL_TABLE_NAME
1362: INTO l_pending_base_tbl
1363: ,l_pending_tl_tbl
1364: ,l_pending_vl
1365: FROM ENG_PENDING_CHANGE_CTX
1366: WHERE CHANGE_ATTRIBUTE_GROUP_TYPE= p_attr_group_type
1367: AND APPLICATION_ID = p_application_id;
1368:
1369:

Line 2196: from ENG_PENDING_CHANGE_CTX

2192: BEGIN
2193: SELECT CHANGE_B_TABLE_NAME ,
2194: CHANGE_TL_TABLE_NAME
2195: INTO l_pending_base_tbl,l_pending_tl_tbl
2196: from ENG_PENDING_CHANGE_CTX
2197: where CHANGE_ATTRIBUTE_GROUP_TYPE= 'EGO_ITEMMGMT_GROUP'
2198: AND APPLICATION_ID = p_application_id;
2199:
2200: L_B_UPDATE_DML := ' UPDATE '|| l_pending_base_tbl || ' SET EXTENSION_ID=:1';

Line 2543: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2539: )
2540: IS
2541: BEGIN
2542: select change_vo_def_name into x_vo_def
2543: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2544: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2545: and fnd_obj.obj_name = p_object_name
2546: and fnd_appl.application_short_name = p_application_short_name;
2547:

Line 2560: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2556: )
2557: IS
2558: BEGIN
2559: select change_vo_inst_name into x_vo_instance
2560: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2561: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2562: and fnd_obj.obj_name = p_object_name
2563: and fnd_appl.application_short_name = p_application_short_name;
2564:

Line 2577: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2573: )
2574: IS
2575: BEGIN
2576: select change_vo_row_class_name into x_vo_row_class
2577: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2578: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2579: and fnd_obj.obj_name = p_object_name
2580: and fnd_appl.application_short_name = p_application_short_name;
2581:

Line 2594: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2590: )
2591: IS
2592: BEGIN
2593: select change_eo_def_name into x_eo_def
2594: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2595: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2596: and fnd_obj.obj_name = p_object_name
2597: and fnd_appl.application_short_name = p_application_short_name;
2598:

Line 2611: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2607: )
2608: IS
2609: BEGIN
2610: select change_b_table_name into x_base_table
2611: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2612: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2613: and fnd_obj.obj_name = p_object_name
2614: and fnd_appl.application_short_name = p_application_short_name;
2615:

Line 2628: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2624: )
2625: IS
2626: BEGIN
2627: select change_tl_table_name into x_tl_table
2628: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2629: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2630: and fnd_obj.obj_name = p_object_name
2631: and fnd_appl.application_short_name = p_application_short_name;
2632:

Line 2645: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2641: )
2642: IS
2643: BEGIN
2644: select change_vl_table_name into x_vl_name
2645: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2646: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2647: and fnd_obj.obj_name = p_object_name
2648: and fnd_appl.application_short_name = p_application_short_name;
2649:

Line 2657: ,p_context_type IN VARCHAR2 -- column name in the eng_pending_change_ctx table

2653: (
2654: p_change_attr_group_type IN VARCHAR2
2655: ,p_object_name IN VARCHAR2
2656: ,p_application_short_name IN VARCHAR2
2657: ,p_context_type IN VARCHAR2 -- column name in the eng_pending_change_ctx table
2658: ,x_context_value OUT NOCOPY VARCHAR2
2659: )
2660: IS
2661: BEGIN

Line 2666: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2662:
2663: CASE p_context_type
2664: WHEN 'CHANGE_B_TABLE_NAME' THEN
2665: select change_b_table_name into x_context_value
2666: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2667: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2668: and fnd_obj.obj_name = p_object_name
2669: and fnd_appl.application_short_name = p_application_short_name;
2670: WHEN 'CHANGE_TL_TABLE_NAME' THEN

Line 2672: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2668: and fnd_obj.obj_name = p_object_name
2669: and fnd_appl.application_short_name = p_application_short_name;
2670: WHEN 'CHANGE_TL_TABLE_NAME' THEN
2671: select change_tl_table_name into x_context_value
2672: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2673: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2674: and fnd_obj.obj_name = p_object_name
2675: and fnd_appl.application_short_name = p_application_short_name;
2676: WHEN 'CHANGE_VL_TABLE_NAME' THEN

Line 2678: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2674: and fnd_obj.obj_name = p_object_name
2675: and fnd_appl.application_short_name = p_application_short_name;
2676: WHEN 'CHANGE_VL_TABLE_NAME' THEN
2677: select change_vl_table_name into x_context_value
2678: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2679: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2680: and fnd_obj.obj_name = p_object_name
2681: and fnd_appl.application_short_name = p_application_short_name;
2682: WHEN 'CHANGE_VO_DEF_NAME' THEN

Line 2684: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2680: and fnd_obj.obj_name = p_object_name
2681: and fnd_appl.application_short_name = p_application_short_name;
2682: WHEN 'CHANGE_VO_DEF_NAME' THEN
2683: select change_vo_def_name into x_context_value
2684: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2685: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2686: and fnd_obj.obj_name = p_object_name
2687: and fnd_appl.application_short_name = p_application_short_name;
2688: WHEN 'CHANGE_VO_INST_NAME' THEN

Line 2690: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2686: and fnd_obj.obj_name = p_object_name
2687: and fnd_appl.application_short_name = p_application_short_name;
2688: WHEN 'CHANGE_VO_INST_NAME' THEN
2689: select change_vo_inst_name into x_context_value
2690: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2691: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2692: and fnd_obj.obj_name = p_object_name
2693: and fnd_appl.application_short_name = p_application_short_name;
2694: WHEN 'CHANGE_VO_ROW_CLASS_NAME' THEN

Line 2696: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2692: and fnd_obj.obj_name = p_object_name
2693: and fnd_appl.application_short_name = p_application_short_name;
2694: WHEN 'CHANGE_VO_ROW_CLASS_NAME' THEN
2695: select change_vo_row_class_name into x_context_value
2696: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2697: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2698: and fnd_obj.obj_name = p_object_name
2699: and fnd_appl.application_short_name = p_application_short_name;
2700: WHEN 'CHANGE_EO_DEF_NAME' THEN

Line 2702: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl

2698: and fnd_obj.obj_name = p_object_name
2699: and fnd_appl.application_short_name = p_application_short_name;
2700: WHEN 'CHANGE_EO_DEF_NAME' THEN
2701: select change_eo_def_name into x_context_value
2702: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2703: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2704: and fnd_obj.obj_name = p_object_name
2705: and fnd_appl.application_short_name = p_application_short_name;
2706: END CASE;