DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on OE_LINE_SCREDIT_UTIL

Line 4061: OE_Line_Scredit_Util.Convert_Miss_To_Null (l_old_Line_Scredit_rec);

4057: l_Line_Scredit_rec.db_flag := FND_API.G_FALSE;
4058:
4059: -- Set missing old record elements to NULL.
4060:
4061: OE_Line_Scredit_Util.Convert_Miss_To_Null (l_old_Line_Scredit_rec);
4062:
4063: ELSIF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE
4064: OR l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_DELETE
4065: THEN

Line 4074: OE_Line_Scredit_Util.Query_Row

4070:
4071: IF l_old_Line_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM
4072: THEN
4073:
4074: OE_Line_Scredit_Util.Query_Row
4075: ( p_sales_credit_id => l_Line_Scredit_rec.sales_credit_id
4076: , x_line_scredit_rec => l_old_Line_Scredit_rec
4077: );
4078:

Line 4083: OE_Line_Scredit_Util.Convert_Miss_To_Null (l_old_Line_Scredit_rec);

4079: ELSE
4080:
4081: -- Set missing old record elements to NULL.
4082:
4083: OE_Line_Scredit_Util.Convert_Miss_To_Null (l_old_Line_Scredit_rec);
4084:
4085: END IF;
4086:
4087: -- Complete new record from old

Line 4089: OE_Line_Scredit_Util.Complete_Record

4085: END IF;
4086:
4087: -- Complete new record from old
4088:
4089: OE_Line_Scredit_Util.Complete_Record
4090: ( p_x_Line_Scredit_rec => l_Line_Scredit_rec
4091: , p_old_Line_Scredit_rec => l_old_Line_Scredit_rec
4092: );
4093:

Line 4162: OE_Line_Scredit_Util.Clear_Dependent_Attr

4158: END IF;
4159:
4160: IF l_control_rec.clear_dependents THEN
4161:
4162: OE_Line_Scredit_Util.Clear_Dependent_Attr
4163: ( p_x_Line_Scredit_rec => l_Line_Scredit_rec
4164: , p_old_Line_Scredit_rec => l_old_Line_Scredit_rec
4165: );
4166:

Line 4192: OE_Line_Scredit_Util.Apply_Attribute_Changes

4188:
4189: IF l_control_rec.change_attributes
4190: THEN
4191:
4192: OE_Line_Scredit_Util.Apply_Attribute_Changes
4193: ( p_x_Line_Scredit_rec => l_Line_Scredit_rec
4194: , p_old_Line_Scredit_rec => l_old_Line_Scredit_rec
4195: );
4196:

Line 4274: Oe_line_Scredit_Util.Pre_Write_Process

4270:
4271: IF l_control_rec.write_to_db THEN
4272:
4273: /* Start Audit Trail */
4274: Oe_line_Scredit_Util.Pre_Write_Process
4275: (p_x_line_scredit_rec => l_line_scredit_rec,
4276: p_old_line_scredit_rec => l_old_line_scredit_rec);
4277: /* End AuditTrail */
4278:

Line 4281: OE_Line_Scredit_Util.Delete_Row

4277: /* End AuditTrail */
4278:
4279: IF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
4280:
4281: OE_Line_Scredit_Util.Delete_Row
4282: ( p_sales_credit_id => l_Line_Scredit_rec.sales_credit_id
4283: );
4284:
4285: ELSE

Line 4295: OE_Line_Scredit_Util.Update_Row (l_Line_Scredit_rec);

4291: l_Line_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4292:
4293: IF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4294:
4295: OE_Line_Scredit_Util.Update_Row (l_Line_Scredit_rec);
4296:
4297: ELSIF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4298:
4299: l_Line_Scredit_rec.creation_date := SYSDATE;

Line 4302: OE_Line_Scredit_Util.Insert_Row (l_Line_Scredit_rec);

4298:
4299: l_Line_Scredit_rec.creation_date := SYSDATE;
4300: l_Line_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4301:
4302: OE_Line_Scredit_Util.Insert_Row (l_Line_Scredit_rec);
4303:
4304: END IF;
4305:
4306: END IF;

Line 7163: OE_Line_Scredit_Util.Delete_Row(p_line_id =>p_x_line_scredit_tbl(I).line_id);

7159: -- Following procedure is called to fix bug 2482365
7160: -- If sales credit info is passed by the user we will honor it.
7161: -- Any sales credit record created for this line so far shall be deleted.
7162:
7163: OE_Line_Scredit_Util.Delete_Row(p_line_id =>p_x_line_scredit_tbl(I).line_id);
7164: ELSE
7165:
7166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
7167: THEN

Line 9449: OE_Line_Scredit_Util.Delete_Row(p_line_id =>l_Line_Scredit_tbl(I).line_id);

9445: -- Following procedure is called to fix bug 2482365
9446: -- If sales credit info is passed by the user we will honor it.
9447: -- Any sales credit record created for this line so far shall be deleted.
9448:
9449: OE_Line_Scredit_Util.Delete_Row(p_line_id =>l_Line_Scredit_tbl(I).line_id);
9450: ELSE
9451:
9452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
9453: THEN

Line 11039: OE_Line_Scredit_Util.Lock_Row

11035: WHILE I IS NOT NULL LOOP
11036:
11037: IF p_x_Line_Scredit_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
11038:
11039: OE_Line_Scredit_Util.Lock_Row
11040: ( p_x_Line_Scredit_rec => p_x_Line_Scredit_tbl(I)
11041: , x_return_status => l_return_status
11042: );
11043:

Line 11502: OE_Line_Scredit_Util.Query_Rows

11498:
11499: -- Get Line_Scredit ( parent = line )
11500:
11501: l_Line_Scredit_tbl.delete; --6052770
11502: OE_Line_Scredit_Util.Query_Rows
11503: ( p_line_id => x_line_tbl(I2).line_id
11504: , x_Line_Scredit_tbl => l_Line_Scredit_tbl
11505: );
11506: