APPS.CN_PREPOST_PVT dependencies on CN_COMMISSION_LINES

Line 149: -- CN_COMMISSION_LINES is already valid.

145: -- Procedure : Validate_PrePostDetails
146: -- Description : This procedure is used to validate the parameters that
147: -- have been passed to create a posting detail.
148: -- This procedure assumes that information gathered from
149: -- CN_COMMISSION_LINES is already valid.
150: -- Note : Procedure has been overloaded to accommodate a
151: -- commission_line_id and a posting detail record type.
152: -- Calls :
153: -- CAN YOU REVERT A NON COMMISSION LINE BASED TRX?

Line 171: FROM cn_commission_lines

167: l_cl_status VARCHAR2(30);
168: l_posting_status VARCHAR2(30);
169: CURSOR get_comm_line IS
170: SELECT status, NVL(posting_status, C_UNPOSTED)
171: FROM cn_commission_lines
172: WHERE commission_line_id = p_posting_detail_rec.commission_line_id;
173: BEGIN
174: -- Initialize API return status to success
175: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 331: FROM cn_commission_lines_all cl,

327: SYSDATE creation_date,
328: FND_GLOBAL.LOGIN_ID last_update_login,
329: SYSDATE last_update_date,
330: FND_GLOBAL.USER_ID last_updated_by*/
331: FROM cn_commission_lines_all cl,
332: -- cn_srp_plan_assigns srcp,
333: --cn_srp_payee_assigns srpa, removed for payee assigns bug #2495614
334: -- cn_role_plans rcp,
335: cn_quotas_all pe

Line 391: FROM cn_commission_lines_all cl,

387: null, --cl.attribute14,
388: null, --cl.attribute15
389: cl.org_id,
390: 0
391: FROM cn_commission_lines_all cl,
392: -- cn_srp_plan_assigns srcp,
393: cn_srp_payee_assigns_all payee,
394: -- cn_role_plans rcp,
395: cn_quotas_all pe

Line 516: UPDATE cn_commission_lines

512: --END IF;
513:
514: -- if NEW then Update commission line posting status to POSTED
515: /* IF p_create_mode = 'NEW' THEN
516: UPDATE cn_commission_lines
517: SET posting_status = C_POSTED
518: WHERE commission_line_id = p_commission_line_id;*/
519: -- REMOVE COMMENT WHEN UPDATED WITH COMM LINE API
520: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 525: UPDATE cn_commission_lines_all

521: -- RAISE FND_API.G_EXC_ERROR;
522: -- END IF;
523: -- if REVERT then Update commission line posting status to REVERTED
524: IF p_create_mode = 'REVERT' THEN
525: UPDATE cn_commission_lines_all
526: SET posting_status = C_REVERTED
527: WHERE commission_line_id = p_commission_line_id;
528: END IF;
529: END IF;