eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_QUOTAS

Line 9: p_payment_group_code IN OUT NOCOPY cn_quotas.payment_group_code%TYPE

5:
6:
7: PROCEDURE validate_payment_group_code (
8: x_return_status OUT NOCOPY VARCHAR2,
9: p_payment_group_code IN OUT NOCOPY cn_quotas.payment_group_code%TYPE
10: )
11: IS
12: l_api_name CONSTANT VARCHAR2 (30) := 'validate_payment_group_code';
13: l_tmp_exist NUMBER := 0;

Line 310: FROM cn_quotas_v

306: -- Get quota_id if this plan element already exist
307: BEGIN
308: SELECT quota_id
309: INTO l_pe_rec.quota_id
310: FROM cn_quotas_v
311: WHERE NAME = l_pe_rec.NAME
312: and org_id = l_pe_rec.ORG_ID;
313:
314: x_loading_status := 'PLN_QUOTA_EXISTS';

Line 614: FROM cn_quotas_v

610: description,
611: quota_type_code,
612: calc_formula_id,
613: target
614: FROM cn_quotas_v
615: WHERE NAME = p_pe_rec.NAME;
616:
617: l_pe_csr c_pe_csr%ROWTYPE;
618: l_api_name CONSTANT VARCHAR2 (30) := 'chk_pe_consistent';

Line 1532: pe_name cn_quotas.NAME%TYPE

1528: l_same_pe NUMBER;
1529: l_loading_status VARCHAR2 (80);
1530:
1531: CURSOR c_pe_rec_old_csr (
1532: pe_name cn_quotas.NAME%TYPE
1533: )
1534: IS
1535: SELECT q.quota_id
1536: FROM cn_quotas_v q

Line 1536: FROM cn_quotas_v q

1532: pe_name cn_quotas.NAME%TYPE
1533: )
1534: IS
1535: SELECT q.quota_id
1536: FROM cn_quotas_v q
1537: WHERE q.NAME = pe_name;
1538: BEGIN
1539: -- Initialize API return status to success
1540: x_return_status := fnd_api.g_ret_sts_success;

Line 1821: pe_name cn_quotas.NAME%TYPE

1817: l_same_pe NUMBER;
1818: l_loading_status VARCHAR2 (80);
1819:
1820: CURSOR c_pe_rec_old_csr (
1821: pe_name cn_quotas.NAME%TYPE
1822: )
1823: IS
1824: SELECT q.quota_id,
1825: q.calc_formula_id,

Line 1831: FROM cn_quotas_v q

1827: -- clku, 5/9/2002
1828: q.quota_type_code,
1829: q.start_date,
1830: q.end_date
1831: FROM cn_quotas_v q
1832: WHERE q.NAME = pe_name;
1833: BEGIN
1834: -- Initialize API return status to success
1835: x_return_status := fnd_api.g_ret_sts_success;

Line 2217: cn_quotas_pkg.begin_record (x_operation => 'INSERT',

2213: --clku, bug 2854576
2214: -- fmburu r12
2215:
2216: -- Plan Element does not exits, Create the New Plan Element
2217: cn_quotas_pkg.begin_record (x_operation => 'INSERT',
2218: x_org_id => l_pe_rec.org_id,
2219: x_object_version_number => l_pe_rec.object_version_number,
2220: x_rowid => g_rowid,
2221: x_indirect_credit => l_pe_rec.indirect_credit,

Line 2802: pe_quota_id cn_quotas.quota_id%TYPE

2798: l_status VARCHAR2(1);
2799: p_payment_group_code l_p_new_plan_element_rec.payment_group_code%type;
2800:
2801: CURSOR c_srp_period_quota_csr (
2802: pe_quota_id cn_quotas.quota_id%TYPE
2803: )
2804: IS
2805: SELECT srp_period_quota_id,org_id
2806: FROM cn_srp_period_quotas

Line 2818: FROM cn_quotas_v cq,

2814: l_quota_id NUMBER
2815: )
2816: IS
2817: SELECT ccf.number_dim
2818: FROM cn_quotas_v cq,
2819: cn_calc_formulas ccf
2820: WHERE cq.quota_id = l_quota_id AND cq.calc_formula_id = ccf.calc_formula_id;
2821: BEGIN
2822: -- Standard Start of API savepoint

Line 3000: cn_quotas_pkg.begin_record (x_operation => 'UPDATE',

2996: ELSIF (x_loading_status = 'CN_UPDATED')
2997: THEN
2998: l_pe_rec.quota_id := l_pe_rec_old.quota_id;
2999: -- Table Handler
3000: cn_quotas_pkg.begin_record (x_operation => 'UPDATE',
3001: x_org_id => l_pe_rec.org_id,
3002: x_object_version_number => l_pe_rec.object_version_number,
3003: x_indirect_credit => l_pe_rec.indirect_credit,
3004: x_rowid => g_rowid,

Line 3579: -- CN_QUOTAS, CN_QUOTA_RULES, CN_RT_QUOTA_ASGNS

3575: -- Type : Public
3576: -- Pre-reqs : None.
3577: -- Purpose : The following API performs the following
3578: -- 1. Deletes the Plan Element and it's associated records in
3579: -- CN_QUOTAS, CN_QUOTA_RULES, CN_RT_QUOTA_ASGNS
3580: -- 2.
3581: -- 3.
3582: -- Parameters :
3583: -- IN : p_api_version IN NUMBER API version

Line 3621: l_p_quota_name cn_quotas.NAME%TYPE;

3617: )
3618: IS
3619: l_api_name CONSTANT VARCHAR2 (30) := 'process_input_records';
3620: l_api_version CONSTANT NUMBER := 1.0;
3621: l_p_quota_name cn_quotas.NAME%TYPE;
3622: l_loading_status VARCHAR2 (80);
3623: l_org_id cn_quotas.org_id%TYPE;
3624: l_quota_id cn_quotas.quota_id%TYPE;
3625: BEGIN

Line 3623: l_org_id cn_quotas.org_id%TYPE;

3619: l_api_name CONSTANT VARCHAR2 (30) := 'process_input_records';
3620: l_api_version CONSTANT NUMBER := 1.0;
3621: l_p_quota_name cn_quotas.NAME%TYPE;
3622: l_loading_status VARCHAR2 (80);
3623: l_org_id cn_quotas.org_id%TYPE;
3624: l_quota_id cn_quotas.quota_id%TYPE;
3625: BEGIN
3626: -- Standard Start of API savepoint
3627: SAVEPOINT process_input_records;

Line 3624: l_quota_id cn_quotas.quota_id%TYPE;

3620: l_api_version CONSTANT NUMBER := 1.0;
3621: l_p_quota_name cn_quotas.NAME%TYPE;
3622: l_loading_status VARCHAR2 (80);
3623: l_org_id cn_quotas.org_id%TYPE;
3624: l_quota_id cn_quotas.quota_id%TYPE;
3625: BEGIN
3626: -- Standard Start of API savepoint
3627: SAVEPOINT process_input_records;
3628: -- Initialize API return status to success

Line 3759: l_p_quota_name cn_quotas.NAME%TYPE;

3755: IS
3756: l_quota_id NUMBER;
3757: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Plan_Element';
3758: l_api_version CONSTANT NUMBER := 1.0;
3759: l_p_quota_name cn_quotas.NAME%TYPE;
3760: l_p_revenue_class_rec_tbl revenue_class_rec_tbl_type;
3761: l_p_rev_uplift_rec_tbl rev_uplift_rec_tbl_type;
3762:
3763: l_p_rev_uplift_rec_tbl1 cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type;

Line 3776: l_org_id cn_quotas.org_id%TYPE;

3772: g_last_update_login NUMBER := fnd_global.login_id;
3773: g_rowid VARCHAR2 (30);
3774: g_program_type VARCHAR2 (30);
3775: l_loading_status VARCHAR2 (80);
3776: l_org_id cn_quotas.org_id%TYPE;
3777: l_pvt_rec cn_plan_element_pvt.plan_element_rec_type;
3778: l_quota_rec plan_element_rec_type;
3779: l_return_status VARCHAR2 (1000);
3780: l_msg_data VARCHAR2 (2000);

Line 4110: p_plan_element_name IN cn_quotas.NAME%TYPE,

4106: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
4107: x_return_status OUT NOCOPY VARCHAR2,
4108: x_msg_count OUT NOCOPY NUMBER,
4109: x_msg_data OUT NOCOPY VARCHAR2,
4110: p_plan_element_name IN cn_quotas.NAME%TYPE,
4111: p_org_id IN cn_quotas.org_id%TYPE,
4112: x_plan_element_rec OUT NOCOPY plan_element_rec_type,
4113: x_revenue_class_rec_tbl OUT NOCOPY revenue_class_rec_tbl_type,
4114: x_rev_uplift_rec_tbl OUT NOCOPY rev_uplift_rec_tbl_type,

Line 4111: p_org_id IN cn_quotas.org_id%TYPE,

4107: x_return_status OUT NOCOPY VARCHAR2,
4108: x_msg_count OUT NOCOPY NUMBER,
4109: x_msg_data OUT NOCOPY VARCHAR2,
4110: p_plan_element_name IN cn_quotas.NAME%TYPE,
4111: p_org_id IN cn_quotas.org_id%TYPE,
4112: x_plan_element_rec OUT NOCOPY plan_element_rec_type,
4113: x_revenue_class_rec_tbl OUT NOCOPY revenue_class_rec_tbl_type,
4114: x_rev_uplift_rec_tbl OUT NOCOPY rev_uplift_rec_tbl_type,
4115: x_trx_factor_rec_tbl OUT NOCOPY trx_factor_rec_tbl_type,

Line 4128: l_pe_name cn_quotas.NAME%TYPE;

4124: l_trx_index NUMBER;
4125: l_rt_index NUMBER;
4126: l_quota_rule_id NUMBER;
4127: l_period_index NUMBER;
4128: l_pe_name cn_quotas.NAME%TYPE;
4129: l_quota_id cn_quotas.quota_id%TYPE;
4130: l_revenue_class_id cn_quota_rules.revenue_class_id%TYPE;
4131:
4132: -- Quotas Cursor

Line 4129: l_quota_id cn_quotas.quota_id%TYPE;

4125: l_rt_index NUMBER;
4126: l_quota_rule_id NUMBER;
4127: l_period_index NUMBER;
4128: l_pe_name cn_quotas.NAME%TYPE;
4129: l_quota_id cn_quotas.quota_id%TYPE;
4130: l_revenue_class_id cn_quota_rules.revenue_class_id%TYPE;
4131:
4132: -- Quotas Cursor
4133: CURSOR c_plan_element_rec_csr (

Line 4134: pe_name cn_quotas.NAME%TYPE

4130: l_revenue_class_id cn_quota_rules.revenue_class_id%TYPE;
4131:
4132: -- Quotas Cursor
4133: CURSOR c_plan_element_rec_csr (
4134: pe_name cn_quotas.NAME%TYPE
4135: )
4136: IS
4137: SELECT q.quota_id quota_id,
4138: q.NAME,

Line 4182: FROM cn_quotas q,

4178: --CHANTHON:ADding org_id
4179: q.org_id,
4180: q.indirect_credit,
4181: q.salesreps_enddated_flag
4182: FROM cn_quotas q,
4183: cn_credit_types ct,
4184: cn_calc_formulas cf,
4185: cn_interval_types cit
4186: WHERE q.NAME = pe_name

Line 4201: pe_id cn_quotas.quota_id%TYPE

4197: AND delete_flag='N';
4198:
4199: -- Quota Rules Cursor
4200: CURSOR c_quota_rules_rec_csr (
4201: pe_id cn_quotas.quota_id%TYPE
4202: )
4203: IS
4204: SELECT qr.quota_rule_id,
4205: rc.NAME rev_class_name,

Line 4268: pe_id cn_quotas.quota_id%TYPE,

4264: ORDER BY start_date;
4265:
4266: -- Trx Factors Cursor
4267: CURSOR c_trx_factor_rec_csr (
4268: pe_id cn_quotas.quota_id%TYPE,
4269: p_quota_rule_id cn_quota_rules.quota_rule_id%TYPE
4270: )
4271: IS
4272: SELECT tf.trx_type,

Line 4281: pe_id cn_quotas.quota_id%TYPE

4277: WHERE tf.quota_id = pe_id AND tf.quota_rule_id = p_quota_rule_id;
4278:
4279: -- Period Quotas Cursor
4280: CURSOR c_period_quotas_rec_csr (
4281: pe_id cn_quotas.quota_id%TYPE
4282: )
4283: IS
4284: SELECT cn_api.get_acc_period_name (period_id,org_id) period_name,
4285: period_target,

Line 4310: pe_id cn_quotas.quota_id%TYPE

4306: WHERE quota_id = pe_id;
4307:
4308: -- Rate Quota Assigns Cursor
4309: CURSOR c_rt_quota_asgns_rec_csr (
4310: pe_id cn_quotas.quota_id%TYPE
4311: )
4312: IS
4313: SELECT cn_api.get_rate_table_name (rate_schedule_id) rate_schedule_name,
4314: cn_chk_plan_element_pkg.get_calc_formula_name (calc_formula_id) calc_formula_name,

Line 4628: p_plan_element_name IN cn_quotas.NAME%TYPE := cn_api.g_miss_char,

4624: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
4625: x_return_status OUT NOCOPY VARCHAR2,
4626: x_msg_count OUT NOCOPY NUMBER,
4627: x_msg_data OUT NOCOPY VARCHAR2,
4628: p_plan_element_name IN cn_quotas.NAME%TYPE := cn_api.g_miss_char,
4629: p_org_id IN NUMBER,
4630: x_plan_element_name OUT NOCOPY cn_quotas.NAME%TYPE,
4631: x_loading_status OUT NOCOPY VARCHAR2
4632: )

Line 4630: x_plan_element_name OUT NOCOPY cn_quotas.NAME%TYPE,

4626: x_msg_count OUT NOCOPY NUMBER,
4627: x_msg_data OUT NOCOPY VARCHAR2,
4628: p_plan_element_name IN cn_quotas.NAME%TYPE := cn_api.g_miss_char,
4629: p_org_id IN NUMBER,
4630: x_plan_element_name OUT NOCOPY cn_quotas.NAME%TYPE,
4631: x_loading_status OUT NOCOPY VARCHAR2
4632: )
4633: IS
4634: l_api_name CONSTANT VARCHAR2 (30) := 'Duplicate_Plan_Element';

Line 4647: l_p_plan_element_name cn_quotas.NAME%TYPE;

4643: l_length INTEGER := 30 - LENGTHB ('_2');
4644: l_name_too_long VARCHAR2 (1) := 'F';
4645: l_quota_id NUMBER;
4646: l_warning_flag VARCHAR2 (1) := 'F';
4647: l_p_plan_element_name cn_quotas.NAME%TYPE;
4648: l_x_plan_element_name cn_quotas.NAME%TYPE;
4649: l_oai_array jtf_usr_hks.oai_data_array_type;
4650: l_bind_data_id NUMBER;
4651: l_org_id NUMBER;

Line 4648: l_x_plan_element_name cn_quotas.NAME%TYPE;

4644: l_name_too_long VARCHAR2 (1) := 'F';
4645: l_quota_id NUMBER;
4646: l_warning_flag VARCHAR2 (1) := 'F';
4647: l_p_plan_element_name cn_quotas.NAME%TYPE;
4648: l_x_plan_element_name cn_quotas.NAME%TYPE;
4649: l_oai_array jtf_usr_hks.oai_data_array_type;
4650: l_bind_data_id NUMBER;
4651: l_org_id NUMBER;
4652: l_status VARCHAR2(1);

Line 4789: SELECT quota_id into l_quota_id from cn_quotas_all where org_id = l_org_id and name = l_plan_element_rec.NAME and delete_flag = 'N';

4785: -- Added this because of the enhancement in 12.1 when inline copy was enhanced
4786: -- Get quota id
4787: --Added check for delete_flag (bug 6467453) (hanaraya)
4788:
4789: SELECT quota_id into l_quota_id from cn_quotas_all where org_id = l_org_id and name = l_plan_element_rec.NAME and delete_flag = 'N';
4790:
4791: cn_plancopy_util_pvt.get_unique_name_for_component (
4792: p_id => l_quota_id,
4793: p_org_id => l_org_id,