APPS.CN_FORMULA_COMMON_PKG dependencies on CN_API

Line 89: (SELECT CN_API.G_MISS_ID payment_transaction_id,

85: IS
86: l_pmt_trans_rec CN_PMT_TRANS_PKG.pmt_trans_rec_type;
87:
88: CURSOR get_comm_line_rec IS
89: (SELECT CN_API.G_MISS_ID payment_transaction_id,
90: -1 posting_batch_id,
91: cl.credited_salesrep_id,
92: cl.credited_salesrep_id payee_salesrep_id,
93: cl.quota_id,

Line 146: (SELECT CN_API.G_MISS_ID payment_transaction_id,

142: WHERE cl.commission_line_id = p_commission_line_id
143: AND cl.quota_id = pe.quota_id
144: AND cl.srp_payee_assign_id IS NULL)
145: UNION --this is added for assign payees for fixing bug#2495614
146: (SELECT CN_API.G_MISS_ID payment_transaction_id,
147: -1 posting_batch_id,
148: payee.payee_id credited_salesrep_id,
149: payee.payee_id payee_salesrep_id,
150: cl.quota_id,

Line 958: cn_api.get_credit_info(l_credit_type_name, g_precision, g_ext_precision, l_org_id );

954: CLOSE l_quota_csr;
955:
956: l_start_period_id := get_start_period_id(p_quota_id, p_period_id);
957: l_end_period_id := get_end_period_id(p_quota_id, p_period_id);
958: cn_api.get_credit_info(l_credit_type_name, g_precision, g_ext_precision, l_org_id );
959:
960: if (p_calc_type = 'BONUS' and p_period_id = l_end_period_id ) then
961: update cn_srp_period_quotas_all
962: set commission_payed_itd = 0, commission_payed_ptd = 0