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_MARK_EVENTS_PKG dependencies on CN_CALC_SQL_EXPS_PVT

Line 1881: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

1877: temp_quota_id cn_quotas.quota_id%TYPE;
1878: l_return_status VARCHAR2(50);
1879: l_msg_count NUMBER;
1880: l_msg_data VARCHAR2(2000);
1881: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
1882: BEGIN
1883: -- Log the Event for the Quota changes or any changes in the
1884: -- Plan Element.
1885: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

Line 1911: cn_calc_sql_exps_pvt.get_parent_plan_elts(

1907: );
1908:
1909: -- clku, move get_parent_plan_elts outside the period/salesrep loop
1910: IF (p_object_id IS NOT NULL) THEN
1911: cn_calc_sql_exps_pvt.get_parent_plan_elts(
1912: p_api_version => 1.0
1913: , p_node_type => 'P'
1914: , p_init_msg_list => 'T'
1915: , p_node_id => p_object_id

Line 2228: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

2224: temp_quota_id cn_quotas.quota_id%TYPE;
2225: l_return_status VARCHAR2(50);
2226: l_msg_count NUMBER;
2227: l_msg_data VARCHAR2(2000);
2228: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
2229: BEGIN
2230: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2231: RETURN;
2232: END IF;

Line 2256: cn_calc_sql_exps_pvt.get_parent_plan_elts(

2252: );
2253:
2254: -- clku, move get_parent_plan_elts outside the period/salesrep loop
2255: IF (p_object_id IS NOT NULL) THEN
2256: cn_calc_sql_exps_pvt.get_parent_plan_elts(
2257: p_api_version => 1.0
2258: , p_node_type => 'P'
2259: , p_init_msg_list => 'T'
2260: , p_node_id => p_object_id

Line 2465: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

2461: temp_quota_id cn_quotas.quota_id%TYPE;
2462: l_return_status VARCHAR2(50);
2463: l_msg_count NUMBER;
2464: l_msg_data VARCHAR2(2000);
2465: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
2466: BEGIN
2467: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2468: RETURN;
2469: END IF;

Line 2505: cn_calc_sql_exps_pvt.get_parent_plan_elts(

2501: l_end_period_id := cn_api.get_acc_period_id(l_end_date, p_org_id);
2502:
2503: -- clku, move get_parent_plan_elts outside the period/salesrep loop
2504: IF (p_object_id IS NOT NULL) THEN
2505: cn_calc_sql_exps_pvt.get_parent_plan_elts(
2506: p_api_version => 1.0
2507: , p_node_type => 'P'
2508: , p_init_msg_list => 'T'
2509: , p_node_id => p_object_id

Line 3036: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

3032: temp_quota_id cn_quotas.quota_id%TYPE;
3033: l_return_status VARCHAR2(50);
3034: l_msg_count NUMBER;
3035: l_msg_data VARCHAR2(2000);
3036: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3037: l_latest_quota_id NUMBER := 0;
3038: l_event_log_id NUMBER;
3039: BEGIN
3040: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

Line 3067: cn_calc_sql_exps_pvt.get_parent_plan_elts(

3063:
3064: IF (p_event_name = 'CHANGE_FORMULA') THEN
3065: FOR srp_quota IN affected_srp_period_quotas LOOP
3066: IF l_latest_quota_id <> srp_quota.quota_id THEN
3067: cn_calc_sql_exps_pvt.get_parent_plan_elts(
3068: p_api_version => 1.0
3069: , p_node_type => 'P'
3070: , p_init_msg_list => 'T'
3071: , p_node_id => srp_quota.quota_id

Line 3191: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

3187: temp_quota_id cn_quotas.quota_id%TYPE;
3188: l_return_status VARCHAR2(50);
3189: l_msg_count NUMBER;
3190: l_msg_data VARCHAR2(2000);
3191: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3192: l_latest_quota_id NUMBER := 0;
3193: BEGIN
3194: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3195: RETURN;

Line 3221: cn_calc_sql_exps_pvt.get_parent_plan_elts(

3217:
3218: IF (p_event_name IN('CHANGE_RT_TIER', 'CHANGE_RT_TIER_INS_DEL')) THEN
3219: FOR srp_quota IN affected_srp_period_quotas LOOP
3220: IF l_latest_quota_id <> srp_quota.quota_id THEN
3221: cn_calc_sql_exps_pvt.get_parent_plan_elts(
3222: p_api_version => 1.0
3223: , p_node_type => 'P'
3224: , p_init_msg_list => 'T'
3225: , p_node_id => srp_quota.quota_id

Line 3347: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

3343: temp_quota_id cn_quotas.quota_id%TYPE;
3344: l_return_status VARCHAR2(50);
3345: l_msg_count NUMBER;
3346: l_msg_data VARCHAR2(2000);
3347: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3348: l_latest_quota_id NUMBER := 0;
3349: BEGIN
3350: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3351: RETURN;

Line 3377: cn_calc_sql_exps_pvt.get_parent_plan_elts(

3373:
3374: IF (p_event_name IN('CHANGE_RT_TIER', 'CHANGE_RT_TIER_INS_DEL')) THEN
3375: FOR srp_quota IN affected_srp_period_quotas LOOP
3376: IF l_latest_quota_id <> srp_quota.quota_id THEN
3377: cn_calc_sql_exps_pvt.get_parent_plan_elts(
3378: p_api_version => 1.0
3379: , p_node_type => 'P'
3380: , p_init_msg_list => 'T'
3381: , p_node_id => srp_quota.quota_id

Line 3489: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

3485: temp_quota_id cn_quotas.quota_id%TYPE;
3486: l_return_status VARCHAR2(50);
3487: l_msg_count NUMBER;
3488: l_msg_data VARCHAR2(2000);
3489: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3490: l_latest_quota_id NUMBER := 0;
3491: BEGIN
3492: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3493: fnd_log.STRING(

Line 3503: cn_calc_sql_exps_pvt.get_parent_plan_elts(

3499:
3500: IF (p_event_name = 'CHANGE_PERIOD_INTERVAL_NUMBER') THEN
3501: FOR srp_quota IN affected_srp_period_quotas LOOP
3502: IF l_latest_quota_id <> srp_quota.quota_id THEN
3503: cn_calc_sql_exps_pvt.get_parent_plan_elts(
3504: p_api_version => 1.0
3505: , p_node_type => 'P'
3506: , p_init_msg_list => 'T'
3507: , p_node_id => srp_quota.quota_id

Line 3888: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

3884: temp_quota_id cn_quotas.quota_id%TYPE;
3885: l_return_status VARCHAR2(50);
3886: l_msg_count NUMBER;
3887: l_msg_data VARCHAR2(2000);
3888: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3889: l_latest_quota_id NUMBER := 0;
3890: BEGIN
3891: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3892: RETURN;

Line 3918: cn_calc_sql_exps_pvt.get_parent_plan_elts(

3914:
3915: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
3916: FOR srp_quota IN affected_srp_period_quotas LOOP
3917: IF l_latest_quota_id <> srp_quota.quota_id THEN
3918: cn_calc_sql_exps_pvt.get_parent_plan_elts(
3919: p_api_version => 1.0
3920: , p_node_type => 'P'
3921: , p_init_msg_list => 'T'
3922: , p_node_id => srp_quota.quota_id

Line 4053: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

4049: temp_quota_id cn_quotas.quota_id%TYPE;
4050: l_return_status VARCHAR2(50);
4051: l_msg_count NUMBER;
4052: l_msg_data VARCHAR2(2000);
4053: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4054: l_latest_quota_id NUMBER := 0;
4055: BEGIN
4056: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4057: RETURN;

Line 4090: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4086: , p_start_date_old
4087: , p_end_date_old
4088: ) LOOP
4089: IF l_latest_quota_id <> srp_quota.quota_id THEN
4090: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4091: p_api_version => 1.0
4092: , p_node_type => 'P'
4093: , p_init_msg_list => 'T'
4094: , p_node_id => srp_quota.quota_id

Line 4215: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

4211: temp_quota_id cn_quotas.quota_id%TYPE;
4212: l_return_status VARCHAR2(50);
4213: l_msg_count NUMBER;
4214: l_msg_data VARCHAR2(2000);
4215: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4216: l_latest_quota_id NUMBER := 0;
4217: BEGIN
4218: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4219: RETURN;

Line 4247: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4243:
4244: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
4245: FOR srp_quota IN affected_srp_period_quotas(l_srp_start_period_id, l_srp_end_period_id) LOOP
4246: IF l_latest_quota_id <> srp_quota.quota_id THEN
4247: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4248: p_api_version => 1.0
4249: , p_node_type => 'P'
4250: , p_init_msg_list => 'T'
4251: , p_node_id => srp_quota.quota_id

Line 4357: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

4353: temp_quota_id cn_quotas.quota_id%TYPE;
4354: l_return_status VARCHAR2(50);
4355: l_msg_count NUMBER;
4356: l_msg_data VARCHAR2(2000);
4357: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4358: l_latest_quota_id NUMBER := 0;
4359: BEGIN
4360: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4361: RETURN;

Line 4387: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4383:
4384: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
4385: FOR srp_quota IN affected_srp_period_quotas LOOP
4386: IF l_latest_quota_id <> srp_quota.quota_id THEN
4387: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4388: p_api_version => 1.0
4389: , p_node_type => 'P'
4390: , p_init_msg_list => 'T'
4391: , p_node_id => srp_quota.quota_id

Line 4477: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

4473: l_return_status VARCHAR2(50);
4474: l_msg_count NUMBER;
4475: l_msg_data VARCHAR2(2000);
4476: l_event_log_id NUMBER(15);
4477: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4478: BEGIN
4479: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4480: RETURN;
4481: END IF;

Line 4504: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4500: , p_org_id
4501: );
4502:
4503: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
4504: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4505: p_api_version => 1.0
4506: , p_node_type => 'P'
4507: , p_init_msg_list => 'T'
4508: , p_node_id => p_quota_id

Line 4649: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

4645: temp_quota_id cn_quotas.quota_id%TYPE;
4646: l_return_status VARCHAR2(50);
4647: l_msg_count NUMBER;
4648: l_msg_data VARCHAR2(2000);
4649: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4650: l_latest_quota_id NUMBER := 0;
4651: BEGIN
4652: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4653: RETURN;

Line 4687: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4683: , p_start_date_old
4684: , p_end_date_old
4685: ) LOOP
4686: IF l_latest_quota_id <> srp_quota.quota_id THEN
4687: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4688: p_api_version => 1.0
4689: , p_node_type => 'P'
4690: , p_init_msg_list => 'T'
4691: , p_node_id => srp_quota.quota_id

Line 4757: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4753: , l_date_range_tbl(l_ctr).start_date
4754: , l_date_range_tbl(l_ctr).end_date
4755: ) LOOP
4756: IF l_latest_quota_id <> srp_quota.quota_id THEN
4757: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4758: p_api_version => 1.0
4759: , p_node_type => 'P'
4760: , p_init_msg_list => 'T'
4761: , p_node_id => srp_quota.quota_id