eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on AS_SALES_CREDITS

Line 93: 'Disable AS_SALES_CREDITS_BIUD trigger');

89: -- Log
90: IF (p_debug_flag = 'Y' AND
91: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
93: 'Disable AS_SALES_CREDITS_BIUD trigger');
94: END IF;
95:
96: --
97: -- Get maximum number of possible rows in as_leads_all

Line 274: 'Enable AS_SALES_CREDITS_BIUD trigger');

270: -- Log
271: IF (p_debug_flag = 'Y' AND
272: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
274: 'Enable AS_SALES_CREDITS_BIUD trigger');
275: END IF;
276:
277: errbuf := 'Migration completed';
278: retcode := 0;

Line 358: as_sales_credits_denorm SCD

354: ,SCD.salesforce_id
355: ,SCD.sales_group_id
356: ,RANK () OVER (PARTITION BY SCD.lead_id ORDER BY SCD.sales_credit_id) RK
357: FROM
358: as_sales_credits_denorm SCD
359: WHERE
360: SCD.lead_id BETWEEN pc_start_id AND pc_end_id
361: AND SCD.credit_type_id = pc_credit_type_id
362: AND SCD.salesforce_id IS NOT NULL

Line 365: AND NOT EXISTS (SELECT 1 FROM as_sales_credits SC2

361: AND SCD.credit_type_id = pc_credit_type_id
362: AND SCD.salesforce_id IS NOT NULL
363: AND SCD.sales_group_id IS NOT NULL
364: AND SCD.partner_customer_id IS NULL
365: AND NOT EXISTS (SELECT 1 FROM as_sales_credits SC2
366: WHERE SC2.lead_id = SCD.lead_id
367: AND SC2.credit_type_id = pc_credit_type_id
368: AND SC2.sales_credit_id <> SCD.sales_credit_id
369: AND (SC2.salesforce_id <> SCD.salesforce_id

Line 402: -- Get all rows in as_sales_credits that have one salesrep for the

398: 'l_credit_type_id=' || l_credit_type_id);
399: END IF;
400:
401: --
402: -- Get all rows in as_sales_credits that have one salesrep for the
403: -- opportunity, but the salesrep is not the owner
404: --
405:
406: -- Log

Line 906: SELECT * FROM as_sales_credits

902: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
903:
904: CURSOR c_rep_quota_credits(p_lead_id NUMBER, p_credit_type_id NUMBER,
905: p_sf_id NUMBER, p_sg_id NUMBER) IS
906: SELECT * FROM as_sales_credits
907: WHERE lead_id = p_lead_id
908: AND credit_type_id = p_credit_type_id
909: AND nvl(salesforce_id, -37) = nvl(p_sf_id, -37)
910: AND nvl(salesgroup_id, -37) = nvl(p_sg_id, -37)

Line 1173: SELECT * FROM as_sales_credits

1169: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
1170:
1171: CURSOR c_rep_quota_credits(p_lead_id NUMBER,p_lead_line_id NUMBER, p_credit_type_id NUMBER,
1172: p_sf_id NUMBER, p_sg_id NUMBER) IS
1173: SELECT * FROM as_sales_credits
1174: WHERE lead_id = p_lead_id
1175: AND lead_line_id = p_lead_line_id
1176: AND credit_type_id = p_credit_type_id
1177: AND nvl(salesforce_id, -37) = nvl(p_sf_id, -37)

Line 1468: FROM AS_SALES_CREDITS

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
1467: SELECT *
1468: FROM AS_SALES_CREDITS
1469: WHERE lead_id = c_lead_id
1470: AND lead_line_id = c_lead_line_id
1471: AND ( salesforce_id = c_salesforce_id and salesgroup_id = c_salesgroup_id and credit_type_id = p_forecast_credit_type_id )
1472: AND rowNum < 2

Line 1475: FROM AS_SALES_CREDITS

1471: AND ( salesforce_id = c_salesforce_id and salesgroup_id = c_salesgroup_id and credit_type_id = p_forecast_credit_type_id )
1472: AND rowNum < 2
1473: UNION
1474: SELECT *
1475: FROM AS_SALES_CREDITS
1476: WHERE lead_id = c_lead_id
1477: AND lead_line_id = c_lead_line_id
1478: AND credit_type_id <> p_forecast_credit_type_id ;
1479:

Line 1617: AS_SALES_CREDITS_PKG.Insert_Row(

1613: l_sales_credit_rec.OPP_BEST_FORECAST_AMOUNT);
1614:
1615:
1616:
1617: AS_SALES_CREDITS_PKG.Insert_Row(
1618: px_SALES_CREDIT_ID => l_SALES_CREDIT_ID,
1619: p_LAST_UPDATE_DATE => SYSDATE,
1620: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1621: p_CREATION_DATE => SYSDATE,

Line 1671: 'Private API: as_sales_credits_pkg.insert_row fail');

1667:
1668: IF l_sales_credit_id is null THEN
1669: IF l_debug THEN
1670: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1671: 'Private API: as_sales_credits_pkg.insert_row fail');
1672: END IF;
1673:
1674: RAISE FND_API.G_EXC_ERROR;
1675: ELSE

Line 1678: 'Private API: as_sales_credits_pkg.insert_row '|| l_sales_credit_id);

1674: RAISE FND_API.G_EXC_ERROR;
1675: ELSE
1676: IF l_debug THEN
1677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1678: 'Private API: as_sales_credits_pkg.insert_row '|| l_sales_credit_id);
1679: END IF;
1680: END IF;
1681:
1682: END LOOP; -- SC loop

Line 1877: 'Disable AS_SALES_CREDITS_BIUD trigger');

1873: -- Log
1874: IF (p_debug_flag = 'Y' AND
1875: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1877: 'Disable AS_SALES_CREDITS_BIUD trigger');
1878: END IF;
1879:
1880: --
1881: -- Get maximum number of possible rows in as_leads_all

Line 2058: 'Enable AS_SALES_CREDITS_BIUD trigger');

2054: -- Log
2055: IF (p_debug_flag = 'Y' AND
2056: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2057: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
2058: 'Enable AS_SALES_CREDITS_BIUD trigger');
2059: END IF;
2060:
2061: errbuf := 'Migration completed';
2062: retcode := 0;

Line 2177: FROM as_sales_credits

2173: -- Cursor to get all leads.
2174: CURSOR c_leads_in_range(p_credit_type_id NUMBER, p_start_id NUMBER,
2175: p_end_id NUMBER) IS
2176: SELECT distinct lead_id
2177: FROM as_sales_credits
2178: WHERE lead_id BETWEEN p_start_id AND p_end_id;
2179:
2180:
2181: -- Selects Opps which have Lines with multiple quota Sales Credits.

Line 2189: FROM as_sales_credits

2185: CURSOR c_multicredit_opps(p_lead_id NUMBER,p_credit_type_id NUMBER) IS
2186: SELECT lead_id ,lead_line_id from
2187: (SELECT lead_id,lead_line_id,count(1) numofsalescredit ,
2188: SUM(decode(partner_customer_id, NULL, 0, 1)) isPartnerCredit
2189: FROM as_sales_credits
2190: WHERE lead_id = p_lead_id
2191: AND credit_type_id = p_credit_type_id
2192: GROUP BY lead_id, lead_line_id
2193: ) inlinetab

Line 2220: SELECT salesforce_id FROM as_sales_credits

2216: WHERE salesforce_id = p_salesforce_id;
2217:
2218: CURSOR c_partnerqcredits(p_lead_id NUMBER, p_credit_type_id NUMBER)
2219: IS
2220: SELECT salesforce_id FROM as_sales_credits
2221: WHERE lead_id = p_lead_id AND credit_type_id = p_credit_type_id
2222: AND partner_customer_id IS NOT NULL;
2223:
2224: -- get those credit revievers who belong to leads lines which

Line 2228: FROM as_sales_credits

2224: -- get those credit revievers who belong to leads lines which
2225: -- have more than one credit lines
2226: CURSOR c_credit_receivers(p_lead_id NUMBER, p_lead_line_id NUMBER,p_credit_type_id NUMBER) IS
2227: SELECT salesforce_id, salesgroup_id ,sum(credit_amount) credit_amount
2228: FROM as_sales_credits
2229: WHERE lead_id = p_lead_id
2230: AND lead_line_id = p_lead_line_id
2231: AND credit_type_id = p_credit_type_id
2232: and exists (select 'x'

Line 2233: FROM as_sales_credits

2229: WHERE lead_id = p_lead_id
2230: AND lead_line_id = p_lead_line_id
2231: AND credit_type_id = p_credit_type_id
2232: and exists (select 'x'
2233: FROM as_sales_credits
2234: WHERE lead_id = p_lead_id
2235: AND lead_line_id = p_lead_line_id
2236: AND credit_type_id = p_credit_type_id
2237: GROUP BY lead_id, lead_line_id

Line 2244: FROM as_sales_credits_denorm

2240:
2241:
2242: CURSOR c_lead_denorm_credits(p_lead_id NUMBER, p_credit_type_id NUMBER) IS
2243: SELECT salesforce_id, sales_group_id, employee_person_id, opp_open_status_flag
2244: FROM as_sales_credits_denorm
2245: WHERE lead_id = p_lead_id AND credit_type_id = p_credit_type_id
2246: AND partner_customer_id IS NULL;
2247:
2248: CURSOR c_bad_opp(p_lead_id NUMBER, p_credit_type_id NUMBER) IS

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 2275: FROM as_leads_all opps, as_sales_credits ascr

2271: CURSOR c_add_sales_team (p_lead_id NUMBER , p_credit_type_id NUMBER) IS
2272: SELECT DISTINCT opps.lead_id, opps.customer_id, opps.address_id,
2273: ascr.salesforce_id, ascr.person_id,
2274: ascr.SALESGROUP_ID
2275: FROM as_leads_all opps, as_sales_credits ascr
2276: WHERE opps.lead_id = ascr.lead_id
2277: AND opps.lead_id = p_lead_id
2278: --AND ascr.credit_type_id = p_credit_type_id --- both quota and non-revenue credit receivers should be in the sales team
2279: AND NOT EXISTS (

Line 2450: update as_sales_Credits ascr

2446: END LOOP;
2447:
2448: -- make sure all non quota credits are 100% for the existing opportunity
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

Line 2470: DELETE FROM as_sales_credits where sales_credit_id IN

2466: -- This is repeated inside the loop to
2467: -- ensure that if partner migration causes
2468: -- duplicate it is removed again .
2469: FORALL I IN l_lead_id.first..l_lead_id.last
2470: DELETE FROM as_sales_credits where sales_credit_id IN
2471: (SELECT sales_credit_id
2472: FROM as_sales_credits ascr,
2473: (
2474: SELECT lead_id,lead_line_id,

Line 2472: FROM as_sales_credits ascr,

2468: -- duplicate it is removed again .
2469: FORALL I IN l_lead_id.first..l_lead_id.last
2470: DELETE FROM as_sales_credits where sales_credit_id IN
2471: (SELECT sales_credit_id
2472: FROM as_sales_credits ascr,
2473: (
2474: SELECT lead_id,lead_line_id,
2475: salesforce_id,salesgroup_id,
2476: credit_type_id,

Line 2478: FROM as_sales_credits ascr1

2474: SELECT lead_id,lead_line_id,
2475: salesforce_id,salesgroup_id,
2476: credit_type_id,
2477: max(sales_credit_id) maxid
2478: FROM as_sales_credits ascr1
2479: WHERE ascr1.lead_id = l_lead_id(i)
2480: AND ascr1.credit_type_id in
2481: ( SELECT sales_credit_type_id
2482: FROM oe_sales_credit_types

Line 2508: FROM as_sales_credits asc1

2504: AND nvl(acc.team_leader_flag,'N') <> 'Y'
2505: AND (
2506: EXISTS
2507: ( SELECT 1
2508: FROM as_sales_credits asc1
2509: WHERE asc1.lead_id = acc.lead_id
2510: AND asc1.salesforce_id = acc.salesforce_id
2511: AND asc1.salesgroup_id = acc.sales_group_id )
2512: OR acc.owner_flag = 'Y');

Line 2516: DELETE FROM as_sales_credits

2512: OR acc.owner_flag = 'Y');
2513:
2514: -- delete 0% quota credits
2515: FORALL I IN l_lead_id.first..l_lead_id.last
2516: DELETE FROM as_sales_credits
2517: WHERE lead_id = l_lead_id(i)
2518: AND credit_type_id = l_forecast_credit_type_id
2519: AND NVL(CREDIT_PERCENT,0) = 0 ;
2520:

Line 2718: UPDATE as_sales_credits

2714: END IF;
2715: END IF;
2716:
2717: -- Step 3.b.ii Reassign partner quota credits to Opp owner
2718: UPDATE as_sales_credits
2719: SET salesforce_id = l_org_owner_sf_id,
2720: salesgroup_id = l_org_owner_sg_id,
2721: person_id = l_org_owner_person_id,
2722: partner_customer_id = NULL, partner_address_id = NULL,

Line 2882: UPDATE as_sales_credits

2878: END LOOP;
2879:
2880: -- Reassign partner non-quota credits to Opp owner
2881: IF l_org_owner_sf_id IS NOT NULL and l_org_owner_sg_id IS NOT NULL THEN
2882: UPDATE as_sales_credits
2883: SET salesforce_id = l_org_owner_sf_id,
2884: salesgroup_id = l_org_owner_sg_id,
2885: person_id = l_org_owner_person_id,
2886: partner_customer_id = NULL, partner_address_id = NULL,

Line 2900: update as_sales_Credits ascr

2896:
2897: -- make sure all sales credit line of the owner of the opp
2898: -- has the DEFAULTED_FROM_OWNER_FLAG flag set
2899: FORALL I IN l_lead_id.first..l_lead_id.last
2900: update as_sales_Credits ascr
2901: set DEFAULTED_FROM_OWNER_FLAG = 'Y',
2902: last_updated_by = FND_GLOBAL.user_id,
2903: last_update_date = sysdate,
2904: last_update_login = FND_GLOBAL.conc_login_id

Line 2918: DELETE FROM as_sales_credits where sales_credit_id IN

2914: --added inside loop above.
2915:
2916: -- delete duplicate non quota credits
2917: FORALL I IN l_lead_id.first..l_lead_id.last
2918: DELETE FROM as_sales_credits where sales_credit_id IN
2919: (SELECT sales_credit_id
2920: FROM as_sales_credits ascr,
2921: (
2922: SELECT lead_id,lead_line_id,

Line 2920: FROM as_sales_credits ascr,

2916: -- delete duplicate non quota credits
2917: FORALL I IN l_lead_id.first..l_lead_id.last
2918: DELETE FROM as_sales_credits where sales_credit_id IN
2919: (SELECT sales_credit_id
2920: FROM as_sales_credits ascr,
2921: (
2922: SELECT lead_id,lead_line_id,
2923: salesforce_id,salesgroup_id,
2924: credit_type_id,

Line 2926: FROM as_sales_credits ascr1

2922: SELECT lead_id,lead_line_id,
2923: salesforce_id,salesgroup_id,
2924: credit_type_id,
2925: max(sales_credit_id) maxid
2926: FROM as_sales_credits ascr1
2927: WHERE ascr1.lead_id = l_lead_id(i)
2928: AND ascr1.credit_type_id in
2929: ( SELECT sales_credit_type_id
2930: FROM oe_sales_credit_types