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.OE_OE_PRICING_AVAILABILITY dependencies on OE_OE_PRICING_AVAILABILITY

Line 1: PACKAGE BODY oe_oe_pricing_availability AS

1: PACKAGE BODY oe_oe_pricing_availability AS
2: /* $Header: OEXFPRAB.pls 120.10.12010000.8 2008/11/26 17:27:27 vmachett ship $ */
3:
4: --Global variables
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'oe_oe_pricing_availability';

2: /* $Header: OEXFPRAB.pls 120.10.12010000.8 2008/11/26 17:27:27 vmachett ship $ */
3:
4: --Global variables
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'oe_oe_pricing_availability';
7: G_ATP_TBL OE_ATP.atp_tbl_type;
8: g_order_source_id CONSTANT NUMBER :=26;
9: G_line_id CONSTANT NUMBER :=1244;
10: G_atp_line_id CONSTANT NUMBER := -9987;

Line 98: g_applied_manual_tbl oe_oe_pricing_availability.number_type;

94: g_manual_modifier_tbl Manual_modifier_tbl;
95: g_modf_attributes_tbl Modifier_attributes_Tbl;
96: g_modf_rel_Tbl Modifier_assoc_Tbl;
97: g_enforce_price_flag varchar2(2) :='N';
98: g_applied_manual_tbl oe_oe_pricing_availability.number_type;
99:
100: --Start of bug#7380336
101: G_PR_AV VARCHAR(20):= 'N';
102:

Line 1906: ,px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE

1902: procedure copy_Header_to_request(
1903: p_request_type_code in varchar2
1904: ,p_calculate_price_flag in varchar2
1905: -- ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
1906: ,px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE
1907: ) is
1908:
1909: l_line_index pls_integer := 0;
1910:

Line 2001: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_HEADER_TO_REQUEST' ) ;

1997:
1998: --Temp Table population done
1999:
2000: IF l_debug_level > 0 THEN
2001: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_HEADER_TO_REQUEST' ) ;
2002: END IF;
2003:
2004: END copy_Header_to_request;
2005:

Line 2009: px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE

2005:
2006:
2007: PROCEDURE copy_Line_to_request(
2008: -- px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
2009: px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE
2010: ,p_pricing_event in varchar2
2011: ,p_Request_Type_Code in varchar2
2012: ,p_honor_price_flag in VARCHAR2 Default 'Y'
2013: ,p_line_index in number

Line 2169: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_LINE_TO_REQUEST' , 1 ) ;

2165: G_LINE_CATEGORY_TBL(l_line_index) := NULL;
2166:
2167:
2168: IF l_debug_level > 0 THEN
2169: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_LINE_TO_REQUEST' , 1 ) ;
2170: END IF;
2171:
2172: END copy_Line_to_request;
2173:

Line 2177: l_Control_Rec in out NOCOPY /* file.sql.39 change */ oe_oe_pricing_availability.QP_CONTROL_RECORD_TYPE

2173:
2174:
2175:
2176: PROCEDURE set_pricing_control_record (
2177: l_Control_Rec in out NOCOPY /* file.sql.39 change */ oe_oe_pricing_availability.QP_CONTROL_RECORD_TYPE
2178: ,in_pricing_event in varchar2)IS
2179:
2180: --
2181: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2204: Procedure copy_control_rec(in_Control_Rec in oe_oe_pricing_availability.QP_CONTROL_RECORD_TYPE,

2200: l_control_rec.SOURCE_ORDER_AMOUNT_FLAG := 'Y'; -- bug 5965668--FP bug 7491750 smbalara
2201:
2202: END set_pricing_control_record;
2203:
2204: Procedure copy_control_rec(in_Control_Rec in oe_oe_pricing_availability.QP_CONTROL_RECORD_TYPE,
2205: x_Control_Rec out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE) IS
2206:
2207: Begin
2208: x_control_rec.pricing_event := in_control_rec.pricing_event;

Line 2227: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,

2223: PROCEDURE build_context_for_line(
2224: p_req_line_tbl_count in number,
2225: p_price_request_code in varchar2,
2226: p_item_type_code in varchar2,
2227: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,
2228: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE,
2229: p_line_index in number
2230: )IS
2231:

Line 2228: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE,

2224: p_req_line_tbl_count in number,
2225: p_price_request_code in varchar2,
2226: p_item_type_code in varchar2,
2227: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,
2228: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE,
2229: p_line_index in number
2230: )IS
2231:
2232: qp_attr_mapping_error exception;

Line 2338: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,

2334: PROCEDURE build_context_for_header(
2335: p_req_line_tbl_count in number,
2336: p_price_request_code in varchar2,
2337: p_item_type_code in varchar2,
2338: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,
2339: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2340: )IS
2341:
2342: qp_attr_mapping_error exception;

Line 2339: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE

2335: p_req_line_tbl_count in number,
2336: p_price_request_code in varchar2,
2337: p_item_type_code in varchar2,
2338: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,
2339: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2340: )IS
2341:
2342: qp_attr_mapping_error exception;
2343: -- l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 2426: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE

2422: procedure Append_attributes(
2423: p_header_id number default null
2424: ,p_Line_id number default null
2425: ,p_line_index number
2426: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
2427: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2428: ,p_g_line_index in number
2429:
2430: ) is

Line 2427: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE

2423: p_header_id number default null
2424: ,p_Line_id number default null
2425: ,p_line_index number
2426: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
2427: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2428: ,p_g_line_index in number
2429:
2430: ) is
2431:

Line 2441: oe_debug_pub.add('ENTERING oe_oe_pricing_availability.APPEND_ATTRIBUTES'||

2437: --
2438: BEGIN
2439:
2440: IF l_debug_level > 0 THEN
2441: oe_debug_pub.add('ENTERING oe_oe_pricing_availability.APPEND_ATTRIBUTES'||
2442: ' p_line_id='||p_line_id);
2443: END IF;
2444:
2445: -- if line_id is not null, this does not apply to header level

Line 3465: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.APPEND_ATTRIBUTES' , 1 ) ;

3461: END LOOP;
3462: END IF; -- if promotions temp table is not null and for header
3463:
3464: IF l_debug_level > 0 THEN
3465: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.APPEND_ATTRIBUTES' , 1 ) ;
3466: END IF;
3467:
3468: END Append_attributes;
3469:

Line 3472: PROCEDURE Append_attr_to_ttables(px_req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE

3468: END Append_attributes;
3469:
3470:
3471:
3472: PROCEDURE Append_attr_to_ttables(px_req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
3473: )
3474: IS
3475: i number;
3476: k number;

Line 3741: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,

3737: END POPULATE_TEMP_TABLE;
3738:
3739:
3740: PROCEDURE Populate_results
3741: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3742: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3743: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3744: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3745: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,

Line 3742: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,

3738:
3739:
3740: PROCEDURE Populate_results
3741: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3742: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3743: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3744: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3745: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3746: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,

Line 3743: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,

3739:
3740: PROCEDURE Populate_results
3741: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3742: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3743: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3744: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3745: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3746: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3747: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)

Line 3744: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,

3740: PROCEDURE Populate_results
3741: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3742: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3743: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3744: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3745: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3746: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3747: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)
3748: AS

Line 3745: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,

3741: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3742: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3743: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3744: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3745: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3746: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3747: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)
3748: AS
3749:

Line 3746: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,

3742: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3743: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3744: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3745: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3746: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3747: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)
3748: AS
3749:
3750: -- Cursor l_lines_cur changed for removing NMV SQL Id : 14877269

Line 3747: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)

3743: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3744: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3745: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3746: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3747: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)
3748: AS
3749:
3750: -- Cursor l_lines_cur changed for removing NMV SQL Id : 14877269
3751:

Line 4099: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,

4095:
4096:
4097:
4098:
4099: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4100: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4101: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4102: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4103: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,

Line 4100: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,

4096:
4097:
4098:
4099: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4100: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4101: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4102: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4103: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4104: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,

Line 4101: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,

4097:
4098:
4099: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4100: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4101: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4102: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4103: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4104: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4105: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,

Line 4102: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,

4098:
4099: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4100: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4101: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4102: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4103: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4104: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4105: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
4106: out_child_detail_type out nocopy varchar2

Line 4103: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,

4099: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4100: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4101: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4102: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4103: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4104: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4105: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
4106: out_child_detail_type out nocopy varchar2
4107: ) IS

Line 4104: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,

4100: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4101: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4102: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4103: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4104: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4105: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
4106: out_child_detail_type out nocopy varchar2
4107: ) IS
4108:

Line 4105: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,

4101: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4102: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4103: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4104: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4105: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
4106: out_child_detail_type out nocopy varchar2
4107: ) IS
4108:
4109: l_return_status varchar2(10);

Line 4112: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;

4108:
4109: l_return_status varchar2(10);
4110: l_return_status_Text varchar2(240) ;
4111: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4112: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4113: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;

Line 4113: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;

4109: l_return_status varchar2(10);
4110: l_return_status_Text varchar2(240) ;
4111: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4112: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4113: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4117: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;

Line 4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;

4110: l_return_status_Text varchar2(240) ;
4111: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4112: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4113: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4117: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4118: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;

Line 4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;

4111: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4112: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4113: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4117: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4118: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4119: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;

Line 4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;

4112: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4113: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4117: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4118: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4119: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;
4120:

Line 4117: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;

4113: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4117: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4118: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4119: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;
4120:
4121: --

Line 4118: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;

4114: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4117: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4118: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4119: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;
4120:
4121: --
4122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4119: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;

4115: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4116: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4117: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4118: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4119: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;
4120:
4121: --
4122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4123: --

Line 5071: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE

5067:
5068:
5069: PROCEDURE copy_attribs_to_Req(
5070: p_line_index number
5071: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
5072: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
5073: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5074: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5075: ) IS

Line 5072: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE

5068:
5069: PROCEDURE copy_attribs_to_Req(
5070: p_line_index number
5071: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
5072: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
5073: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5074: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5075: ) IS
5076:

Line 5087: oe_debug_pub.add( 'ENTERING oe_oe_pricing_availability.COPY_ATTRIBS_TO_REQ' , 1 ) ;

5083: --
5084: BEGIN
5085:
5086: IF l_debug_level > 0 THEN
5087: oe_debug_pub.add( 'ENTERING oe_oe_pricing_availability.COPY_ATTRIBS_TO_REQ' , 1 ) ;
5088: END IF;
5089: i := p_pricing_contexts_Tbl.First;
5090: While i is not null loop
5091: l_attr_index := l_attr_index +1;

Line 5138: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_ATTRIBS_TO_REQ' , 1 ) ;

5134: i := p_qualifier_contexts_Tbl.Next(i);
5135: end loop;
5136:
5137: IF l_debug_level > 0 THEN
5138: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_ATTRIBS_TO_REQ' , 1 ) ;
5139: END IF;
5140:
5141: END copy_attribs_to_Req;
5142:

Line 6125: oe_debug_pub.add( 'ENTERING oe_oe_pricing_availability.GET_ITEM_INFO'||

6121: l_lookup_type varchar2(50);
6122: BEGIN
6123:
6124: IF l_debug_level > 0 THEN
6125: oe_debug_pub.add( 'ENTERING oe_oe_pricing_availability.GET_ITEM_INFO'||
6126: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID ) ;
6127: END IF;
6128:
6129: OPEN c_item_info;

Line 6174: oe_oe_pricing_availability.get_Ship_From_Org

6170: out_make_or_buy := 'Buy';
6171: END IF;
6172:
6173:
6174: oe_oe_pricing_availability.get_Ship_From_Org
6175: ( in_org_id => in_org_id
6176: , out_code=>out_wsh
6177: , out_name =>out_wsh_name
6178: );

Line 6205: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.GET_ITEM_INFO'||

6201: out_user_item_type := null;
6202:
6203: END IF;
6204: IF l_debug_level > 0 THEN
6205: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.GET_ITEM_INFO'||
6206: ' ITEM_STATUS ='||OUT_ITEM_STATUS ) ;
6207: END IF;
6208:
6209: EXCEPTION

Line 6217: oe_debug_pub.add( 'WHEN OTHERS oe_oe_pricing_availability.GET_ITEM_INFO '||

6213: CLOSE c_item_info;
6214: END IF;
6215:
6216: IF l_debug_level > 0 THEN
6217: oe_debug_pub.add( 'WHEN OTHERS oe_oe_pricing_availability.GET_ITEM_INFO '||
6218: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID||
6219: 'SQLCODE='||SQLCODE|| 'SQLERRM='||SQLERRM ) ;
6220: END IF;
6221:

Line 7119: oe_debug_pub.add( 'oe_oe_pricing_availability.SET_MRP_DEBUG NO_DATA_FOUND' ) ;

7115:
7116: EXCEPTION
7117: WHEN NO_DATA_FOUND THEN
7118: IF l_debug_level > 0 THEN
7119: oe_debug_pub.add( 'oe_oe_pricing_availability.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
7120: END IF;
7121: WHEN OTHERS THEN
7122: IF l_debug_level > 0 THEN
7123: oe_debug_pub.add( 'WHEN OTHERS oe_oe_pricing_availability.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

Line 7123: oe_debug_pub.add( 'WHEN OTHERS oe_oe_pricing_availability.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

7119: oe_debug_pub.add( 'oe_oe_pricing_availability.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
7120: END IF;
7121: WHEN OTHERS THEN
7122: IF l_debug_level > 0 THEN
7123: oe_debug_pub.add( 'WHEN OTHERS oe_oe_pricing_availability.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;
7124: END IF;
7125:
7126: END set_mrp_debug;
7127:

Line 7129: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,

7125:
7126: END set_mrp_debug;
7127:
7128: PROCEDURE CopyINTO_PO_RecStruc
7129: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7130: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7131: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,

Line 7130: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,

7126: END set_mrp_debug;
7127:
7128: PROCEDURE CopyINTO_PO_RecStruc
7129: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7130: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7131: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,

Line 7131: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,

7127:
7128: PROCEDURE CopyINTO_PO_RecStruc
7129: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7130: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7131: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,

Line 7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,

7128: PROCEDURE CopyINTO_PO_RecStruc
7129: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7130: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7131: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,

Line 7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,

7129: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7130: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7131: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,

Line 7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,

7130: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7131: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,

Line 7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,

7131: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,

Line 7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,

7132: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,

Line 7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,

7133: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,

Line 7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,

7134: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7135: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7136: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7137: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7138: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7139: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7140: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7141: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7142: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,

Line 7605: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,

7601:
7602:
7603: PROCEDURE Create_Order(
7604: in_order in varchar2,
7605: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7606: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7607: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,

Line 7606: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,

7602:
7603: PROCEDURE Create_Order(
7604: in_order in varchar2,
7605: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7606: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7607: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,

Line 7607: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,

7603: PROCEDURE Create_Order(
7604: in_order in varchar2,
7605: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7606: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7607: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,

Line 7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,

7604: in_order in varchar2,
7605: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7606: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7607: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7612: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,

Line 7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,

7605: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7606: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7607: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7612: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7613: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,

Line 7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,

7606: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7607: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7612: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7613: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7614: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,

Line 7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,

7607: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7612: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7613: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7614: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7615: out_order_number out NOCOPY varchar2,

Line 7612: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,

7608: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7612: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7613: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7614: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7615: out_order_number out NOCOPY varchar2,
7616: out_header_id out NOCOPY number,

Line 7613: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,

7609: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7612: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7613: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7614: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7615: out_order_number out NOCOPY varchar2,
7616: out_header_id out NOCOPY number,
7617: out_order_total out NOCOPY number,

Line 7614: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,

7610: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7611: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7612: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7613: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7614: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7615: out_order_number out NOCOPY varchar2,
7616: out_header_id out NOCOPY number,
7617: out_order_total out NOCOPY number,
7618: out_order_amount out nocopy number,

Line 8419: oe_debug_pub.add('Entering OE_OE_PRICING_AVAILABILITY.GET_FORM_STARTUP_VALUES', 1);

8415: FROM fnd_id_flex_structures
8416: WHERE id_flex_code = X_Id_Flex_Code;
8417: BEGIN
8418:
8419: oe_debug_pub.add('Entering OE_OE_PRICING_AVAILABILITY.GET_FORM_STARTUP_VALUES', 1);
8420:
8421: OPEN C_Item_Flex(Item_Id_Flex_Code);
8422: FETCH C_Item_Flex INTO Item_Id_Flex_Num;
8423: CLOSE C_Item_Flex;

Line 8429: oe_debug_pub.add('In when others exception : OE_OE_PRICING_AVAILABILITY.GET_FORM_STARTUP_VALUES', 1);

8425: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
8426:
8427: EXCEPTION
8428: WHEN OTHERS THEN
8429: oe_debug_pub.add('In when others exception : OE_OE_PRICING_AVAILABILITY.GET_FORM_STARTUP_VALUES', 1);
8430: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8431: THEN
8432: OE_MSG_PUB.Add_Exc_Msg
8433: ( G_PKG_NAME ,

Line 8489: /* start bug 3440778 , Created to convert the reference to other products serverside code inside OEXPRAVA pld into a local call. to OE_OE_PRICING_AVAILABILITY package*/

8485: return err_msg;
8486:
8487: END GET_MRP_ERR_MSG;
8488:
8489: /* start bug 3440778 , Created to convert the reference to other products serverside code inside OEXPRAVA pld into a local call. to OE_OE_PRICING_AVAILABILITY package*/
8490:
8491: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
8492: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
8493: ,p_order_currency IN VARCHAR2 Default NULL

Line 8581: END oe_oe_pricing_availability;

8577: END round_price;
8578:
8579: -- end bug 3440778
8580:
8581: END oe_oe_pricing_availability;