DBA Data[Home] [Help]

APPS.ENG_CHANGE_ATTR_UTIL dependencies on FND_APPLICATION

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 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;