APPS.OE_SALES_CAN_UTIL dependencies on OE_LINE_UTIL

Line 81: OE_Line_Util.lock_Row

77: END IF;
78:
79: /* Fix for Bug 1763178. Passing line record instead of table. */
80:
81: OE_Line_Util.lock_Row
82: ( p_line_id => p_line_id,
83: p_x_line_rec => l_line_rec
84: ,x_return_status => l_return_status
85: );

Line 695: -- and OE_LINE_UTIL(OEXULINB.pls), for checking constraints

691: -- not allowed, or setting qty to zero on Booked order not
692: -- allowed, and processing of Cancelled Quantities and Flags
693: -- if the flow is a cancellation flow.
694: -- This procedure is called from OE_HEADER_UTIL(OEXUHDRB.pls)
695: -- and OE_LINE_UTIL(OEXULINB.pls), for checking constraints
696: -- on cancellation and calculating Cancelled Quantities
697: -- for Cancellation flows, or for other flows where secondary
698: -- Cancelled quantities need to be populated.
699: ---------------------------------------------------------------------------------

Line 812: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics

808: END IF;
809:
810: -- Bug 7679175 End
811:
812: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics
813: (p_x_line_rec.inventory_item_id,p_X_line_rec.ship_from_org_id,l_item_rec) THEN
814: IF l_item_rec.tracking_quantity_ind = 'PS' THEN -- INVCONV
815: if l_debug_level > 0 then
816: oe_debug_pub.add(' Get dual uom - tracking in P and S ');

Line 834: END IF; -- IF oe_line_util.dual_uom_control

830: END IF;
831:
832: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS'
833:
834: END IF; -- IF oe_line_util.dual_uom_control
835:
836: -- Bug 7679175 Start
837: -- Moving this condition to before calculating Cancelled_Quantity2, since it should
838: -- only be calculated when Cancelled_Quantity is calculated.

Line 914: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics

910: p_old_line_rec);
911: -- INVCONV
912:
913:
914: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics
915: (p_x_line_rec.inventory_item_id,p_X_line_rec.ship_from_org_id,l_item_rec) THEN
916: IF l_item_rec.tracking_quantity_ind = 'PS' THEN -- INVCONV
917: if l_debug_level > 0 then
918: oe_debug_pub.add(' Get dual uom - tracking in P and S ');

Line 936: END IF; -- IF oe_line_util.dual_uom_control

932: END IF;
933:
934: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS'
935:
936: END IF; -- IF oe_line_util.dual_uom_control
937:
938:
939:
940:

Line 1313: oe_line_util.Query_Rows( p_header_id => p_header_rec.header_id

1309: raise FND_API.G_EXC_ERROR;
1310: END IF;
1311: END IF;
1312:
1313: oe_line_util.Query_Rows( p_header_id => p_header_rec.header_id
1314: , x_line_tbl => l_line_old_tbl
1315: );
1316:
1317: --l_line_tbl := l_line_old_tbl;

Line 1691: oe_debug_pub.add( 'ENTERING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;

1687: --
1688: BEGIN
1689:
1690: IF l_debug_level > 0 THEN
1691: oe_debug_pub.add( 'ENTERING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;
1692: END IF;
1693:
1694:
1695: -- Return fetched table

Line 1697: oe_debug_pub.add( 'EXITING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;

1693:
1694:
1695: -- Return fetched table
1696: IF l_debug_level > 0 THEN
1697: oe_debug_pub.add( 'EXITING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;
1698: END IF;
1699:
1700: RETURN l_line_tbl;
1701:

Line 1937: oe_line_util.Query_Rows( p_header_id => l_header_id

1933: IF l_debug_level > 0 THEN
1934: oe_debug_pub.add( 'CANCEL REMAINING ORDER HEADER ID: '||L_HEADER_ID ) ;
1935: END IF;
1936:
1937: oe_line_util.Query_Rows( p_header_id => l_header_id
1938: , x_line_tbl => l_line_old_tbl
1939: );
1940:
1941: oe_header_util.Query_Row( p_header_id => l_header_id