APPS.AS_OPP_LINE_PVT dependencies on AS_LEAD_LINES

Line 28: FROM as_lead_lines

24: IS
25:
26: CURSOR C_line_total IS
27: SELECT sum(total_amount) line_total
28: FROM as_lead_lines
29: WHERE lead_id = p_lead_id;
30: -- Cursor added for ASNB
31: CURSOR C_renue_opp_forst_tot IS
32: SELECT nvl(sum(OPP_FORECAST_AMOUNT),0) credit_total

Line 1115: -- Invoke table handler(AS_LEAD_LINES_PKG.Insert_Row)

1111: END IF;
1112:
1113: l_LEAD_LINE_ID := l_Line_rec.LEAD_LINE_ID;
1114:
1115: -- Invoke table handler(AS_LEAD_LINES_PKG.Insert_Row)
1116: AS_LEAD_LINES_PKG.Insert_Row(
1117: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
1118: p_LAST_UPDATE_DATE => SYSDATE,
1119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 1116: AS_LEAD_LINES_PKG.Insert_Row(

1112:
1113: l_LEAD_LINE_ID := l_Line_rec.LEAD_LINE_ID;
1114:
1115: -- Invoke table handler(AS_LEAD_LINES_PKG.Insert_Row)
1116: AS_LEAD_LINES_PKG.Insert_Row(
1117: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
1118: p_LAST_UPDATE_DATE => SYSDATE,
1119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1120: p_CREATION_DATE => SYSDATE,

Line 1477: From AS_LEAD_LINES

1473:
1474: IS
1475: Cursor C_Get_opp_line(c_LEAD_LINE_ID Number) IS
1476: Select LAST_UPDATE_DATE, TOTAL_AMOUNT
1477: From AS_LEAD_LINES
1478: WHERE LEAD_LINE_ID = c_LEAD_LINE_ID
1479: For Update NOWAIT;
1480:
1481: -- solin, for bug 1554330

Line 1774: -- Invoke table handler(AS_LEAD_LINES_PKG.Update_Row)

1770: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1771: 'Private API: Calling update table handler');
1772: END IF;
1773:
1774: -- Invoke table handler(AS_LEAD_LINES_PKG.Update_Row)
1775: AS_LEAD_LINES_PKG.Update_Row(
1776: p_LEAD_LINE_ID => l_Line_rec.LEAD_LINE_ID,
1777: p_LAST_UPDATE_DATE => SYSDATE,
1778: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 1775: AS_LEAD_LINES_PKG.Update_Row(

1771: 'Private API: Calling update table handler');
1772: END IF;
1773:
1774: -- Invoke table handler(AS_LEAD_LINES_PKG.Update_Row)
1775: AS_LEAD_LINES_PKG.Update_Row(
1776: p_LEAD_LINE_ID => l_Line_rec.LEAD_LINE_ID,
1777: p_LAST_UPDATE_DATE => SYSDATE,
1778: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1779: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 2190: -- Invoke table handler(AS_LEAD_LINES_PKG.Delete_Row)

2186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2187: 'Private API: Calling delete table handler');
2188: END IF;
2189:
2190: -- Invoke table handler(AS_LEAD_LINES_PKG.Delete_Row)
2191: AS_LEAD_LINES_PKG.Delete_Row(
2192: p_LEAD_LINE_ID => l_Line_rec.LEAD_LINE_ID);
2193:
2194: -- Delete sales credits under this line

Line 2191: AS_LEAD_LINES_PKG.Delete_Row(

2187: 'Private API: Calling delete table handler');
2188: END IF;
2189:
2190: -- Invoke table handler(AS_LEAD_LINES_PKG.Delete_Row)
2191: AS_LEAD_LINES_PKG.Delete_Row(
2192: p_LEAD_LINE_ID => l_Line_rec.LEAD_LINE_ID);
2193:
2194: -- Delete sales credits under this line
2195:

Line 2348: FROM as_lead_lines

2344: IS
2345:
2346: CURSOR C_Lead_Line_Id_Exists (c_Lead_Line_Id NUMBER) IS
2347: SELECT 'X'
2348: FROM as_lead_lines
2349: WHERE lead_line_id = c_Lead_Line_Id;
2350:
2351: l_val VARCHAR2(1);
2352: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 2712: FROM AS_LEAD_LINES_ALL

2708: IS
2709:
2710: CURSOR C_GET_OLD_PROD_CAT_INFO(l_lead_line_id NUMBER) IS
2711: SELECT PRODUCT_CATEGORY_ID, PRODUCT_CAT_SET_ID
2712: FROM AS_LEAD_LINES_ALL
2713: WHERE LEAD_LINE_ID = l_lead_line_id;
2714:
2715: l_val VARCHAR2(1);
2716: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 3336: FROM as_lead_lines

3332: IS
3333:
3334: CURSOR C_O_OPPORTUNITY_LINE_ID_Exists(c_o_opportunity_line_id NUMBER) IS
3335: SELECT 'X'
3336: FROM as_lead_lines
3337: WHERE lead_line_id = c_o_opportunity_line_id;
3338:
3339: l_val VARCHAR2(1);
3340: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);