APPS.OE_ORDER_PVT dependencies on OE_HEADER_SCREDIT_UTIL

Line 1074: OE_Header_Scredit_Util.Convert_Miss_To_Null (l_old_Header_Scredit_rec);

1070: l_Header_Scredit_rec.db_flag := FND_API.G_FALSE;
1071:
1072: -- Set missing old record elements to NULL.
1073:
1074: OE_Header_Scredit_Util.Convert_Miss_To_Null (l_old_Header_Scredit_rec);
1075:
1076: ELSIF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1077: OR l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_DELETE
1078: THEN

Line 1088: OE_Header_Scredit_Util.Query_Row

1084: IF l_old_Header_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM
1085: OR l_old_Header_Scredit_rec.sales_credit_id IS NULL
1086: THEN
1087:
1088: OE_Header_Scredit_Util.Query_Row
1089: ( p_sales_credit_id => l_Header_Scredit_rec.sales_credit_id
1090: , x_header_scredit_rec => l_old_Header_Scredit_rec
1091: );
1092:

Line 1097: OE_Header_Scredit_Util.Convert_Miss_To_Null (l_old_Header_Scredit_rec);

1093: ELSE
1094:
1095: -- Set missing old record elements to NULL.
1096:
1097: OE_Header_Scredit_Util.Convert_Miss_To_Null (l_old_Header_Scredit_rec);
1098:
1099: END IF;
1100:
1101: -- Complete new record from old

Line 1103: OE_Header_Scredit_Util.Complete_Record

1099: END IF;
1100:
1101: -- Complete new record from old
1102:
1103: OE_Header_Scredit_Util.Complete_Record
1104: ( p_x_Header_Scredit_rec => l_Header_Scredit_rec
1105: , p_old_Header_Scredit_rec => l_old_Header_Scredit_rec
1106: );
1107:

Line 1175: OE_Header_Scredit_Util.Clear_Dependent_Attr

1171: -- Clear dependent attributes.
1172:
1173: IF l_control_rec.clear_dependents THEN
1174:
1175: OE_Header_Scredit_Util.Clear_Dependent_Attr
1176: ( p_x_Header_Scredit_rec => l_Header_Scredit_rec
1177: , p_old_Header_Scredit_rec => l_old_Header_Scredit_rec
1178: );
1179:

Line 1199: OE_Header_Scredit_Util.Apply_Attribute_Changes

1195:
1196: IF l_control_rec.change_attributes
1197: THEN
1198:
1199: OE_Header_Scredit_Util.Apply_Attribute_Changes
1200: ( p_x_Header_Scredit_rec => l_Header_Scredit_rec
1201: , p_old_Header_Scredit_rec => l_old_Header_Scredit_rec
1202: );
1203:

Line 1275: Oe_Header_Scredit_Util.Pre_Write_Process

1271: -- Step 4. Write to DB
1272:
1273: IF l_control_rec.write_to_db THEN
1274: /* Start Audit Trail */
1275: Oe_Header_Scredit_Util.Pre_Write_Process
1276: (p_x_header_scredit_rec => l_header_scredit_rec,
1277: p_old_header_scredit_rec => l_old_header_scredit_rec);
1278: /* End AuditTrail */
1279:

Line 1285: OE_Header_Scredit_Util.Delete_Row

1281: SAVEPOINT DELETE_SCREDIT_FAILED; --bug 5331854
1282: --bug 5049879
1283: select quota_flag into l_quota_flag from oe_sales_credit_types where sales_credit_type_id = l_header_scredit_rec.sales_credit_type_id;
1284: select booked_flag into l_booked_flag from oe_order_headers where header_id = l_header_scredit_rec.header_id;
1285: OE_Header_Scredit_Util.Delete_Row
1286: ( p_sales_credit_id => l_Header_Scredit_rec.sales_credit_id
1287: );
1288:
1289: IF nvl(l_booked_flag, 'N') = 'Y' and nvl(l_quota_flag, 'N') = 'Y' THEN

Line 1309: OE_Header_Scredit_Util.Update_Row (l_Header_Scredit_rec);

1305: l_Header_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1306:
1307: IF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1308:
1309: OE_Header_Scredit_Util.Update_Row (l_Header_Scredit_rec);
1310:
1311: ELSIF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1312:
1313: l_Header_Scredit_rec.creation_date := SYSDATE;

Line 1316: OE_Header_Scredit_Util.Insert_Row (l_Header_Scredit_rec);

1312:
1313: l_Header_Scredit_rec.creation_date := SYSDATE;
1314: l_Header_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
1315:
1316: OE_Header_Scredit_Util.Insert_Row (l_Header_Scredit_rec);
1317:
1318: END IF;
1319:
1320: END IF;

Line 10635: OE_Header_Scredit_Util.Lock_Row

10631: WHILE I IS NOT NULL LOOP
10632:
10633: IF p_x_Header_Scredit_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
10634:
10635: OE_Header_Scredit_Util.Lock_Row
10636: ( p_x_Header_Scredit_rec => p_x_Header_Scredit_tbl(I)
10637: , x_return_status => l_return_status
10638: );
10639:

Line 11161: OE_Header_Scredit_Util.Query_Rows

11157: end loop;
11158:
11159: -- Get Header_Scredit ( parent = header )
11160:
11161: OE_Header_Scredit_Util.Query_Rows
11162: ( p_header_id => p_header_id
11163: , x_Header_Scredit_tbl => x_Header_Scredit_tbl
11164: );
11165: