DBA Data[Home] [Help]

APPS.CN_PREPOST_PVT dependencies on CN_API

Line 177: IF ( (cn_api.chk_null_num_para

173: BEGIN
174: -- Initialize API return status to success
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176: -- Check for null parameters
177: IF ( (cn_api.chk_null_num_para
178: (p_num_para => p_posting_detail_rec.commission_line_id,
179: p_obj_name => 'Commission Line ID',
180: p_loading_status => x_loading_status,
181: x_loading_status => x_loading_status) ) = FND_API.G_TRUE ) THEN

Line 266: (SELECT CN_API.G_MISS_ID payment_transaction_id,

262: l_posting_batch_rec CN_PREPOSTBATCHES.posting_batch_rec_type;
263: l_profile_value VARCHAR2(1);
264:
265: CURSOR get_comm_line_rec IS
266: (SELECT CN_API.G_MISS_ID payment_transaction_id,
267: CN_PREPOSTBATCHES.G_BATCH_ID posting_batch_id,
268: --C_EXPENSE posting_type,
269:
270: cl.credited_salesrep_id,

Line 340: (SELECT CN_API.G_MISS_ID payment_transaction_id,

336: WHERE cl.commission_line_id = p_commission_line_id
337: AND cl.quota_id = pe.quota_id
338: AND cl.srp_payee_assign_id IS NULL)
339: UNION --this is added for assign payees for fixing bug#2495614
340: (SELECT CN_API.G_MISS_ID payment_transaction_id,
341: CN_PREPOSTBATCHES.G_BATCH_ID posting_batch_id,
342: payee.payee_id credited_salesrep_id,
343: payee.payee_id payee_salesrep_id,
344: cl.quota_id,