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.OZF_OM_VALIDATION_PVT dependencies on QP_PREQ_GRP

Line 38: l_p_line_tbl QP_PREQ_GRP.line_tbl_type;

34: l_api_name CONSTANT VARCHAR2(30) := 'Price_Item';
35: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
36: l_return_status VARCHAR2(1);
37: /*
38: l_p_line_tbl QP_PREQ_GRP.line_tbl_type;
39: l_p_qual_tbl QP_PREQ_GRP.qual_tbl_type;
40: l_p_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;
42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;

Line 39: l_p_qual_tbl QP_PREQ_GRP.qual_tbl_type;

35: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
36: l_return_status VARCHAR2(1);
37: /*
38: l_p_line_tbl QP_PREQ_GRP.line_tbl_type;
39: l_p_qual_tbl QP_PREQ_GRP.qual_tbl_type;
40: l_p_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;
42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;

Line 40: l_p_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;

36: l_return_status VARCHAR2(1);
37: /*
38: l_p_line_tbl QP_PREQ_GRP.line_tbl_type;
39: l_p_qual_tbl QP_PREQ_GRP.qual_tbl_type;
40: l_p_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;
42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;

Line 41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;

37: /*
38: l_p_line_tbl QP_PREQ_GRP.line_tbl_type;
39: l_p_qual_tbl QP_PREQ_GRP.qual_tbl_type;
40: l_p_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;
42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
45: l_p_control_rec QP_PREQ_GRP.control_record_type;

Line 42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;

38: l_p_line_tbl QP_PREQ_GRP.line_tbl_type;
39: l_p_qual_tbl QP_PREQ_GRP.qual_tbl_type;
40: l_p_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;
42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
45: l_p_control_rec QP_PREQ_GRP.control_record_type;
46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;

Line 43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;

39: l_p_qual_tbl QP_PREQ_GRP.qual_tbl_type;
40: l_p_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;
42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
45: l_p_control_rec QP_PREQ_GRP.control_record_type;
46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;
47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;

Line 44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;

40: l_p_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;
42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
45: l_p_control_rec QP_PREQ_GRP.control_record_type;
46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;
47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;
48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;

Line 45: l_p_control_rec QP_PREQ_GRP.control_record_type;

41: l_p_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;
42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
45: l_p_control_rec QP_PREQ_GRP.control_record_type;
46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;
47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;
48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
49: l_x_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;l_x_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;

Line 46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;

42: l_p_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
45: l_p_control_rec QP_PREQ_GRP.control_record_type;
46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;
47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;
48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
49: l_x_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;l_x_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
50: l_x_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;

Line 47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;

43: l_p_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
45: l_p_control_rec QP_PREQ_GRP.control_record_type;
46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;
47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;
48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
49: l_x_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;l_x_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
50: l_x_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
51: l_x_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;

Line 48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;

44: l_p_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
45: l_p_control_rec QP_PREQ_GRP.control_record_type;
46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;
47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;
48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
49: l_x_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;l_x_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
50: l_x_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
51: l_x_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
52: l_return_status VARCHAR2(240);

Line 49: l_x_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;l_x_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;

45: l_p_control_rec QP_PREQ_GRP.control_record_type;
46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;
47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;
48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
49: l_x_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;l_x_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
50: l_x_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
51: l_x_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
52: l_return_status VARCHAR2(240);
53: l_return_status_text VARCHAR2(240);

Line 50: l_x_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;

46: l_x_line_tbl QP_PREQ_GRP.line_tbl_type;
47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;
48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
49: l_x_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;l_x_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
50: l_x_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
51: l_x_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
52: l_return_status VARCHAR2(240);
53: l_return_status_text VARCHAR2(240);
54: */

Line 51: l_x_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;

47: l_x_line_qual QP_PREQ_GRP.qual_tbl_type;
48: l_x_line_attr_tbl QP_PREQ_GRP.line_attr_tbl_type;
49: l_x_line_detail_tbl QP_PREQ_GRP.line_detail_tbl_type;l_x_line_detail_qual_tbl QP_PREQ_GRP.line_detail_qual_tbl_type;
50: l_x_line_detail_attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type;
51: l_x_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type;
52: l_return_status VARCHAR2(240);
53: l_return_status_text VARCHAR2(240);
54: */
55:

Line 57: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

53: l_return_status_text VARCHAR2(240);
54: */
55:
56: l_header_id NUMBER := TO_NUMBER(TO_CHAR(SYSDATE, 'HH24MISS'));
57: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
58: l_p_x_line_tbl OZF_ORDER_PRICE_PVT.LINE_REC_TBL_TYPE;
59: l_x_ldets_tbl OZF_ORDER_PRICE_PVT.LDETS_TBL_TYPE;
60: l_x_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
61: l_price_list_id NUMBER;

Line 150: l_p_x_line_tbl(i).PRICING_STATUS_CODE := QP_PREQ_GRP.G_STATUS_UNCHANGED;

146: l_p_x_line_tbl(i).UPD_ADJUSTED_UNIT_PRICE := null;
147: l_p_x_line_tbl(i).PROCESSED_FLAG := null;
148: l_p_x_line_tbl(i).PRICE_FLAG := 'Y';
149: l_p_x_line_tbl(i).PROCESSING_ORDER := null;
150: l_p_x_line_tbl(i).PRICING_STATUS_CODE := QP_PREQ_GRP.G_STATUS_UNCHANGED;
151: l_p_x_line_tbl(i).PRICING_STATUS_TEXT := null;
152: l_p_x_line_tbl(i).ROUNDING_FLAG := null;
153: l_p_x_line_tbl(i).ROUNDING_FACTOR := null;
154: l_p_x_line_tbl(i).QUALIFIERS_EXIST_FLAG := null;

Line 329: QP_PREQ_GRP.PRICE_REQUEST(

325: END LOOP;
326: END IF;
327:
328: -- Call Pricing Engine
329: QP_PREQ_GRP.PRICE_REQUEST(
330: l_p_line_tbl,
331: l_p_qual_tbl,
332: l_p_line_attr_tbl,
333: l_p_line_detail_tbl,