[Home] [Help]
1: PACKAGE BODY Oe_Related_Items_Pvt AS
2: /* $Header: OEXFRELB.pls 120.4 2006/09/05 19:07:11 sdatti noship $ */
3:
4: -- Global variables
5:
2: /* $Header: OEXFRELB.pls 120.4 2006/09/05 19:07:11 sdatti noship $ */
3:
4: -- Global variables
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Related_Items_Pvt';
7: G_ATP_TBL OE_ATP.atp_tbl_type;
8: G_line_id CONSTANT NUMBER := 1237;
9: G_atp_line_id CONSTANT NUMBER := -9987;
10: --g_header_id CONSTANT NUMBER :=2345;
214: --
215: BEGIN
216:
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.DEFAULTING '||
219: 'ITEM_ID='||P_RELATED_ITEM_ID||
220: 'ORG ID TYPE ='||P_ORG_ID||
221: 'CUSTOMER_ID ='||P_CUST_ACCOUNT_ID||
222: 'SHIP_TO_ORG_ID ='||P_SHIP_TO_ORG_ID||
288: END IF;
289:
290:
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.DEFAULTING' ) ;
293: END IF;
294:
295: EXCEPTION
296:
862: --
863: BEGIN
864:
865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;
867: oe_debug_pub.add( ' line index in copy header to request'||l_line_index);
868: END IF;
869:
870: l_line_index := l_line_index+1;
898:
899: --px_req_line_tbl(l_line_index).price_request_code := p_header_rec.price_request_code; -- PROMOTIONS SEP/01
900:
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add( 'EXITING OE_OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' ) ;
903: END IF;
904:
905: END copy_Header_to_request;
906:
920: --
921: begin
922:
923: IF l_debug_level > 0 THEN
924: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
925: oe_debug_pub.add( 'line index in copy line to request'||l_line_index);
926: END IF;
927:
928: l_line_index := l_line_index+1;
992: --px_req_line_tbl(l_line_index).price_request_code := p_line_rec.price_request_code; -- PROMOTIONS SEP/01
993: --px_req_line_tbl(l_line_index).line_category :=p_line_rec.line_category_code;
994:
995: IF l_debug_level > 0 THEN
996: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
997: END IF;
998:
999: END copy_Line_to_request;
1000:
1046: --
1047: BEGIN
1048:
1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'BEFORE OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1051: END IF;
1052:
1053: IF l_debug_level > 0 THEN
1054: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||
1103: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1104: );
1105:
1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add( 'EXIT OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1108: END IF;
1109:
1110: EXCEPTION
1111: when no_data_found then
1132: --
1133: BEGIN
1134:
1135: IF l_debug_level > 0 THEN
1136: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;
1137: END IF;
1138: i := p_pricing_contexts_Tbl.First;
1139: While i is not null loop
1140: l_attr_index := l_attr_index +1;
1183: i := p_qualifier_contexts_Tbl.Next(i);
1184: end loop;
1185:
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;
1188: END IF;
1189:
1190: END copy_attribs_to_Req;
1191:
1319: --
1320: BEGIN
1321:
1322: IF l_debug_level > 0 THEN
1323: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;
1324: END IF;
1325:
1326: IF g_PRICING_ATTRIBUTE1 is not null then
1327: i := px_Req_line_attr_tbl.count+1;
2228: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From:=g_PRICING_ATTRIBUTE100;
2229: end if;
2230:
2231: IF l_debug_level > 0 THEN
2232: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;
2233: END IF;
2234:
2235: END Append_attributes;
2236:
3812: g_total2 := l_hsecs;
3813: END IF;
3814:
3815: END print_time2;
3816: END Oe_Related_Items_Pvt;