DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on OE_HEADER_SCREDIT_UTIL

Line 1111: OE_Header_Scredit_Util.Convert_Miss_To_Null (l_old_Header_Scredit_rec);

1107: l_Header_Scredit_rec.db_flag := FND_API.G_FALSE;
1108:
1109: -- Set missing old record elements to NULL.
1110:
1111: OE_Header_Scredit_Util.Convert_Miss_To_Null (l_old_Header_Scredit_rec);
1112:
1113: ELSIF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1114: OR l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_DELETE
1115: THEN

Line 1125: OE_Header_Scredit_Util.Query_Row

1121: IF l_old_Header_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM
1122: OR l_old_Header_Scredit_rec.sales_credit_id IS NULL
1123: THEN
1124:
1125: OE_Header_Scredit_Util.Query_Row
1126: ( p_sales_credit_id => l_Header_Scredit_rec.sales_credit_id
1127: , x_header_scredit_rec => l_old_Header_Scredit_rec
1128: );
1129:

Line 1134: OE_Header_Scredit_Util.Convert_Miss_To_Null (l_old_Header_Scredit_rec);

1130: ELSE
1131:
1132: -- Set missing old record elements to NULL.
1133:
1134: OE_Header_Scredit_Util.Convert_Miss_To_Null (l_old_Header_Scredit_rec);
1135:
1136: END IF;
1137:
1138: -- Complete new record from old

Line 1140: OE_Header_Scredit_Util.Complete_Record

1136: END IF;
1137:
1138: -- Complete new record from old
1139:
1140: OE_Header_Scredit_Util.Complete_Record
1141: ( p_x_Header_Scredit_rec => l_Header_Scredit_rec
1142: , p_old_Header_Scredit_rec => l_old_Header_Scredit_rec
1143: );
1144:

Line 1212: OE_Header_Scredit_Util.Clear_Dependent_Attr

1208: -- Clear dependent attributes.
1209:
1210: IF l_control_rec.clear_dependents THEN
1211:
1212: OE_Header_Scredit_Util.Clear_Dependent_Attr
1213: ( p_x_Header_Scredit_rec => l_Header_Scredit_rec
1214: , p_old_Header_Scredit_rec => l_old_Header_Scredit_rec
1215: );
1216:

Line 1236: OE_Header_Scredit_Util.Apply_Attribute_Changes

1232:
1233: IF l_control_rec.change_attributes
1234: THEN
1235:
1236: OE_Header_Scredit_Util.Apply_Attribute_Changes
1237: ( p_x_Header_Scredit_rec => l_Header_Scredit_rec
1238: , p_old_Header_Scredit_rec => l_old_Header_Scredit_rec
1239: );
1240:

Line 1312: Oe_Header_Scredit_Util.Pre_Write_Process

1308: -- Step 4. Write to DB
1309:
1310: IF l_control_rec.write_to_db THEN
1311: /* Start Audit Trail */
1312: Oe_Header_Scredit_Util.Pre_Write_Process
1313: (p_x_header_scredit_rec => l_header_scredit_rec,
1314: p_old_header_scredit_rec => l_old_header_scredit_rec);
1315: /* End AuditTrail */
1316:

Line 1322: OE_Header_Scredit_Util.Delete_Row

1318: SAVEPOINT DELETE_SCREDIT_FAILED; --bug 5331854
1319: --bug 5049879
1320: 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;
1321: select booked_flag into l_booked_flag from oe_order_headers where header_id = l_header_scredit_rec.header_id;
1322: OE_Header_Scredit_Util.Delete_Row
1323: ( p_sales_credit_id => l_Header_Scredit_rec.sales_credit_id
1324: );
1325:
1326: IF nvl(l_booked_flag, 'N') = 'Y' and nvl(l_quota_flag, 'N') = 'Y' THEN

Line 1346: OE_Header_Scredit_Util.Update_Row (l_Header_Scredit_rec);

1342: l_Header_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1343:
1344: IF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1345:
1346: OE_Header_Scredit_Util.Update_Row (l_Header_Scredit_rec);
1347:
1348: ELSIF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1349:
1350: l_Header_Scredit_rec.creation_date := SYSDATE;

Line 1353: OE_Header_Scredit_Util.Insert_Row (l_Header_Scredit_rec);

1349:
1350: l_Header_Scredit_rec.creation_date := SYSDATE;
1351: l_Header_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
1352:
1353: OE_Header_Scredit_Util.Insert_Row (l_Header_Scredit_rec);
1354:
1355: END IF;
1356:
1357: END IF;

Line 10864: OE_Header_Scredit_Util.Lock_Row

10860: WHILE I IS NOT NULL LOOP
10861:
10862: IF p_x_Header_Scredit_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
10863:
10864: OE_Header_Scredit_Util.Lock_Row
10865: ( p_x_Header_Scredit_rec => p_x_Header_Scredit_tbl(I)
10866: , x_return_status => l_return_status
10867: );
10868:

Line 11390: OE_Header_Scredit_Util.Query_Rows

11386: end loop;
11387:
11388: -- Get Header_Scredit ( parent = header )
11389:
11390: OE_Header_Scredit_Util.Query_Rows
11391: ( p_header_id => p_header_id
11392: , x_Header_Scredit_tbl => x_Header_Scredit_tbl
11393: );
11394: