DBA Data[Home] [Help]

APPS.OE_OE_MULTI_LINE_SCREDIT dependencies on OE_LINE_SCREDIT_UTIL

Line 176: OE_Line_Scredit_Util.Lock_Row

172: IF P_REPLACE_CREDIT_TYPE = 'R' then -- Replace Revenue
173: FOR R_OLD_SALES_CREDIT IN C_OLD_R_SALES_CREDIT_ID(p_Line_id) LOOP
174: -- Read DB record from cache
175:
176: OE_Line_Scredit_Util.Lock_Row
177: ( p_sales_credit_id => R_OLD_SALES_CREDIT.SALES_CREDIT_ID
178: , p_x_line_scredit_rec => l_Line_Scredit_rec
179: , x_return_status => l_return_status
180: );

Line 199: OE_Line_Scredit_Util.Lock_Row

195: ELSIF P_REPLACE_CREDIT_TYPE = 'NR' then -- Replace NON Revenue
196: FOR R_OLD_SALES_CREDIT IN C_OLD_NR_SALES_CREDIT_ID(p_Line_id) LOOP
197: -- Read DB record from cache
198:
199: OE_Line_Scredit_Util.Lock_Row
200: ( p_sales_credit_id => R_OLD_SALES_CREDIT.SALES_CREDIT_ID
201: , p_x_line_scredit_rec => l_Line_Scredit_rec
202: , x_return_status => l_return_status
203: );

Line 222: OE_Line_Scredit_Util.Lock_Row

218: ELSE -- Replace both Revenue and Non-Revenue
219: FOR R_OLD_SALES_CREDIT IN C_OLD_SALES_CREDIT_ID(p_Line_id) LOOP
220: -- Read DB record from cache
221:
222: OE_Line_Scredit_Util.Lock_Row
223: ( p_sales_credit_id => R_OLD_SALES_CREDIT.SALES_CREDIT_ID
224: , p_x_line_scredit_rec => l_Line_Scredit_rec
225: , x_return_status => l_return_status
226: );