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.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_SRP_PLAN_ASSIGNS

Line 61: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

57:
58: l_return_status VARCHAR2(200);
59: l_msg_count NUMBER;
60: l_msg_data VARCHAR2(2000);
61: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
62: l_loading_status VARCHAR2(2000);
63:
64: BEGIN
65:

Line 71: debugmsg('insert into cn_srp_plan_assigns...');

67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68: x_loading_status := p_loading_status;
69:
70: FOR l_rec IN l_cur LOOP
71: debugmsg('insert into cn_srp_plan_assigns...');
72: debugmsg('p_srp_role_id = ' || p_srp_role_id);
73: debugmsg('l_rec.role_plan_id = ' || l_rec.role_plan_id);
74:
75: cn_srp_plan_assigns_pvt.create_srp_plan_assigns

Line 75: cn_srp_plan_assigns_pvt.create_srp_plan_assigns

71: debugmsg('insert into cn_srp_plan_assigns...');
72: debugmsg('p_srp_role_id = ' || p_srp_role_id);
73: debugmsg('l_rec.role_plan_id = ' || l_rec.role_plan_id);
74:
75: cn_srp_plan_assigns_pvt.create_srp_plan_assigns
76: (p_api_version => 1.0,
77: x_return_status => l_return_status,
78: x_msg_count => l_msg_count,
79: x_msg_data => l_msg_data,

Line 326: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

322: l_rec l_cur%ROWTYPE;
323: l_return_status VARCHAR2(2000);
324: l_msg_count NUMBER;
325: l_msg_data VARCHAR2(2000);
326: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
327: l_loading_status VARCHAR2(2000);
328:
329: BEGIN
330: -- Initialize API return status to success

Line 336: debugmsg('update cn_srp_plan_assigns.......');

332: x_loading_status := p_loading_status;
333:
334: IF (p_date_update_only = FND_API.G_TRUE) THEN
335: FOR l_rec IN l_cur LOOP
336: debugmsg('update cn_srp_plan_assigns.......');
337: debugmsg('p_srp_role_id = ' || p_srp_role_id);
338: debugmsg('l_rec.role_plan_id = ' || l_rec.role_plan_id);
339:
340: cn_srp_plan_assigns_pvt.update_srp_plan_assigns

Line 340: cn_srp_plan_assigns_pvt.update_srp_plan_assigns

336: debugmsg('update cn_srp_plan_assigns.......');
337: debugmsg('p_srp_role_id = ' || p_srp_role_id);
338: debugmsg('l_rec.role_plan_id = ' || l_rec.role_plan_id);
339:
340: cn_srp_plan_assigns_pvt.update_srp_plan_assigns
341: (p_api_version => 1.0,
342: x_return_status => l_return_status,
343: x_msg_count => l_msg_count,
344: x_msg_data => l_msg_data,

Line 359: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

355:
356: ELSE -- updating whole assignment
357:
358: FOR l_rec IN l_cur LOOP
359: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
360: (p_api_version => 1.0,
361: x_return_status => l_return_status,
362: x_msg_count => l_msg_count,
363: x_msg_data => l_msg_data,

Line 374: cn_srp_plan_assigns_pvt.create_srp_plan_assigns

370: x_loading_status := l_loading_status;
371: EXIT;
372: END IF;
373:
374: cn_srp_plan_assigns_pvt.create_srp_plan_assigns
375: (p_api_version => 1.0,
376: x_return_status => l_return_status,
377: x_msg_count => l_msg_count,
378: x_msg_data => l_msg_data,

Line 532: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

528: l_rec l_cur%ROWTYPE;
529: l_return_status VARCHAR2(2000);
530: l_msg_count NUMBER;
531: l_msg_data VARCHAR2(2000);
532: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
533: l_loading_status VARCHAR2(2000);
534:
535: BEGIN
536: -- Initialize API return status to success

Line 541: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

537: x_return_status := FND_API.G_RET_STS_SUCCESS;
538: x_loading_status := p_loading_status;
539:
540: FOR l_rec IN l_cur LOOP
541: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
542: (p_api_version => 1.0,
543: p_init_msg_list => fnd_api.g_false,
544: p_commit => fnd_api.g_false,
545: p_validation_level => fnd_api.g_valid_level_full,

Line 637: FROM cn_srp_roles srp, cn_srp_plan_assigns plan

633: BEGIN
634: FOR srp_role IN get_srp_roles LOOP
635: SELECT count(*)
636: INTO l_count
637: FROM cn_srp_roles srp, cn_srp_plan_assigns plan
638: WHERE srp.srp_role_id = srp_role.srp_role_id
639: AND srp.org_id = srp_role.org_id
640: AND srp.org_id = plan.org_id
641: AND srp.salesrep_id = plan.salesrep_id

Line 939: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

935: P_DATA OUT NOCOPY VARCHAR2,
936: P_COUNT OUT NOCOPY NUMBER,
937: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS
938:
939: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
940: x_loading_status VARCHAR2(30);
941: l_salesrep_id NUMBER;
942: l_org_id NUMBER;
943: l_orig_acc_mode VARCHAR2(1);