APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on AS_LEAD_LINES

Line 918: FROM as_lead_lines

914: l_sc_next_select_rec c_rep_quota_credits%ROWTYPE;
915:
916: CURSOR c_lead_line(p_lead_line_id NUMBER, p_sc_amount NUMBER) IS
917: SELECT *
918: FROM as_lead_lines
919: WHERE lead_line_id = p_lead_line_id AND total_amount <> p_sc_amount;
920:
921: BEGIN
922:

Line 1186: FROM as_lead_lines

1182: l_sc_next_select_rec c_rep_quota_credits%ROWTYPE;
1183:
1184: CURSOR c_lead_line(p_lead_line_id NUMBER, p_sc_amount NUMBER) IS
1185: SELECT *
1186: FROM as_lead_lines
1187: WHERE lead_line_id = p_lead_line_id AND total_amount <> p_sc_amount;
1188:
1189: BEGIN
1190:

Line 1462: FROM AS_LEAD_LINES_ALL

1458: WHERE lead_id = c_lead_id;
1459:
1460: CURSOR c_lines(c_lead_id NUMBER,c_lead_line_id NUMBER) IS
1461: SELECT *
1462: FROM AS_LEAD_LINES_ALL
1463: WHERE lead_id = c_lead_id
1464: AND lead_line_id = c_lead_line_id;
1465:
1466: CURSOR c_sales_credits(c_lead_id NUMBER, c_lead_line_id NUMBER , c_salesforce_id NUMBER ,c_salesgroup_id NUMBER ) IS

Line 1532: AS_LEAD_LINES_PKG.Insert_Row(

1528: FOR lr IN c_lines(p_lead_id , p_lead_line_id) LOOP
1529: l_lead_line_id := null;
1530:
1531: -- Copy lines
1532: AS_LEAD_LINES_PKG.Insert_Row(
1533: px_LEAD_LINE_ID => l_LEAD_LINE_ID,
1534: p_LAST_UPDATE_DATE => SYSDATE,
1535: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1536: p_CREATION_DATE => SYSDATE,

Line 1589: 'Private API: as_lead_lines_pkg.insert_row fail');

1585:
1586: IF l_lead_line_id is null THEN
1587: IF l_debug THEN
1588: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1589: 'Private API: as_lead_lines_pkg.insert_row fail');
1590: END IF;
1591: RAISE FND_API.G_EXC_ERROR;
1592: ELSE
1593: IF l_debug THEN

Line 1595: ' Private API: as_lead_lines_pkg.insert_row '|| l_lead_line_id);

1591: RAISE FND_API.G_EXC_ERROR;
1592: ELSE
1593: IF l_debug THEN
1594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1595: ' Private API: as_lead_lines_pkg.insert_row '|| l_lead_line_id);
1596: END IF;
1597: END IF;
1598:
1599: -- Copy Sales Credits

Line 2252: FROM as_sales_credits sc, as_lead_lines ll

2248: CURSOR c_bad_opp(p_lead_id NUMBER, p_credit_type_id NUMBER) IS
2249: SELECT sc.lead_line_id, sum(sc.credit_percent) total_percent,
2250: sum(sc.credit_amount) total_credit,
2251: max(ll.total_amount) line_amount
2252: FROM as_sales_credits sc, as_lead_lines ll
2253: WHERE sc.lead_id = p_lead_id
2254: AND sc.credit_type_id = p_credit_type_id
2255: AND ll.lead_line_id(+) = sc.lead_line_id
2256: GROUP BY sc.lead_line_id

Line 2410: update as_lead_lines_all

2406: end if;
2407: END LOOP;
2408:
2409: FORALL I IN l_lead_id.first..l_lead_id.last
2410: update as_lead_lines_all
2411: set forecast_date = NULL, rolling_forecast_flag = 'N' ,
2412: last_updated_by = FND_GLOBAL.user_id,
2413: last_update_date = sysdate,
2414: last_update_login = FND_GLOBAL.conc_login_id

Line 2453: from as_lead_lines oppl

2449: FORALL I IN l_lead_id.first..l_lead_id.last
2450: update as_sales_Credits ascr
2451: set CREDIT_PERCENT = 100 ,
2452: CREDIT_AMOUNT = (select total_amount
2453: from as_lead_lines oppl
2454: where oppl.lead_id = ascr.lead_id
2455: and oppl.lead_line_id = ascr.lead_line_id ),
2456: last_updated_by = FND_GLOBAL.user_id,
2457: last_update_date = sysdate,