DBA Data[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_LINE_ADJ_UTIL

Line 453: OE_LINE_ADJ_UTIL.CONVERT_MISS_TO_NULL( l_line_adj_rec );

449: -- #3015849
450: IF l_debug_level > 0 THEN
451: OE_DEBUG_PUB.add('Calling convert_miss_to_null for this adj record',5);
452: END IF;
453: OE_LINE_ADJ_UTIL.CONVERT_MISS_TO_NULL( l_line_adj_rec );
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'INSERTING THE ADJ RECORD '||TO_CHAR ( L_LINE_ADJ_REC.PRICE_ADJUSTMENT_ID ) , 2 ) ;
456: END IF;
457: OE_LINE_ADJ_UTIL.INSERT_ROW(p_Line_Adj_rec => l_line_adj_rec);

Line 457: OE_LINE_ADJ_UTIL.INSERT_ROW(p_Line_Adj_rec => l_line_adj_rec);

453: OE_LINE_ADJ_UTIL.CONVERT_MISS_TO_NULL( l_line_adj_rec );
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'INSERTING THE ADJ RECORD '||TO_CHAR ( L_LINE_ADJ_REC.PRICE_ADJUSTMENT_ID ) , 2 ) ;
456: END IF;
457: OE_LINE_ADJ_UTIL.INSERT_ROW(p_Line_Adj_rec => l_line_adj_rec);
458: END LOOP;
459: END IF;
460:
461: IF l_debug_level > 0 THEN

Line 3555: l_change_line_tbl Oe_Line_Adj_Util.G_CHANGED_LINE_TBL1;

3551: l_ship_set_id NUMBER := -1;
3552: l_arrival_set_id NUMBER := -1;
3553: --bug 3654553
3554: K NUMBER;
3555: l_change_line_tbl Oe_Line_Adj_Util.G_CHANGED_LINE_TBL1;
3556: l_order_has_lines Oe_Order_Adj_Pvt.Index_Tbl_Type;
3557: l_ind Number;
3558: l_ind_hdr Number;
3559:

Line 3971: Oe_Line_Adj_Util.Register_Changed_Lines

3967: /* bug 3654553 calling to register changed lines */
3968: K := l_change_line_tbl.FIRST;
3969: WHILE K IS NOT NULL
3970: LOOP
3971: Oe_Line_Adj_Util.Register_Changed_Lines
3972: ( p_line_id => l_change_line_tbl(K).line_id
3973: ,p_header_id => l_change_line_tbl(K).header_id
3974: ,p_operation => OE_GLOBALS.G_OPR_UPDATE);
3975: K := l_change_line_tbl.NEXT(K);

Line 4217: l_change_line_tbl Oe_Line_Adj_Util.G_CHANGED_LINE_TBL1;

4213: l_last_top_model NUMBER := -1;
4214: --bug 3654553
4215: J NUMBER;
4216: K NUMBER;
4217: l_change_line_tbl Oe_Line_Adj_Util.G_CHANGED_LINE_TBL1;
4218: l_order_has_lines Oe_Order_Adj_Pvt.Index_Tbl_Type;
4219: l_ind Number;
4220: l_ind_hdr Number;
4221: -- tso

Line 4388: Oe_Line_Adj_Util.Register_Changed_Lines

4384: K := l_change_line_tbl.FIRST;
4385: WHILE K is NOT NULL
4386: LOOP
4387: IF l_change_line_tbl(K).header_id = l_order_has_lines(J) THEN
4388: Oe_Line_Adj_Util.Register_Changed_Lines
4389: ( p_line_id => l_change_line_tbl(K).line_id
4390: ,p_header_id => l_change_line_tbl(K).header_id
4391: ,p_operation => OE_GLOBALS.G_OPR_UPDATE);
4392: l_change_line_tbl.delete(K);