DBA Data[Home] [Help]

APPS.OE_RELATED_ITEMS_PVT dependencies on OE_RELATED_ITEMS_PVT

Line 1: PACKAGE BODY Oe_Related_Items_Pvt AS

1: PACKAGE BODY Oe_Related_Items_Pvt AS
2: /* $Header: OEXFRELB.pls 120.5.12020000.2 2012/07/03 09:55:07 amallik ship $ */
3:
4: -- Global variables
5:

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

2: /* $Header: OEXFRELB.pls 120.5.12020000.2 2012/07/03 09:55:07 amallik ship $ */
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;

Line 219: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.DEFAULTING '||

215: --
216: BEGIN
217:
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.DEFAULTING '||
220: 'ITEM_ID='||P_RELATED_ITEM_ID||
221: 'ORG ID TYPE ='||P_ORG_ID||
222: 'CUSTOMER_ID ='||P_CUST_ACCOUNT_ID||
223: 'SHIP_TO_ORG_ID ='||P_SHIP_TO_ORG_ID||

Line 294: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.DEFAULTING' ) ;

290: END IF;
291:
292:
293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.DEFAULTING' ) ;
295: END IF;
296:
297: EXCEPTION
298:

Line 899: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;

895: --
896: BEGIN
897:
898: IF l_debug_level > 0 THEN
899: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;
900: oe_debug_pub.add( ' line index in copy header to request'||l_line_index);
901: END IF;
902:
903: l_line_index := l_line_index+1;

Line 935: oe_debug_pub.add( 'EXITING OE_OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' ) ;

931:
932: --px_req_line_tbl(l_line_index).price_request_code := p_header_rec.price_request_code; -- PROMOTIONS SEP/01
933:
934: IF l_debug_level > 0 THEN
935: oe_debug_pub.add( 'EXITING OE_OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' ) ;
936: END IF;
937:
938: END copy_Header_to_request;
939:

Line 957: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;

953: --
954: begin
955:
956: IF l_debug_level > 0 THEN
957: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
958: oe_debug_pub.add( 'line index in copy line to request'||l_line_index);
959: END IF;
960:
961: l_line_index := l_line_index+1;

Line 1029: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;

1025: --px_req_line_tbl(l_line_index).price_request_code := p_line_rec.price_request_code; -- PROMOTIONS SEP/01
1026: --px_req_line_tbl(l_line_index).line_category :=p_line_rec.line_category_code;
1027:
1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
1030: END IF;
1031:
1032: END copy_Line_to_request;
1033:

Line 1083: oe_debug_pub.add( 'BEFORE OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;

1079: --
1080: BEGIN
1081:
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add( 'BEFORE OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1084: END IF;
1085:
1086: IF l_debug_level > 0 THEN
1087: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||

Line 1141: oe_debug_pub.add( 'EXIT OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;

1137: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1138: );
1139:
1140: IF l_debug_level > 0 THEN
1141: oe_debug_pub.add( 'EXIT OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1142: END IF;
1143:
1144: EXCEPTION
1145: when no_data_found then

Line 1170: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;

1166: --
1167: BEGIN
1168:
1169: IF l_debug_level > 0 THEN
1170: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;
1171: END IF;
1172: i := p_pricing_contexts_Tbl.First;
1173: While i is not null loop
1174: l_attr_index := l_attr_index +1;

Line 1221: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;

1217: i := p_qualifier_contexts_Tbl.Next(i);
1218: end loop;
1219:
1220: IF l_debug_level > 0 THEN
1221: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;
1222: END IF;
1223:
1224: END copy_attribs_to_Req;
1225:

Line 1357: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;

1353: --
1354: BEGIN
1355:
1356: IF l_debug_level > 0 THEN
1357: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;
1358: END IF;
1359:
1360: IF g_PRICING_ATTRIBUTE1 is not null then
1361: i := px_Req_line_attr_tbl.count+1;

Line 2266: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;

2262: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From:=g_PRICING_ATTRIBUTE100;
2263: end if;
2264:
2265: IF l_debug_level > 0 THEN
2266: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;
2267: END IF;
2268:
2269: END Append_attributes;
2270:

Line 3850: END Oe_Related_Items_Pvt;

3846: g_total2 := l_hsecs;
3847: END IF;
3848:
3849: END print_time2;
3850: END Oe_Related_Items_Pvt;