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.20.12020000.4 2013/02/20 13:07:20 nilegupt ship $ */
3:
4: --Global variables
5:

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

2: /* $Header: OEXFPRAB.pls 120.20.12020000.4 2013/02/20 13:07:20 nilegupt 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; --bug#16061437
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 1916: ,px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE

1912: procedure copy_Header_to_request(
1913: p_request_type_code in varchar2
1914: ,p_calculate_price_flag in varchar2
1915: -- ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
1916: ,px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE
1917: ) is
1918:
1919: l_line_index pls_integer := 0;
1920:

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

2007:
2008: --Temp Table population done
2009:
2010: IF l_debug_level > 0 THEN
2011: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_HEADER_TO_REQUEST' ) ;
2012: END IF;
2013:
2014: END copy_Header_to_request;
2015:

Line 2019: px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE

2015:
2016:
2017: PROCEDURE copy_Line_to_request(
2018: -- px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
2019: px_req_line_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_TBL_TYPE
2020: ,p_pricing_event in varchar2
2021: ,p_Request_Type_Code in varchar2
2022: ,p_honor_price_flag in VARCHAR2 Default 'Y'
2023: ,p_line_index in number

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

2175: G_LINE_CATEGORY_TBL(l_line_index) := NULL;
2176:
2177:
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_LINE_TO_REQUEST' , 1 ) ;
2180: END IF;
2181:
2182: END copy_Line_to_request;
2183:

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

2183:
2184:
2185:
2186: PROCEDURE set_pricing_control_record (
2187: l_Control_Rec in out NOCOPY /* file.sql.39 change */ oe_oe_pricing_availability.QP_CONTROL_RECORD_TYPE
2188: ,in_pricing_event in varchar2)IS
2189:
2190: --
2191: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

2210: l_control_rec.SOURCE_ORDER_AMOUNT_FLAG := 'Y'; -- bug 5965668--FP bug 7491750 smbalara
2211:
2212: END set_pricing_control_record;
2213:
2214: Procedure copy_control_rec(in_Control_Rec in oe_oe_pricing_availability.QP_CONTROL_RECORD_TYPE,
2215: x_Control_Rec out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE) IS
2216:
2217: Begin
2218: x_control_rec.pricing_event := in_control_rec.pricing_event;

Line 2237: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,

2233: PROCEDURE build_context_for_line(
2234: p_req_line_tbl_count in number,
2235: p_price_request_code in varchar2,
2236: p_item_type_code in varchar2,
2237: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,
2238: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE,
2239: p_line_index in number
2240: )IS
2241:

Line 2238: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE,

2234: p_req_line_tbl_count in number,
2235: p_price_request_code in varchar2,
2236: p_item_type_code in varchar2,
2237: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,
2238: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE,
2239: p_line_index in number
2240: )IS
2241:
2242: qp_attr_mapping_error exception;

Line 2363: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,

2359: PROCEDURE build_context_for_header(
2360: p_req_line_tbl_count in number,
2361: p_price_request_code in varchar2,
2362: p_item_type_code in varchar2,
2363: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,
2364: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2365: )IS
2366:
2367: qp_attr_mapping_error exception;

Line 2364: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE

2360: p_req_line_tbl_count in number,
2361: p_price_request_code in varchar2,
2362: p_item_type_code in varchar2,
2363: p_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE,
2364: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2365: )IS
2366:
2367: qp_attr_mapping_error exception;
2368: -- l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 2451: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE

2447: procedure Append_attributes(
2448: p_header_id number default null
2449: ,p_Line_id number default null
2450: ,p_line_index number
2451: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
2452: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2453: ,p_g_line_index in number
2454:
2455: ) is

Line 2452: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE

2448: p_header_id number default null
2449: ,p_Line_id number default null
2450: ,p_line_index number
2451: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
2452: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2453: ,p_g_line_index in number
2454:
2455: ) is
2456:

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

2462: --
2463: BEGIN
2464:
2465: IF l_debug_level > 0 THEN
2466: oe_debug_pub.add('ENTERING oe_oe_pricing_availability.APPEND_ATTRIBUTES'||
2467: ' p_line_id='||p_line_id);
2468: END IF;
2469:
2470: -- if line_id is not null, this does not apply to header level

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

3486: END LOOP;
3487: END IF; -- if promotions temp table is not null and for header
3488:
3489: IF l_debug_level > 0 THEN
3490: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.APPEND_ATTRIBUTES' , 1 ) ;
3491: END IF;
3492:
3493: END Append_attributes;
3494:

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

3493: END Append_attributes;
3494:
3495:
3496:
3497: PROCEDURE Append_attr_to_ttables(px_req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
3498: )
3499: IS
3500: i number;
3501: k number;

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

3762: END POPULATE_TEMP_TABLE;
3763:
3764:
3765: PROCEDURE Populate_results
3766: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3767: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3768: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3769: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3770: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,

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

3763:
3764:
3765: PROCEDURE Populate_results
3766: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3767: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3768: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3769: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3770: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3771: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,

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

3764:
3765: PROCEDURE Populate_results
3766: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3767: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3768: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3769: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3770: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3771: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3772: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)

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

3765: PROCEDURE Populate_results
3766: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3767: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3768: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3769: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3770: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3771: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3772: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)
3773: AS

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

3766: (x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
3767: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3768: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3769: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3770: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3771: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3772: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)
3773: AS
3774:

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

3767: x_line_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
3768: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3769: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3770: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3771: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3772: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)
3773: AS
3774:
3775: -- Cursor l_lines_cur changed for removing NMV SQL Id : 14877269

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

3768: x_line_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
3769: x_line_detail_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
3770: x_line_detail_qual_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
3771: x_line_detail_attr_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
3772: x_related_lines_tbl OUT NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE)
3773: AS
3774:
3775: -- Cursor l_lines_cur changed for removing NMV SQL Id : 14877269
3776:

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

4120:
4121:
4122:
4123:
4124: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4125: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4126: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4127: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4128: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,

Line 4125: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,

4121:
4122:
4123:
4124: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4125: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4126: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4127: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4128: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4129: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,

Line 4126: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,

4122:
4123:
4124: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4125: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4126: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4127: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4128: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4129: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4130: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,

Line 4127: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,

4123:
4124: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4125: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4126: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4127: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4128: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4129: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4130: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
4131: out_child_detail_type out nocopy varchar2

Line 4128: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,

4124: PROCEDURE price_item(out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
4125: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4126: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4127: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4128: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4129: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4130: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
4131: out_child_detail_type out nocopy varchar2
4132: ) IS

Line 4129: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,

4125: out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
4126: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4127: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4128: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4129: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4130: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
4131: out_child_detail_type out nocopy varchar2
4132: ) IS
4133:

Line 4130: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,

4126: out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
4127: out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
4128: out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
4129: out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
4130: out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
4131: out_child_detail_type out nocopy varchar2
4132: ) IS
4133:
4134: l_return_status varchar2(10);

Line 4137: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;

4133:
4134: l_return_status varchar2(10);
4135: l_return_status_Text varchar2(240) ;
4136: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4137: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4138: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;

Line 4138: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;

4134: l_return_status varchar2(10);
4135: l_return_status_Text varchar2(240) ;
4136: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4137: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4138: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4142: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;

Line 4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;

4135: l_return_status_Text varchar2(240) ;
4136: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4137: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4138: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4142: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4143: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;

Line 4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;

4136: lx_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
4137: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4138: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4142: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4143: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4144: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;

Line 4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;

4137: l_Control_Rec OE_OE_PRICING_AVAILABILITY.QP_CONTROL_RECORD_TYPE;
4138: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4142: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4143: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4144: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;
4145:

Line 4142: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;

4138: l_req_line_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE;
4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4142: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4143: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4144: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;
4145:
4146: --

Line 4143: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;

4139: l_Req_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE;
4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4142: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4143: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4144: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;
4145:
4146: --
4147: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4144: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;

4140: l_Req_line_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE;
4141: l_Req_LINE_DETAIL_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE;
4142: l_Req_LINE_DETAIL_qual_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE;
4143: l_Req_LINE_DETAIL_attr_tbl OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE;
4144: l_Req_related_lines_tbl OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE;
4145:
4146: --
4147: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4148: --

Line 5096: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE

5092:
5093:
5094: PROCEDURE copy_attribs_to_Req(
5095: p_line_index number
5096: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
5097: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
5098: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5099: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5100: ) IS

Line 5097: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE

5093:
5094: PROCEDURE copy_attribs_to_Req(
5095: p_line_index number
5096: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
5097: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
5098: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5099: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5100: ) IS
5101:

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

5108: --
5109: BEGIN
5110:
5111: IF l_debug_level > 0 THEN
5112: oe_debug_pub.add( 'ENTERING oe_oe_pricing_availability.COPY_ATTRIBS_TO_REQ' , 1 ) ;
5113: END IF;
5114: i := p_pricing_contexts_Tbl.First;
5115: While i is not null loop
5116: l_attr_index := l_attr_index +1;

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

5159: i := p_qualifier_contexts_Tbl.Next(i);
5160: end loop;
5161:
5162: IF l_debug_level > 0 THEN
5163: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.COPY_ATTRIBS_TO_REQ' , 1 ) ;
5164: END IF;
5165:
5166: END copy_attribs_to_Req;
5167:

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

6146: l_lookup_type varchar2(50);
6147: BEGIN
6148:
6149: IF l_debug_level > 0 THEN
6150: oe_debug_pub.add( 'ENTERING oe_oe_pricing_availability.GET_ITEM_INFO'||
6151: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID ) ;
6152: END IF;
6153:
6154: OPEN c_item_info;

Line 6199: oe_oe_pricing_availability.get_Ship_From_Org

6195: out_make_or_buy := 'Buy';
6196: END IF;
6197:
6198:
6199: oe_oe_pricing_availability.get_Ship_From_Org
6200: ( in_org_id => in_org_id
6201: , out_code=>out_wsh
6202: , out_name =>out_wsh_name
6203: );

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

6226: out_user_item_type := null;
6227:
6228: END IF;
6229: IF l_debug_level > 0 THEN
6230: oe_debug_pub.add( 'EXITING oe_oe_pricing_availability.GET_ITEM_INFO'||
6231: ' ITEM_STATUS ='||OUT_ITEM_STATUS ) ;
6232: END IF;
6233:
6234: EXCEPTION

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

6238: CLOSE c_item_info;
6239: END IF;
6240:
6241: IF l_debug_level > 0 THEN
6242: oe_debug_pub.add( 'WHEN OTHERS oe_oe_pricing_availability.GET_ITEM_INFO '||
6243: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID||
6244: 'SQLCODE='||SQLCODE|| 'SQLERRM='||SQLERRM ) ;
6245: END IF;
6246:

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

7140:
7141: EXCEPTION
7142: WHEN NO_DATA_FOUND THEN
7143: IF l_debug_level > 0 THEN
7144: oe_debug_pub.add( 'oe_oe_pricing_availability.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
7145: END IF;
7146: WHEN OTHERS THEN
7147: IF l_debug_level > 0 THEN
7148: oe_debug_pub.add( 'WHEN OTHERS oe_oe_pricing_availability.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

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

7144: oe_debug_pub.add( 'oe_oe_pricing_availability.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
7145: END IF;
7146: WHEN OTHERS THEN
7147: IF l_debug_level > 0 THEN
7148: oe_debug_pub.add( 'WHEN OTHERS oe_oe_pricing_availability.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;
7149: END IF;
7150:
7151: END set_mrp_debug;
7152:

Line 7154: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,

7150:
7151: END set_mrp_debug;
7152:
7153: PROCEDURE CopyINTO_PO_RecStruc
7154: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7155: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7156: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,

Line 7155: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,

7151: END set_mrp_debug;
7152:
7153: PROCEDURE CopyINTO_PO_RecStruc
7154: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7155: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7156: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,

Line 7156: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,

7152:
7153: PROCEDURE CopyINTO_PO_RecStruc
7154: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7155: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7156: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,

Line 7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,

7153: PROCEDURE CopyINTO_PO_RecStruc
7154: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7155: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7156: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,

Line 7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,

7154: ( p_header_rec in oe_oe_pricing_availability.PA_Header_Tbl_Type,
7155: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7156: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,

Line 7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,

7155: p_line_tbl in Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7156: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,

Line 7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,

7156: p_Header_Adj_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,

Line 7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,

7157: p_Line_Adj_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,

Line 7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,

7158: p_Header_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,

Line 7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,

7159: p_Header_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7160: p_Header_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7161: p_Line_price_Att_tbl in Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7162: p_Line_Adj_Att_tbl in Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7163: p_Line_Adj_Assoc_tbl in Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7164: x_header_rec out NOCOPY /* file.sql.39 change */ OE_order_pub.Header_Rec_Type,
7165: x_line_tbl out NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
7166: x_Header_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Header_Adj_Tbl_Type,
7167: x_Line_Adj_tbl out NOCOPY /* file.sql.39 change */ Oe_Order_Pub.Line_Adj_Tbl_Type,

Line 7630: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,

7626:
7627:
7628: PROCEDURE Create_Order(
7629: in_order in varchar2,
7630: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7631: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7632: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,

Line 7631: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,

7627:
7628: PROCEDURE Create_Order(
7629: in_order in varchar2,
7630: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7631: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7632: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,

Line 7632: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,

7628: PROCEDURE Create_Order(
7629: in_order in varchar2,
7630: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7631: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7632: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,

Line 7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,

7629: in_order in varchar2,
7630: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7631: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7632: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7637: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,

Line 7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,

7630: in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
7631: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7632: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7637: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7638: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,

Line 7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,

7631: in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
7632: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7637: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7638: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7639: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,

Line 7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,

7632: in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7637: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7638: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7639: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7640: out_order_number out NOCOPY varchar2,

Line 7637: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,

7633: in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7637: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7638: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7639: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7640: out_order_number out NOCOPY varchar2,
7641: out_header_id out NOCOPY number,

Line 7638: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,

7634: in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7637: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7638: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7639: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7640: out_order_number out NOCOPY varchar2,
7641: out_header_id out NOCOPY number,
7642: out_order_total out NOCOPY number,

Line 7639: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,

7635: in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
7636: in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
7637: in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
7638: in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
7639: in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
7640: out_order_number out NOCOPY varchar2,
7641: out_header_id out NOCOPY number,
7642: out_order_total out NOCOPY number,
7643: out_order_amount out nocopy number,

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

8440: FROM fnd_id_flex_structures
8441: WHERE id_flex_code = X_Id_Flex_Code;
8442: BEGIN
8443:
8444: oe_debug_pub.add('Entering OE_OE_PRICING_AVAILABILITY.GET_FORM_STARTUP_VALUES', 1);
8445:
8446: OPEN C_Item_Flex(Item_Id_Flex_Code);
8447: FETCH C_Item_Flex INTO Item_Id_Flex_Num;
8448: CLOSE C_Item_Flex;

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

8450: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
8451:
8452: EXCEPTION
8453: WHEN OTHERS THEN
8454: oe_debug_pub.add('In when others exception : OE_OE_PRICING_AVAILABILITY.GET_FORM_STARTUP_VALUES', 1);
8455: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8456: THEN
8457: OE_MSG_PUB.Add_Exc_Msg
8458: ( G_PKG_NAME ,

Line 8514: /* 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*/

8510: return err_msg;
8511:
8512: END GET_MRP_ERR_MSG;
8513:
8514: /* 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*/
8515:
8516: FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
8517: ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
8518: ,p_order_currency IN VARCHAR2 Default NULL

Line 8610: END oe_oe_pricing_availability;

8606: END round_price;
8607:
8608: -- end bug 3440778
8609:
8610: END oe_oe_pricing_availability;