DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on FND_FLEX_DSC_API

Line 2638: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');

2634: p_application_column_name VARCHAR2(240);
2635: p_application_id VARCHAR2(30);
2636: BEGIN
2637:
2638: FND_FLEX_DSC_API.SET_SESSION_MODE('customer_data');
2639:
2640: FND_PROFILE.PUT('RESP_APPL_ID','0');
2641: FND_PROFILE.PUT('RESP_ID','20419');
2642: FND_PROFILE.PUT('USER_ID','1001');

Line 2647: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,

2643:
2644: -- Delete all the segments under the New Global Data Elements Context(if any)
2645:
2646: --dbms_output.put_line ('Before even starting the process');
2647: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,
2648: P_NEW_FLEXFIELD_NAME )) THEN
2649: --dbms_output.put_line ('Entered the Processing');
2650: IF (P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN
2651: -- Get the New Global Data Elements Context and Its Segments

Line 2675: FND_FLEX_DSC_API.DELETE_SEGMENT( P_NEW_PRODUCT

2671: IF (NEW_GDE_SEGMENTS.NSEGMENTS > 0) THEN
2672: --dbms_output.put_line('New GDE has segments');
2673: FOR I IN 1..NEW_GDE_SEGMENTS.NSEGMENTS LOOP
2674: --dbms_output.put_line('Trying to delete segments under old context');
2675: FND_FLEX_DSC_API.DELETE_SEGMENT( P_NEW_PRODUCT
2676: ,P_NEW_FLEXFIELD_NAME
2677: ,OLD_GDE_CONTEXT_CODE -- Global Data Elements
2678: ,NEW_GDE_SEGMENTS.SEGMENT_NAME(I));
2679: END LOOP;

Line 2701: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,

2697: -- Store all the old contexts
2698: GDE_CONTEXTS := L_CONTEXTS;
2699:
2700: -- Check To See If New Flex Structure Exists
2701: IF ( FND_FLEX_DSC_API.FLEXFIELD_EXISTS( P_NEW_PRODUCT,
2702: P_NEW_FLEXFIELD_NAME )) THEN
2703: FOR I IN 1..L_CONTEXTS.NCONTEXTS LOOP
2704: --dbms_output.put_line ( ' Global Code : ' || L_CONTEXTS.CONTEXT_CODE(I));
2705: IF (L_CONTEXTS.CONTEXT_CODE(I) = OLD_GDE_CONTEXT_CODE AND P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN

Line 2709: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT

2705: IF (L_CONTEXTS.CONTEXT_CODE(I) = OLD_GDE_CONTEXT_CODE AND P_NEW_FLEXFIELD_NAME = G_QP_ATTR_DEFNS_PRICING) THEN
2706: --dbms_output.put_line('There are contexts for migration');
2707: IF (check_context_existance(QP_APPLICATION_ID,P_NEW_FLEXFIELD_NAME,NEW_GDE_CONTEXT_CODE) = FALSE) THEN
2708: --dbms_output.put_line ('Creating the Upgrade Context');
2709: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT
2710: , P_NEW_FLEXFIELD_NAME
2711: , NEW_GDE_CONTEXT_CODE
2712: , NEW_GDE_CONTEXT_CODE
2713: , NEW_GDE_CONTEXT_CODE

Line 2722: FND_FLEX_DSC_API.ENABLE_CONTEXT (P_NEW_PRODUCT

2718: NULL;
2719: --dbms_output.put_line ('Upgrade Context Already Exists');
2720: END IF;
2721:
2722: FND_FLEX_DSC_API.ENABLE_CONTEXT (P_NEW_PRODUCT
2723: , P_NEW_FLEXFIELD_NAME
2724: , NEW_GDE_CONTEXT_CODE
2725: , TRUE );
2726:

Line 2727: FND_FLEX_DSC_API.ENABLE_COLUMNS( P_NEW_PRODUCT

2723: , P_NEW_FLEXFIELD_NAME
2724: , NEW_GDE_CONTEXT_CODE
2725: , TRUE );
2726:
2727: FND_FLEX_DSC_API.ENABLE_COLUMNS( P_NEW_PRODUCT
2728: , P_NEW_FLEXFIELD_NAME
2729: , 'ATTRIBUTE[0-9]+');
2730:
2731: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , L_CONTEXTS.CONTEXT_CODE(I))

Line 2792: FND_FLEX_DSC_API.CREATE_SEGMENT (

2788: p_application_id := QP_APPLICATION_ID;
2789:
2790: --dbms_output.put_line ('Creating the Upgrade Context Segments');
2791: BEGIN
2792: FND_FLEX_DSC_API.CREATE_SEGMENT (
2793: APPL_SHORT_NAME => P_NEW_PRODUCT
2794: , FLEXFIELD_NAME => P_NEW_FLEXFIELD_NAME
2795: , CONTEXT_NAME => NEW_GDE_CONTEXT_CODE
2796: , NAME => p_segment_name

Line 2843: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT

2839: --dbms_output.put_line ('Before Other Context Existance Check');
2840: --dbms_output.put_line ('Context Code : ' || L_CONTEXTS.CONTEXT_CODE(I));
2841: IF (check_context_existance(QP_APPLICATION_ID,P_NEW_FLEXFIELD_NAME,L_CONTEXTS.CONTEXT_CODE(I)) = FALSE) THEN
2842: --dbms_output.put_line ('Creating Other Contexts');
2843: FND_FLEX_DSC_API.CREATE_CONTEXT ( P_NEW_PRODUCT
2844: , P_NEW_FLEXFIELD_NAME
2845: , L_CONTEXTS.CONTEXT_CODE(I)
2846: , L_CONTEXTS.CONTEXT_NAME(I)
2847: , L_CONTEXTS.CONTEXT_DESCRIPTION(I)

Line 2853: FND_FLEX_DSC_API.ENABLE_CONTEXT ( P_NEW_PRODUCT

2849: , 'N') ;
2850:
2851: END IF;
2852:
2853: FND_FLEX_DSC_API.ENABLE_CONTEXT ( P_NEW_PRODUCT
2854: , P_NEW_FLEXFIELD_NAME
2855: , L_CONTEXTS.CONTEXT_CODE(I) --2847218 changed to CONTEXT_CODE
2856: , TRUE );
2857:

Line 2858: FND_FLEX_DSC_API.ENABLE_COLUMNS(P_NEW_PRODUCT

2854: , P_NEW_FLEXFIELD_NAME
2855: , L_CONTEXTS.CONTEXT_CODE(I) --2847218 changed to CONTEXT_CODE
2856: , TRUE );
2857:
2858: FND_FLEX_DSC_API.ENABLE_COLUMNS(P_NEW_PRODUCT
2859: , P_NEW_FLEXFIELD_NAME
2860: , 'ATTRIBUTE[0-9]+');
2861:
2862: FND_DFLEX.GET_SEGMENTS ( FND_DFLEX.MAKE_CONTEXT( P_FLEXFIELD , L_CONTEXTS.CONTEXT_CODE(I))

Line 2926: FND_FLEX_DSC_API.CREATE_SEGMENT (

2922: p_application_id := QP_APPLICATION_ID;
2923:
2924: --dbms_output.put_line ('Creating Other Contexts Segments ');
2925: BEGIN
2926: FND_FLEX_DSC_API.CREATE_SEGMENT (
2927: APPL_SHORT_NAME => P_NEW_PRODUCT
2928: , FLEXFIELD_NAME => P_NEW_FLEXFIELD_NAME
2929: , CONTEXT_NAME => L_CONTEXTS.CONTEXT_CODE(I) --2847218 changed to CONTEXT_CODE
2930: , NAME => p_segment_name

Line 3025: FND_FLEX_DSC_API.CREATE_SEGMENT (

3021: p_application_id := QP_APPLICATION_ID;
3022:
3023: --dbms_output.put_line ('Creating the OLD Gde segments to all contexts');
3024: BEGIN
3025: FND_FLEX_DSC_API.CREATE_SEGMENT (
3026: APPL_SHORT_NAME => P_NEW_PRODUCT
3027: , FLEXFIELD_NAME =>P_NEW_FLEXFIELD_NAME
3028: , CONTEXT_NAME => L_CONTEXTS.CONTEXT_CODE(I) --2847218 changed to CONTEXT_CODE
3029: , NAME => p_segment_name

Line 3069: --dbms_output.put_line(fnd_flex_dsc_api.message);

3065: END LOOP; -- CONTEXTS
3066: END IF; /* CHECK FOR NEW FLEX FIELD STRUCTURE EXISTS */
3067: EXCEPTION
3068: WHEN OTHERS THEN
3069: --dbms_output.put_line(fnd_flex_dsc_api.message);
3070: rollback;
3071: Log_Error(p_id1 => -6501,
3072: p_error_type => 'FLEXFIELD UPGRADE',
3073: p_error_desc => fnd_flex_dsc_api.message,

Line 3073: p_error_desc => fnd_flex_dsc_api.message,

3069: --dbms_output.put_line(fnd_flex_dsc_api.message);
3070: rollback;
3071: Log_Error(p_id1 => -6501,
3072: p_error_type => 'FLEXFIELD UPGRADE',
3073: p_error_desc => fnd_flex_dsc_api.message,
3074: p_error_module => 'QP_Upgrade_Context');
3075: raise;
3076: END QP_UPGRADE_CONTEXT;
3077: