APPS.CN_COMMISSION_CALC_PVT dependencies on CN_PROJ_COMPENSATION_GTT

Line 109: Procedure processRows(p_proj_comp_rec IN cn_proj_compensation_gtt%rowtype,

105: p_encoded => FND_API.G_FALSE );
106:
107: End get_Projected_Commission;
108:
109: Procedure processRows(p_proj_comp_rec IN cn_proj_compensation_gtt%rowtype,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2
113: ) IS

Line 333: UPDATE cn_proj_compensation_gtt

329: ELSE
330: l_quota_achievement := 0;
331: END IF;
332:
333: UPDATE cn_proj_compensation_gtt
334: SET PE_NAME = l_quotadetails.quota_name,
335: PROJ_COMP = l_tot_proj_comm_amt,
336: PE_QUOTA = l_tot_target_amt,
337: PE_ACHIEVED = l_quota_achievement,

Line 415: cn_proj_compensation_gtt

411:
412: CURSOR proj_comp_cr IS
413: SELECT *
414: FROM
415: cn_proj_compensation_gtt
416: WHERE salesrep_id IS NOT NULL
417: AND period_id IS NOT NULL
418: AND ruleset_id IS NOT NULL;
419:

Line 422: FROM cn_proj_compensation_gtt

418: AND ruleset_id IS NOT NULL;
419:
420: CURSOR proj_comp_srp_cr IS
421: SELECT line_id
422: FROM cn_proj_compensation_gtt
423: WHERE salesrep_id IS NULL;
424:
425: CURSOR proj_comp_prd_cr IS
426: SELECT line_id

Line 427: FROM cn_proj_compensation_gtt

423: WHERE salesrep_id IS NULL;
424:
425: CURSOR proj_comp_prd_cr IS
426: SELECT line_id
427: FROM cn_proj_compensation_gtt
428: WHERE period_id IS NULL;
429:
430: CURSOR proj_comp_rs_cr IS
431: SELECT line_id

Line 432: FROM cn_proj_compensation_gtt

428: WHERE period_id IS NULL;
429:
430: CURSOR proj_comp_rs_cr IS
431: SELECT line_id
432: FROM cn_proj_compensation_gtt
433: WHERE ruleset_id IS NULL;
434:
435: l_projcomp proj_comp_cr%ROWTYPE;
436: l_repositories repositories_cr%ROWTYPE;

Line 480: UPDATE cn_proj_compensation_gtt cpcg

476: OPEN repositories_cr;
477: FETCH repositories_cr INTO l_repositories;
478: CLOSE repositories_cr;
479:
480: UPDATE cn_proj_compensation_gtt cpcg
481: SET line_id = cn_proj_compensation_gtt_s.NEXTVAL
482: , cpcg.period_id =
483: (
484: SELECT cps.period_id period_id

Line 481: SET line_id = cn_proj_compensation_gtt_s.NEXTVAL

477: FETCH repositories_cr INTO l_repositories;
478: CLOSE repositories_cr;
479:
480: UPDATE cn_proj_compensation_gtt cpcg
481: SET line_id = cn_proj_compensation_gtt_s.NEXTVAL
482: , cpcg.period_id =
483: (
484: SELECT cps.period_id period_id
485: FROM cn_period_statuses cps