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.QP_ATTR_MAPPING_PUB dependencies on QP_BUILD_SOURCING_PVT

Line 281: l_new_pkg_name VARCHAR2(30) := 'QP_BUILD_SOURCING_PVT';

277:
278: l_is_pkg_body VARCHAR2(30);
279: n NUMBER := 0;
280: l_pkg_name VARCHAR2(30);
281: l_new_pkg_name VARCHAR2(30) := 'QP_BUILD_SOURCING_PVT';
282: v_segment_id NUMBER;
283: v_count BINARY_INTEGER := 1;
284: CURSOR errors IS
285: SELECT line, text

Line 350: --no errors in the QP_BUILD_SOURCING_PVT_TMP

346:
347: --changes by spgopal 15-JUN-2001 for BUILD_SOURCE_TMP
348: IF n = 0
349: THEN
350: --no errors in the QP_BUILD_SOURCING_PVT_TMP
351: --now go ahead generate the package
352: --as QP_BUILD_SOURCING_PVT
353:
354: PUT_LINE('PACKAGE '||p_pkg_type||' Name to :'

Line 352: --as QP_BUILD_SOURCING_PVT

348: IF n = 0
349: THEN
350: --no errors in the QP_BUILD_SOURCING_PVT_TMP
351: --now go ahead generate the package
352: --as QP_BUILD_SOURCING_PVT
353:
354: PUT_LINE('PACKAGE '||p_pkg_type||' Name to :'
355: ||l_pkg_name||' compiled successfully ');
356:

Line 2126: Pkg_Header('QP_BUILD_SOURCING_PVT_TMP', 'BODY');

2122:
2123: -- Writing out the body
2124:
2125: --changes by spgopal 15-JUN-2001 = 'Y' for BUILD_SOURCE_TMP
2126: Pkg_Header('QP_BUILD_SOURCING_PVT_TMP', 'BODY');
2127: New_Line;
2128: Text('PROCEDURE Get_Attribute_Values',0);
2129: Text('( p_req_type_code IN VARCHAR2',0);
2130: Text(', p_pricing_type_code IN VARCHAR2',0);

Line 2292: -- Text('END QP_BUILD_SOURCING_PVT;',0);

2288: New_line;
2289: Text('END Is_Attribute_Used;',0);
2290: New_line;
2291:
2292: -- Text('END QP_BUILD_SOURCING_PVT;',0);
2293: -- Text('/',0);
2294: --changes by spgopal 15-JUN-2001 for BUILD_SOURCE_TMP
2295: --dbms_output.put_line('............4............');
2296: Pkg_End('QP_BUILD_SOURCING_PVT_TMP', 'BODY');

Line 2296: Pkg_End('QP_BUILD_SOURCING_PVT_TMP', 'BODY');

2292: -- Text('END QP_BUILD_SOURCING_PVT;',0);
2293: -- Text('/',0);
2294: --changes by spgopal 15-JUN-2001 for BUILD_SOURCE_TMP
2295: --dbms_output.put_line('............4............');
2296: Pkg_End('QP_BUILD_SOURCING_PVT_TMP', 'BODY');
2297:
2298: --dbms_output.put_line('............5............');
2299: retcode := 0;
2300: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');

Line 2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');

2308:
2309: WHEN Fnd_Api.G_EXC_ERROR THEN
2310: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2311: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2313: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2314: err_buff := Fnd_Message.GET;
2315: retcode := 2;
2316:

Line 2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');

2318:
2319: WHEN OTHERS THEN
2320: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2321: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2323: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2324: err_buff := Fnd_Message.GET;
2325: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);
2326: retcode := 2;

Line 2325: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);

2321: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2323: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2324: err_buff := Fnd_Message.GET;
2325: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);
2326: retcode := 2;
2327: -- err_buff := sqlerrm;
2328:
2329:

Line 2389: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2385: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2386: -- 13638721
2387: oe_debug_pub.add('Maintain Dynamic pkgs profile is 1:'||L_MAINT_DYN_SRC_VER);
2388: IF (L_MAINT_DYN_SRC_VER='N') THEN
2389: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2390: p_pricing_type_code => p_pricing_type,
2391: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2392: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2393: ELSE

Line 2403: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2399: l_pkg_ver:='0';
2400: oe_debug_pub.add('1. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);
2401: END;
2402: IF (l_pkg_ver='5') THEN
2403: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2404: p_pricing_type_code => p_pricing_type,
2405: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2406: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2407: ELSIF (l_pkg_ver='4') THEN

Line 2408: Qp_Build_Sourcing_Pvt4.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2404: p_pricing_type_code => p_pricing_type,
2405: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2406: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2407: ELSIF (l_pkg_ver='4') THEN
2408: Qp_Build_Sourcing_Pvt4.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2409: p_pricing_type_code => p_pricing_type,
2410: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2411: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2412: ELSIF (l_pkg_ver='3') THEN

Line 2413: Qp_Build_Sourcing_Pvt3.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2409: p_pricing_type_code => p_pricing_type,
2410: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2411: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2412: ELSIF (l_pkg_ver='3') THEN
2413: Qp_Build_Sourcing_Pvt3.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2414: p_pricing_type_code => p_pricing_type,
2415: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2416: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2417: ELSIF (l_pkg_ver='2') THEN

Line 2418: Qp_Build_Sourcing_Pvt2.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2414: p_pricing_type_code => p_pricing_type,
2415: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2416: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2417: ELSIF (l_pkg_ver='2') THEN
2418: Qp_Build_Sourcing_Pvt2.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2419: p_pricing_type_code => p_pricing_type,
2420: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2421: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2422: ELSIF (l_pkg_ver='1') THEN

Line 2423: Qp_Build_Sourcing_Pvt1.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2419: p_pricing_type_code => p_pricing_type,
2420: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2421: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2422: ELSIF (l_pkg_ver='1') THEN
2423: Qp_Build_Sourcing_Pvt1.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2424: p_pricing_type_code => p_pricing_type,
2425: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2426: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2427: ELSE

Line 2428: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2424: p_pricing_type_code => p_pricing_type,
2425: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2426: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2427: ELSE
2428: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2429: p_pricing_type_code => p_pricing_type,
2430: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2431: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2432: END IF;

Line 2775: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2771: END IF;
2772: -- 13638721
2773: oe_debug_pub.add('Maintain Dynamic pkgs profile is 2:'||L_MAINT_DYN_SRC_VER);
2774: IF (L_MAINT_DYN_SRC_VER='N') THEN
2775: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2776: p_pricing_type_code => p_pricing_type_code,
2777: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2778: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2779: ELSE

Line 2789: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2785: l_pkg_ver:='0';
2786: oe_debug_pub.add('2. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);
2787: END;
2788: IF (l_pkg_ver='5') THEN
2789: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2790: p_pricing_type_code => p_pricing_type_code,
2791: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2792: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2793: ELSIF (l_pkg_ver='4') THEN

Line 2794: Qp_Build_Sourcing_Pvt4.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2790: p_pricing_type_code => p_pricing_type_code,
2791: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2792: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2793: ELSIF (l_pkg_ver='4') THEN
2794: Qp_Build_Sourcing_Pvt4.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2795: p_pricing_type_code => p_pricing_type_code,
2796: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2797: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2798: ELSIF (l_pkg_ver='3') THEN

Line 2799: Qp_Build_Sourcing_Pvt3.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2795: p_pricing_type_code => p_pricing_type_code,
2796: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2797: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2798: ELSIF (l_pkg_ver='3') THEN
2799: Qp_Build_Sourcing_Pvt3.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2800: p_pricing_type_code => p_pricing_type_code,
2801: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2802: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2803: ELSIF (l_pkg_ver='2') THEN

Line 2804: Qp_Build_Sourcing_Pvt2.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2800: p_pricing_type_code => p_pricing_type_code,
2801: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2802: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2803: ELSIF (l_pkg_ver='2') THEN
2804: Qp_Build_Sourcing_Pvt2.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2805: p_pricing_type_code => p_pricing_type_code,
2806: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2807: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2808: ELSIF (l_pkg_ver='1') THEN

Line 2809: Qp_Build_Sourcing_Pvt1.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2805: p_pricing_type_code => p_pricing_type_code,
2806: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2807: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2808: ELSIF (l_pkg_ver='1') THEN
2809: Qp_Build_Sourcing_Pvt1.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2810: p_pricing_type_code => p_pricing_type_code,
2811: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2812: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2813: ELSE

Line 2814: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,

2810: p_pricing_type_code => p_pricing_type_code,
2811: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2812: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2813: ELSE
2814: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2815: p_pricing_type_code => p_pricing_type_code,
2816: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2817: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2818:

Line 3090: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,

3086:
3087: -- 13638721
3088: oe_debug_pub.add('Maintain Dynamic pkgs profile is 3:'||L_MAINT_DYN_SRC_VER);
3089: IF (L_MAINT_DYN_SRC_VER='N') THEN
3090: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3091: p_pricing_type_code => p_pricing_type_code,
3092: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3093: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3094: ELSE

Line 3104: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,

3100: l_pkg_ver:='0';
3101: oe_debug_pub.add('3. when others row in qp_params for code BLD_SRC_ATTR_ACTV_VER pkg ver: ' || l_pkg_ver);
3102: END;
3103: IF (l_pkg_ver='5') THEN
3104: Qp_Build_Sourcing_Pvt5.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3105: p_pricing_type_code => p_pricing_type_code,
3106: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3107: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3108: ELSIF (l_pkg_ver='4') THEN

Line 3109: Qp_Build_Sourcing_Pvt4.Get_Attribute_Values(p_req_type_code => p_request_type_code,

3105: p_pricing_type_code => p_pricing_type_code,
3106: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3107: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3108: ELSIF (l_pkg_ver='4') THEN
3109: Qp_Build_Sourcing_Pvt4.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3110: p_pricing_type_code => p_pricing_type_code,
3111: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3112: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3113: ELSIF (l_pkg_ver='3') THEN

Line 3114: Qp_Build_Sourcing_Pvt3.Get_Attribute_Values(p_req_type_code => p_request_type_code,

3110: p_pricing_type_code => p_pricing_type_code,
3111: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3112: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3113: ELSIF (l_pkg_ver='3') THEN
3114: Qp_Build_Sourcing_Pvt3.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3115: p_pricing_type_code => p_pricing_type_code,
3116: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3117: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3118: ELSIF (l_pkg_ver='2') THEN

Line 3119: Qp_Build_Sourcing_Pvt2.Get_Attribute_Values(p_req_type_code => p_request_type_code,

3115: p_pricing_type_code => p_pricing_type_code,
3116: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3117: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3118: ELSIF (l_pkg_ver='2') THEN
3119: Qp_Build_Sourcing_Pvt2.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3120: p_pricing_type_code => p_pricing_type_code,
3121: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3122: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3123: ELSIF (l_pkg_ver='1') THEN

Line 3124: Qp_Build_Sourcing_Pvt1.Get_Attribute_Values(p_req_type_code => p_request_type_code,

3120: p_pricing_type_code => p_pricing_type_code,
3121: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3122: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3123: ELSIF (l_pkg_ver='1') THEN
3124: Qp_Build_Sourcing_Pvt1.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3125: p_pricing_type_code => p_pricing_type_code,
3126: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3127: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3128: ELSE

Line 3129: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,

3125: p_pricing_type_code => p_pricing_type_code,
3126: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3127: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3128: ELSE
3129: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
3130: p_pricing_type_code => p_pricing_type_code,
3131: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
3132: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
3133: