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_ROLE_PLANS_PUB dependencies on CN_SRP_PLAN_ASSIGNS

Line 1018: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

1014: l_rec l_cur%ROWTYPE;
1015: l_return_status VARCHAR2 (2000);
1016: l_msg_count NUMBER;
1017: l_msg_data VARCHAR2 (2000);
1018: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
1019: l_loading_status VARCHAR2 (2000);
1020: BEGIN
1021: -- Initialize API return status to success
1022: x_return_status := fnd_api.g_ret_sts_success;

Line 1027: -- see here if it is necessary to insert into cn_srp_plan_assigns

1023: x_loading_status := p_loading_status;
1024:
1025: FOR l_rec IN l_cur
1026: LOOP
1027: -- see here if it is necessary to insert into cn_srp_plan_assigns
1028: -- the create_module here is OSC.
1029: -- if the job title not assigned yet (original OSC case) or
1030: -- status is PUSHED (salesrep push done, treat as OSC record), then
1031: -- call SPA.insert

Line 1035: -- dbms_output.put_line('insert into cn_srp_plan_assigns...');

1031: -- call SPA.insert
1032: -- if l_rec.job_title_id = G_MISS_JOB_TITLE OR
1033: -- l_rec.push_status = 'PUSHED' THEN
1034:
1035: -- dbms_output.put_line('insert into cn_srp_plan_assigns...');
1036: -- dbms_output.put_line('p_srp_role_id = ' || l_rec.srp_role_id);
1037: -- dbms_output.put_line('p_role_plan_id = ' || p_role_plan_id);
1038: cn_srp_plan_assigns_pvt.create_srp_plan_assigns
1039: (p_api_version => 1.0,

Line 1038: cn_srp_plan_assigns_pvt.create_srp_plan_assigns

1034:
1035: -- dbms_output.put_line('insert into cn_srp_plan_assigns...');
1036: -- dbms_output.put_line('p_srp_role_id = ' || l_rec.srp_role_id);
1037: -- dbms_output.put_line('p_role_plan_id = ' || p_role_plan_id);
1038: cn_srp_plan_assigns_pvt.create_srp_plan_assigns
1039: (p_api_version => 1.0,
1040: x_return_status => l_return_status,
1041: x_msg_count => l_msg_count,
1042: x_msg_data => l_msg_data,

Line 1101: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

1097: l_rec_del l_cur_del%ROWTYPE;
1098: l_return_status VARCHAR2 (2000);
1099: l_msg_count NUMBER;
1100: l_msg_data VARCHAR2 (2000);
1101: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
1102: l_loading_status VARCHAR2 (2000);
1103: BEGIN
1104: -- Initialize API return status to success
1105: x_return_status := fnd_api.g_ret_sts_success;

Line 1108: -- see here if it is necessary to update cn_srp_plan_assigns...

1104: -- Initialize API return status to success
1105: x_return_status := fnd_api.g_ret_sts_success;
1106: x_loading_status := p_loading_status;
1107:
1108: -- see here if it is necessary to update cn_srp_plan_assigns...
1109: -- the create_module here is OSC.
1110: -- if the job title not assigned yet (original OSC case) or
1111: -- status is PUSHED (salesrep push done, treat as OSC record), then
1112: -- call SPA.update

Line 1119: cn_srp_plan_assigns_pvt.update_srp_plan_assigns

1115: FOR l_rec IN l_cur
1116: LOOP
1117: -- if l_rec.job_title_id = G_MISS_JOB_TITLE OR
1118: -- l_rec.push_status = 'PUSHED' THEN
1119: cn_srp_plan_assigns_pvt.update_srp_plan_assigns
1120: (p_api_version => 1.0,
1121: x_return_status => l_return_status,
1122: x_msg_count => l_msg_count,
1123: x_msg_data => l_msg_data,

Line 1144: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

1140: FOR l_rec_del IN l_cur_del
1141: LOOP
1142: -- if l_rec.job_title_id = G_MISS_JOB_TITLE OR
1143: -- l_rec.push_status = 'PUSHED' THEN
1144: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
1145: (p_api_version => 1.0,
1146: x_return_status => l_return_status,
1147: x_msg_count => l_msg_count,
1148: x_msg_data => l_msg_data,

Line 1164: cn_srp_plan_assigns_pvt.create_srp_plan_assigns

1160: END LOOP;
1161:
1162: FOR l_rec IN l_cur
1163: LOOP
1164: cn_srp_plan_assigns_pvt.create_srp_plan_assigns
1165: (p_api_version => 1.0,
1166: x_return_status => l_return_status,
1167: x_msg_count => l_msg_count,
1168: x_msg_data => l_msg_data,

Line 1208: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

1204: l_rec l_cur%ROWTYPE;
1205: l_return_status VARCHAR2 (2000);
1206: l_msg_count NUMBER;
1207: l_msg_data VARCHAR2 (2000);
1208: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
1209: l_loading_status VARCHAR2 (2000);
1210: BEGIN
1211: -- Initialize API return status to success
1212: x_return_status := fnd_api.g_ret_sts_success;

Line 1217: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

1213: x_loading_status := p_loading_status;
1214:
1215: FOR l_rec IN l_cur
1216: LOOP
1217: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
1218: (p_api_version => 1.0,
1219: p_validation_level => fnd_api.g_valid_level_full,
1220: x_return_status => l_return_status,
1221: x_msg_count => l_msg_count,