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 2230: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 2258: cn_calc_sql_exps_pvt.get_parent_plan_elts(

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

Line 2467: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 2507: cn_calc_sql_exps_pvt.get_parent_plan_elts(

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

Line 3038: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 3069: cn_calc_sql_exps_pvt.get_parent_plan_elts(

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

Line 3193: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 3223: cn_calc_sql_exps_pvt.get_parent_plan_elts(

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

Line 3349: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 3379: cn_calc_sql_exps_pvt.get_parent_plan_elts(

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

Line 3491: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 3505: cn_calc_sql_exps_pvt.get_parent_plan_elts(

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

Line 3892: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 3922: cn_calc_sql_exps_pvt.get_parent_plan_elts(

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

Line 4057: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 4094: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4090: , p_start_date_old
4091: , p_end_date_old
4092: ) LOOP
4093: IF l_latest_quota_id <> srp_quota.quota_id THEN
4094: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4095: p_api_version => 1.0
4096: , p_node_type => 'P'
4097: , p_init_msg_list => 'T'
4098: , p_node_id => srp_quota.quota_id

Line 4219: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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

Line 4251: cn_calc_sql_exps_pvt.get_parent_plan_elts(

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

Line 4362: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

4358: temp_quota_id cn_quotas.quota_id%TYPE;
4359: l_return_status VARCHAR2(50);
4360: l_msg_count NUMBER;
4361: l_msg_data VARCHAR2(2000);
4362: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4363: l_latest_quota_id NUMBER := 0;
4364: BEGIN
4365: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4366: RETURN;

Line 4392: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4388:
4389: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
4390: FOR srp_quota IN affected_srp_period_quotas LOOP
4391: IF l_latest_quota_id <> srp_quota.quota_id THEN
4392: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4393: p_api_version => 1.0
4394: , p_node_type => 'P'
4395: , p_init_msg_list => 'T'
4396: , p_node_id => srp_quota.quota_id

Line 4482: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

4478: l_return_status VARCHAR2(50);
4479: l_msg_count NUMBER;
4480: l_msg_data VARCHAR2(2000);
4481: l_event_log_id NUMBER(15);
4482: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4483: BEGIN
4484: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4485: RETURN;
4486: END IF;

Line 4509: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4505: , p_org_id
4506: );
4507:
4508: IF p_event_name = 'CHANGE_SRP_QUOTA_CALC' THEN
4509: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4510: p_api_version => 1.0
4511: , p_node_type => 'P'
4512: , p_init_msg_list => 'T'
4513: , p_node_id => p_quota_id

Line 4654: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

4650: temp_quota_id cn_quotas.quota_id%TYPE;
4651: l_return_status VARCHAR2(50);
4652: l_msg_count NUMBER;
4653: l_msg_data VARCHAR2(2000);
4654: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4655: l_latest_quota_id NUMBER := 0;
4656: BEGIN
4657: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4658: RETURN;

Line 4692: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4688: , p_start_date_old
4689: , p_end_date_old
4690: ) LOOP
4691: IF l_latest_quota_id <> srp_quota.quota_id THEN
4692: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4693: p_api_version => 1.0
4694: , p_node_type => 'P'
4695: , p_init_msg_list => 'T'
4696: , p_node_id => srp_quota.quota_id

Line 4762: cn_calc_sql_exps_pvt.get_parent_plan_elts(

4758: , l_date_range_tbl(l_ctr).start_date
4759: , l_date_range_tbl(l_ctr).end_date
4760: ) LOOP
4761: IF l_latest_quota_id <> srp_quota.quota_id THEN
4762: cn_calc_sql_exps_pvt.get_parent_plan_elts(
4763: p_api_version => 1.0
4764: , p_node_type => 'P'
4765: , p_init_msg_list => 'T'
4766: , p_node_id => srp_quota.quota_id