DBA Data[Home] [Help]

APPS.QP_ATTR_MAPPING_PUB dependencies on QP_BUILD_SOURCING_PVT

Line 281: l_new_pkg_name CONSTANT 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 CONSTANT 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 347: --no errors in the QP_BUILD_SOURCING_PVT_TMP

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

Line 349: --as QP_BUILD_SOURCING_PVT

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

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

2054:
2055: -- Writing out the body
2056:
2057: --changes by spgopal 15-JUN-2001 = 'Y' for BUILD_SOURCE_TMP
2058: Pkg_Header('QP_BUILD_SOURCING_PVT_TMP', 'BODY');
2059: New_Line;
2060: Text('PROCEDURE Get_Attribute_Values',0);
2061: Text('( p_req_type_code IN VARCHAR2',0);
2062: Text(', p_pricing_type_code IN VARCHAR2',0);

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

2217: New_line;
2218: Text('END Is_Attribute_Used;',0);
2219: New_line;
2220:
2221: -- Text('END QP_BUILD_SOURCING_PVT;',0);
2222: -- Text('/',0);
2223: --changes by spgopal 15-JUN-2001 for BUILD_SOURCE_TMP
2224: --dbms_output.put_line('............4............');
2225: Pkg_End('QP_BUILD_SOURCING_PVT_TMP', 'BODY');

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

2221: -- Text('END QP_BUILD_SOURCING_PVT;',0);
2222: -- Text('/',0);
2223: --changes by spgopal 15-JUN-2001 for BUILD_SOURCE_TMP
2224: --dbms_output.put_line('............4............');
2225: Pkg_End('QP_BUILD_SOURCING_PVT_TMP', 'BODY');
2226:
2227: --dbms_output.put_line('............5............');
2228: retcode := 0;
2229: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');

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

2237:
2238: WHEN Fnd_Api.G_EXC_ERROR THEN
2239: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2240: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2241: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2242: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2243: err_buff := Fnd_Message.GET;
2244: retcode := 2;
2245:

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

2247:
2248: WHEN OTHERS THEN
2249: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2250: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2251: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2252: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2253: err_buff := Fnd_Message.GET;
2254: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);
2255: retcode := 2;

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

2250: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2251: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2252: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2253: err_buff := Fnd_Message.GET;
2254: PUT_LINE( 'Error in creating QP_BUILD_SOURCING_PVT '||SQLERRM);
2255: retcode := 2;
2256: -- err_buff := sqlerrm;
2257:
2258:

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

2312: l_sourcing_start_time := dbms_utility.get_time;
2313:
2314: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2315:
2316: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2317: p_pricing_type_code => p_pricing_type,
2318: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,
2319: x_price_ctxts_result_tbl => x_price_contexts_result_tbl);
2320:

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

2624: l_pricing_type_code := 'L';
2625:
2626: IF (p_pricing_type_code = 'L') THEN
2627:
2628: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2629: p_pricing_type_code => p_pricing_type_code,
2630: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2631: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2632:

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

2871: l_pricing_type_code := 'H';
2872:
2873: IF (p_pricing_type_code = 'H') THEN
2874:
2875: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2876: p_pricing_type_code => p_pricing_type_code,
2877: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2878: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2879: