APPS.CN_PRD_QUOTA_PVT dependencies on CN_PERIOD_QUOTAS

Line 43: FROM cn_period_quotas cpq

39:
40: CURSOR l_old_prd_quota_cr
41: IS
42: SELECT *
43: FROM cn_period_quotas cpq
44: WHERE cpq.period_quota_id = p_prd_quota.period_quota_id;
45:
46: l_old_prd_quota l_old_prd_quota_cr%ROWTYPE;
47: l_prd_quota prd_quota_rec_type;

Line 52: p_period_quota_id cn_period_quotas.period_quota_id%TYPE;

48: l_temp_count NUMBER;
49: l_period_target NUMBER;
50: l_period_payment NUMBER;
51: l_performance_goal NUMBER;
52: p_period_quota_id cn_period_quotas.period_quota_id%TYPE;
53: p_period_id cn_period_quotas.period_id%TYPE;
54: p_quota_id cn_period_quotas.quota_id%TYPE;
55: p_itd_target NUMBER;
56: p_itd_payment NUMBER;

Line 53: p_period_id cn_period_quotas.period_id%TYPE;

49: l_period_target NUMBER;
50: l_period_payment NUMBER;
51: l_performance_goal NUMBER;
52: p_period_quota_id cn_period_quotas.period_quota_id%TYPE;
53: p_period_id cn_period_quotas.period_id%TYPE;
54: p_quota_id cn_period_quotas.quota_id%TYPE;
55: p_itd_target NUMBER;
56: p_itd_payment NUMBER;
57: p_quarter_num NUMBER;

Line 54: p_quota_id cn_period_quotas.quota_id%TYPE;

50: l_period_payment NUMBER;
51: l_performance_goal NUMBER;
52: p_period_quota_id cn_period_quotas.period_quota_id%TYPE;
53: p_period_id cn_period_quotas.period_id%TYPE;
54: p_quota_id cn_period_quotas.quota_id%TYPE;
55: p_itd_target NUMBER;
56: p_itd_payment NUMBER;
57: p_quarter_num NUMBER;
58: p_period_year cn_period_quotas.period_year%TYPE;

Line 58: p_period_year cn_period_quotas.period_year%TYPE;

54: p_quota_id cn_period_quotas.quota_id%TYPE;
55: p_itd_target NUMBER;
56: p_itd_payment NUMBER;
57: p_quarter_num NUMBER;
58: p_period_year cn_period_quotas.period_year%TYPE;
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT update_prd_quota;
62:

Line 80: FROM cn_period_quotas

76: x_return_status := fnd_api.g_ret_sts_success;
77:
78: SELECT COUNT (*)
79: INTO l_temp_count
80: FROM cn_period_quotas
81: WHERE period_quota_id = p_prd_quota.period_quota_id
82: AND quota_id = p_prd_quota.quota_id
83: AND period_id = p_prd_quota.period_id
84: AND org_id = p_prd_quota.org_id;

Line 133: cn_period_quotas_pkg.UPDATE_RECORD (p_period_quota_id => p_prd_quota.period_quota_id,

129: p_prd_quota.last_update_date := SYSDATE;
130: p_prd_quota.last_update_login := fnd_global.login_id;
131: p_prd_quota.last_updated_by := fnd_global.user_id;
132: -- update the table
133: cn_period_quotas_pkg.UPDATE_RECORD (p_period_quota_id => p_prd_quota.period_quota_id,
134: p_quota_id => p_prd_quota.quota_id,
135: p_period_id => p_prd_quota.period_id,
136: p_period_target => p_prd_quota.period_target,
137: p_period_payment => p_prd_quota.period_payment,

Line 149: cn_period_quotas_pkg.sync_ITD_values (x_quota_id => p_prd_quota.quota_id);

145: x_object_version_number => p_prd_quota.object_version_number
146: );
147:
148: -- sync balances
149: cn_period_quotas_pkg.sync_ITD_values (x_quota_id => p_prd_quota.quota_id);
150:
151: -- End of API body.
152: -- Standard check of p_commit.
153: IF fnd_api.to_boolean (p_commit)