DBA Data[Home] [Help]

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 1396: FROM ENG_PENDING_CHANGE_CTX

1392: , CHANGE_VL_TABLE_NAME
1393: INTO l_pending_base_tbl
1394: ,l_pending_tl_tbl
1395: ,l_pending_vl
1396: FROM ENG_PENDING_CHANGE_CTX
1397: WHERE CHANGE_ATTRIBUTE_GROUP_TYPE= p_attr_group_type
1398: AND APPLICATION_ID = p_application_id;
1399:
1400:

Line 2227: from ENG_PENDING_CHANGE_CTX

2223: BEGIN
2224: SELECT CHANGE_B_TABLE_NAME ,
2225: CHANGE_TL_TABLE_NAME
2226: INTO l_pending_base_tbl,l_pending_tl_tbl
2227: from ENG_PENDING_CHANGE_CTX
2228: where CHANGE_ATTRIBUTE_GROUP_TYPE= 'EGO_ITEMMGMT_GROUP'
2229: AND APPLICATION_ID = p_application_id;
2230:
2231: L_B_UPDATE_DML := ' UPDATE '|| l_pending_base_tbl || ' SET EXTENSION_ID=:1';

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

2570: )
2571: IS
2572: BEGIN
2573: select change_vo_def_name into x_vo_def
2574: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2575: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2576: and fnd_obj.obj_name = p_object_name
2577: and fnd_appl.application_short_name = p_application_short_name;
2578:

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

2587: )
2588: IS
2589: BEGIN
2590: select change_vo_inst_name into x_vo_instance
2591: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2592: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2593: and fnd_obj.obj_name = p_object_name
2594: and fnd_appl.application_short_name = p_application_short_name;
2595:

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

2604: )
2605: IS
2606: BEGIN
2607: select change_vo_row_class_name into x_vo_row_class
2608: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2609: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2610: and fnd_obj.obj_name = p_object_name
2611: and fnd_appl.application_short_name = p_application_short_name;
2612:

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

2621: )
2622: IS
2623: BEGIN
2624: select change_eo_def_name into x_eo_def
2625: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2626: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2627: and fnd_obj.obj_name = p_object_name
2628: and fnd_appl.application_short_name = p_application_short_name;
2629:

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

2638: )
2639: IS
2640: BEGIN
2641: select change_b_table_name into x_base_table
2642: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2643: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2644: and fnd_obj.obj_name = p_object_name
2645: and fnd_appl.application_short_name = p_application_short_name;
2646:

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

2655: )
2656: IS
2657: BEGIN
2658: select change_tl_table_name into x_tl_table
2659: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2660: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2661: and fnd_obj.obj_name = p_object_name
2662: and fnd_appl.application_short_name = p_application_short_name;
2663:

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

2672: )
2673: IS
2674: BEGIN
2675: select change_vl_table_name into x_vl_name
2676: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2677: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2678: and fnd_obj.obj_name = p_object_name
2679: and fnd_appl.application_short_name = p_application_short_name;
2680:

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

2684: (
2685: p_change_attr_group_type IN VARCHAR2
2686: ,p_object_name IN VARCHAR2
2687: ,p_application_short_name IN VARCHAR2
2688: ,p_context_type IN VARCHAR2 -- column name in the eng_pending_change_ctx table
2689: ,x_context_value OUT NOCOPY VARCHAR2
2690: )
2691: IS
2692: BEGIN

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

2693:
2694: CASE p_context_type
2695: WHEN 'CHANGE_B_TABLE_NAME' THEN
2696: select change_b_table_name into x_context_value
2697: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2698: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2699: and fnd_obj.obj_name = p_object_name
2700: and fnd_appl.application_short_name = p_application_short_name;
2701: WHEN 'CHANGE_TL_TABLE_NAME' THEN

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

2699: and fnd_obj.obj_name = p_object_name
2700: and fnd_appl.application_short_name = p_application_short_name;
2701: WHEN 'CHANGE_TL_TABLE_NAME' THEN
2702: select change_tl_table_name into x_context_value
2703: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2704: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2705: and fnd_obj.obj_name = p_object_name
2706: and fnd_appl.application_short_name = p_application_short_name;
2707: WHEN 'CHANGE_VL_TABLE_NAME' THEN

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

2705: and fnd_obj.obj_name = p_object_name
2706: and fnd_appl.application_short_name = p_application_short_name;
2707: WHEN 'CHANGE_VL_TABLE_NAME' THEN
2708: select change_vl_table_name into x_context_value
2709: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2710: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2711: and fnd_obj.obj_name = p_object_name
2712: and fnd_appl.application_short_name = p_application_short_name;
2713: WHEN 'CHANGE_VO_DEF_NAME' THEN

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

2711: and fnd_obj.obj_name = p_object_name
2712: and fnd_appl.application_short_name = p_application_short_name;
2713: WHEN 'CHANGE_VO_DEF_NAME' THEN
2714: select change_vo_def_name into x_context_value
2715: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2716: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2717: and fnd_obj.obj_name = p_object_name
2718: and fnd_appl.application_short_name = p_application_short_name;
2719: WHEN 'CHANGE_VO_INST_NAME' THEN

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

2717: and fnd_obj.obj_name = p_object_name
2718: and fnd_appl.application_short_name = p_application_short_name;
2719: WHEN 'CHANGE_VO_INST_NAME' THEN
2720: select change_vo_inst_name into x_context_value
2721: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2722: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2723: and fnd_obj.obj_name = p_object_name
2724: and fnd_appl.application_short_name = p_application_short_name;
2725: WHEN 'CHANGE_VO_ROW_CLASS_NAME' THEN

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

2723: and fnd_obj.obj_name = p_object_name
2724: and fnd_appl.application_short_name = p_application_short_name;
2725: WHEN 'CHANGE_VO_ROW_CLASS_NAME' THEN
2726: select change_vo_row_class_name into x_context_value
2727: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2728: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2729: and fnd_obj.obj_name = p_object_name
2730: and fnd_appl.application_short_name = p_application_short_name;
2731: WHEN 'CHANGE_EO_DEF_NAME' THEN

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

2729: and fnd_obj.obj_name = p_object_name
2730: and fnd_appl.application_short_name = p_application_short_name;
2731: WHEN 'CHANGE_EO_DEF_NAME' THEN
2732: select change_eo_def_name into x_context_value
2733: from eng_pending_change_ctx pc_ctx, fnd_objects fnd_obj, fnd_application fnd_appl
2734: where pc_ctx.change_attribute_group_type = p_change_attr_group_type
2735: and fnd_obj.obj_name = p_object_name
2736: and fnd_appl.application_short_name = p_application_short_name;
2737: END CASE;