APPS.AS_OPP_SALES_CREDIT_PVT dependencies on AS_SALES_CREDITS

Line 409: -- Invoke table handler(AS_SALES_CREDITS_PKG.Insert_Row)

405: END IF;
406: -- end 1554330
407:
408: FOR I in 1 .. l_sales_credit_count LOOP
409: -- Invoke table handler(AS_SALES_CREDITS_PKG.Insert_Row)
410:
411: X_SALES_CREDIT_out_tbl(I).return_status := FND_API.G_RET_STS_SUCCESS;
412: l_SALES_CREDIT_ID := p_SALES_CREDIT_Tbl(I).SALES_CREDIT_ID;
413:

Line 536: AS_SALES_CREDITS_PKG.Insert_Row(

532: THEN
533: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG := 'Y';
534: END IF;
535: -- End Added for ASNB
536: AS_SALES_CREDITS_PKG.Insert_Row(
537: px_SALES_CREDIT_ID => l_SALES_CREDIT_ID,
538: p_LAST_UPDATE_DATE => SYSDATE,
539: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
540: p_CREATION_DATE => SYSDATE,

Line 883: From AS_SALES_CREDITS

879: CREDIT_PERCENT,
880: CREDIT_AMOUNT,
881: -- SECURITY_GROUP_ID,
882: CREDIT_TYPE_ID
883: From AS_SALES_CREDITS
884: WHERE SALES_CREDIT_ID = c_SALES_CREDIT_ID
885: -- Hint: Developer need to provide Where clause
886: For Update NOWAIT;
887:

Line 1333: -- Invoke table handler(AS_SALES_CREDITS_PKG.Update_Row)

1329: l_sales_credit_rec.DEFAULTED_FROM_OWNER_FLAG := 'N';
1330: END IF;
1331: END IF;
1332: -- End Added for ASNB
1333: -- Invoke table handler(AS_SALES_CREDITS_PKG.Update_Row)
1334: AS_SALES_CREDITS_PKG.Update_Row(
1335: p_SALES_CREDIT_ID => l_sales_credit_rec.SALES_CREDIT_ID,
1336: p_LAST_UPDATE_DATE => SYSDATE,
1337: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 1334: AS_SALES_CREDITS_PKG.Update_Row(

1330: END IF;
1331: END IF;
1332: -- End Added for ASNB
1333: -- Invoke table handler(AS_SALES_CREDITS_PKG.Update_Row)
1334: AS_SALES_CREDITS_PKG.Update_Row(
1335: p_SALES_CREDIT_ID => l_sales_credit_rec.SALES_CREDIT_ID,
1336: p_LAST_UPDATE_DATE => SYSDATE,
1337: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1338: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 1693: FROM AS_SALES_CREDITS

1689:
1690: CURSOR C_DELETED_SALES_CREDITS( p_lead_line_id NUMBER,
1691: p_forecast_credit_type_id NUMBER )IS
1692: SELECT *
1693: FROM AS_SALES_CREDITS
1694: WHERE lead_line_id = p_lead_line_id
1695: AND credit_type_id = p_forecast_credit_type_id;
1696:
1697: -- solin, for bug 1554330

Line 2369: -- Invoke table handler(AS_SALES_CREDITS_PKG.Delete_Row)

2365: END IF;
2366: END IF;
2367: -- end 1554330
2368:
2369: -- Invoke table handler(AS_SALES_CREDITS_PKG.Delete_Row)
2370: FOR I in 1 .. P_SALES_CREDIT_tbl.count LOOP
2371:
2372: X_SALES_CREDIT_out_tbl(I).return_status := FND_API.G_RET_STS_SUCCESS;
2373:

Line 2394: AS_SALES_CREDITS_PKG.Delete_Row(

2390: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2391: 'Private API 31: Calling delete table handler');
2392: END IF;
2393:
2394: AS_SALES_CREDITS_PKG.Delete_Row(
2395: p_SALES_CREDIT_ID => p_SALES_CREDIT_tbl(I).SALES_CREDIT_ID);
2396:
2397: X_SALES_CREDIT_out_tbl(I).SALES_CREDIT_ID := p_SALES_CREDIT_tbl(I).SALES_CREDIT_ID;
2398: X_SALES_CREDIT_out_tbl(I).return_status := x_return_status;

Line 2495: FROM as_sales_credits

2491: )
2492: IS
2493: CURSOR C_Sales_Credit_Id_Exists (c_Sales_Credit_Id NUMBER) IS
2494: SELECT 'X'
2495: FROM as_sales_credits
2496: WHERE sales_credit_id = c_Sales_Credit_Id;
2497:
2498: l_val VARCHAR2(1);
2499: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 3532: FROM as_sales_credits

3528: X_Msg_Data OUT NOCOPY VARCHAR2
3529: ) is
3530: CURSOR C_dup_Sales_Credit_Exists IS
3531: SELECT 'X'
3532: FROM as_sales_credits
3533: WHERE lead_id =P_SALES_CREDIT_Rec.lead_id
3534: AND lead_line_id = P_SALES_CREDIT_Rec.lead_line_id
3535: AND salesforce_id = P_SALES_CREDIT_Rec.salesforce_id
3536: AND person_id =P_SALES_CREDIT_Rec.person_id