DBA Data[Home] [Help]

APPS.ENG_CHANGE_ATTR_UTIL dependencies on FND_APPLICATION

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