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_ROLES

Line 38: -- these procedures copied straight out of cn_srp_roles_pub API

34: -- dbms_output.put_line(msg); -- comment me out before checking in file :-)
35: null;
36: END debugmsg;
37:
38: -- these procedures copied straight out of cn_srp_roles_pub API
39:
40: -- ==========================================================================
41: -- Procedure: srp_plan_assignment_for_insert
42: -- already in single-org context

Line 46: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

42: -- already in single-org context
43: -- ==========================================================================
44: PROCEDURE srp_plan_assignment_for_insert
45: (p_role_id IN cn_roles.role_id%TYPE,
46: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: p_loading_status IN VARCHAR2,
49: x_loading_status OUT NOCOPY VARCHAR2 ) IS
50:

Line 100: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

96: -- already in single-org context
97: -- ==========================================================================
98: PROCEDURE srp_pmt_plan_asgn_for_insert
99: (p_role_id IN cn_roles.role_id%TYPE,
100: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: p_loading_status IN VARCHAR2,
103: x_loading_status OUT NOCOPY VARCHAR2 ) IS
104:

Line 154: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

150: -- already in single-org context
151: -- ==========================================================================
152: PROCEDURE srp_pay_groups_asgn_for_insert
153: (p_role_id IN cn_roles.role_id%TYPE,
154: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: p_loading_status IN VARCHAR2,
157: x_loading_status OUT NOCOPY VARCHAR2 ) IS
158:

Line 208: (p_salesrep_id IN cn_srp_roles.salesrep_id%TYPE,

204: -- Procedure: ins_srp_intel_prd
205: -- already in single-org context
206: -- ==========================================================================
207: PROCEDURE ins_srp_intel_prd
208: (p_salesrep_id IN cn_srp_roles.salesrep_id%TYPE,
209: p_start_date IN cn_srp_roles.start_date%TYPE,
210: p_end_date IN cn_srp_roles.end_date%TYPE,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,

Line 209: p_start_date IN cn_srp_roles.start_date%TYPE,

205: -- already in single-org context
206: -- ==========================================================================
207: PROCEDURE ins_srp_intel_prd
208: (p_salesrep_id IN cn_srp_roles.salesrep_id%TYPE,
209: p_start_date IN cn_srp_roles.start_date%TYPE,
210: p_end_date IN cn_srp_roles.end_date%TYPE,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: x_return_status OUT NOCOPY VARCHAR2,

Line 210: p_end_date IN cn_srp_roles.end_date%TYPE,

206: -- ==========================================================================
207: PROCEDURE ins_srp_intel_prd
208: (p_salesrep_id IN cn_srp_roles.salesrep_id%TYPE,
209: p_start_date IN cn_srp_roles.start_date%TYPE,
210: p_end_date IN cn_srp_roles.end_date%TYPE,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: x_return_status OUT NOCOPY VARCHAR2,
214: p_loading_status IN VARCHAR2,

Line 310: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

306: -- already in single-org context
307: -- ==========================================================================
308: PROCEDURE srp_plan_assignment_for_update
309: (p_role_id IN cn_roles.role_id%TYPE,
310: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
311: p_date_update_only IN VARCHAR2,
312: x_return_status OUT NOCOPY VARCHAR2,
313: p_loading_status IN VARCHAR2,
314: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 401: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

397: -- already in single-org context
398: -- ==========================================================================
399: PROCEDURE srp_pmt_plan_asgn_for_update
400: (p_role_id IN cn_roles.role_id%TYPE,
401: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
402: p_date_update_only IN VARCHAR2,
403: x_return_status OUT NOCOPY VARCHAR2,
404: p_loading_status IN VARCHAR2,
405: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 462: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

458: -- already in single-org context
459: -- ==========================================================================
460: PROCEDURE srp_pay_group_asgn_for_update
461: (p_role_id IN cn_roles.role_id%TYPE,
462: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
463: p_date_update_only IN VARCHAR2,
464: x_return_status OUT NOCOPY VARCHAR2,
465: p_loading_status IN VARCHAR2,
466: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 518: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

514: -- already in single-org context
515: -- ==========================================================================
516: PROCEDURE srp_plan_assignment_for_delete
517: (p_role_id IN cn_roles.role_id%TYPE,
518: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
519: x_return_status OUT NOCOPY VARCHAR2,
520: p_loading_status IN VARCHAR2,
521: x_loading_status OUT NOCOPY VARCHAR2 ) IS
522:

Line 567: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

563: -- already in single-org context
564: -- ==========================================================================
565: PROCEDURE srp_pmt_plan_asgn_for_delete
566: (p_role_id IN cn_roles.role_id%TYPE,
567: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
568: x_return_status OUT NOCOPY VARCHAR2,
569: p_loading_status IN VARCHAR2,
570: x_loading_status OUT NOCOPY VARCHAR2 ) IS
571:

Line 630: FROM cn_srp_roles

626: l_count_pay NUMBER;
627:
628: cursor get_srp_roles IS
629: SELECT srp_role_id, org_id, start_date, salesrep_id
630: FROM cn_srp_roles
631: WHERE srp_role_id = p_srp_role_id;
632:
633: BEGIN
634: FOR srp_role IN get_srp_roles LOOP

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 701: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,

697: -- already in single-org context
698: -- ==========================================================================
699: PROCEDURE srp_pay_group_asgn_for_delete
700: (p_role_id IN cn_roles.role_id%TYPE,
701: p_srp_role_id IN cn_srp_roles.srp_role_id%TYPE,
702: x_return_status OUT NOCOPY VARCHAR2,
703: p_loading_status IN VARCHAR2,
704: x_loading_status OUT NOCOPY VARCHAR2 ) IS
705:

Line 1957: from cn_srp_roles sr, cn_srp_payee_assigns spa

1953: IF l_role_resource_type = 'RS_INDIVIDUAL' THEN
1954: -- if deleting a payee role, make sure no payee assigned over that period
1955: if l_role_id = G_PAYEE_ROLE then
1956: select count(1) into l_count
1957: from cn_srp_roles sr, cn_srp_payee_assigns spa
1958: where sr.srp_role_id = p_role_relate_id
1959: and spa.payee_id = sr.salesrep_id
1960: and sr.start_date <= nvl(spa.end_date, sr.start_date)
1961: and spa.start_date <= nvl(sr.end_date, spa.start_date);

Line 2266: FROM cn_srp_roles

2262: or l_start_date between ct.start_date_active and nvl (ct.end_date_active, l_start_date));
2263:
2264: CURSOR payee_role_info IS
2265: SELECT salesrep_id, start_date, end_date, role_id
2266: FROM cn_srp_roles
2267: WHERE srp_role_id = p_role_relate_id;
2268:
2269: BEGIN
2270: debugmsg('Inside vertical hook update_role_relate_pre');