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 JTF_RS_ROLE_RELATIONS

Line 928: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

924:
925: /*for create resource role relate */
926:
927: PROCEDURE create_res_role_relate_post
928: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
929: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
930: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
931: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
932: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 929: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

925: /*for create resource role relate */
926:
927: PROCEDURE create_res_role_relate_post
928: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
929: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
930: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
931: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
932: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
933: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE

Line 930: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

926:
927: PROCEDURE create_res_role_relate_post
928: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
929: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
930: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
931: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
932: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
933: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
934: DEFAULT NULL,

Line 931: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

927: PROCEDURE create_res_role_relate_post
928: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
929: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
930: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
931: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
932: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
933: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
934: DEFAULT NULL,
935: P_DATA OUT NOCOPY VARCHAR2,

Line 932: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

928: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
929: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
930: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
931: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
932: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
933: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
934: DEFAULT NULL,
935: P_DATA OUT NOCOPY VARCHAR2,
936: P_COUNT OUT NOCOPY NUMBER,

Line 933: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE

929: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
930: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
931: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
932: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
933: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
934: DEFAULT NULL,
935: P_DATA OUT NOCOPY VARCHAR2,
936: P_COUNT OUT NOCOPY NUMBER,
937: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS

Line 995: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;

991: l_team_name VARCHAR2(30);
992: l_team_event_name VARCHAR(60);
993: l_role_id NUMBER;
994: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
995: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
996:
997: -- clku, bug 3718575
998: l_resource_category VARCHAR2(30);
999:

Line 1007: jtf_rs_role_relations rr,

1003: sr.salesrep_id, tm.team_id, t.team_name
1004: from jtf_rs_team_members tm,
1005: jtf_rs_salesreps sr,
1006: jtf_rs_team_usages tu,
1007: jtf_rs_role_relations rr,
1008: jtf_rs_roles_b rb,
1009: jtf_rs_teams_vl t
1010: where rr.role_relate_id = p_role_relate_id
1011: and rr.role_resource_type(+) = 'RS_TEAM_MEMBER'

Line 1108: from jtf_rs_role_relations rr, jtf_rs_roles_b r

1104: IF p_role_resource_type = 'RS_INDIVIDUAL' THEN
1105: -- looks like spelling error but this is correct...
1106: IF l_usage = 'SALES_COMP_PAYMENT_ANALIST' THEN
1107: select count(1) into l_count
1108: from jtf_rs_role_relations rr, jtf_rs_roles_b r
1109: where rr.role_resource_id = P_ROLE_RESOURCE_ID
1110: and rr.role_resource_type = 'RS_INDIVIDUAL'
1111: and rr.delete_flag = 'N'
1112: and r.role_id = rr.role_id

Line 1132: from jtf_rs_role_relations rr, jtf_rs_roles_b r

1128: end if; -- l_usage = 'SALES_COMP_PAYMENT_ANALIST'
1129:
1130: IF l_usage = 'SALES_COMP' THEN
1131: select count(1) into l_count
1132: from jtf_rs_role_relations rr, jtf_rs_roles_b r
1133: where rr.role_resource_id = P_ROLE_RESOURCE_ID
1134: and rr.role_resource_type = 'RS_INDIVIDUAL'
1135: and rr.delete_flag = 'N'
1136: and r.role_id = rr.role_id

Line 1157: from jtf_rs_role_relations rr, jtf_rs_roles_b r

1153: -- check PAYEE role
1154: IF p_role_id = G_PAYEE_ROLE then
1155: -- payee cannot have any other sales comp role
1156: select count(1) into l_count
1157: from jtf_rs_role_relations rr, jtf_rs_roles_b r
1158: where rr.role_resource_id = P_ROLE_RESOURCE_ID
1159: and rr.role_resource_type = 'RS_INDIVIDUAL'
1160: and rr.delete_flag = 'N'
1161: and r.role_id = rr.role_id

Line 1175: from jtf_rs_role_relations rr

1171: end if;
1172: ELSE -- p_role_id <> G_PAYEE_ROLE
1173: -- NON-payee cannot have payee role
1174: select count(1) into l_count
1175: from jtf_rs_role_relations rr
1176: where rr.role_resource_id = P_ROLE_RESOURCE_ID
1177: and rr.role_resource_type = 'RS_INDIVIDUAL'
1178: and rr.delete_flag = 'N'
1179: and rr.role_id = G_PAYEE_ROLE;

Line 1398: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

1394: p_encoded => FND_API.g_false);
1395: END create_res_role_relate_post;
1396:
1397: PROCEDURE update_res_role_relate_post
1398: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1399: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE
1400: DEFAULT FND_API.G_MISS_DATE,
1401: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
1402: DEFAULT FND_API.G_MISS_DATE,

Line 1399: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE

1395: END create_res_role_relate_post;
1396:
1397: PROCEDURE update_res_role_relate_post
1398: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1399: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE
1400: DEFAULT FND_API.G_MISS_DATE,
1401: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
1402: DEFAULT FND_API.G_MISS_DATE,
1403: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 1401: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE

1397: PROCEDURE update_res_role_relate_post
1398: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1399: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE
1400: DEFAULT FND_API.G_MISS_DATE,
1401: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
1402: DEFAULT FND_API.G_MISS_DATE,
1403: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1404: P_DATA OUT NOCOPY VARCHAR2,
1405: P_COUNT OUT NOCOPY NUMBER,

Line 1403: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

1399: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE
1400: DEFAULT FND_API.G_MISS_DATE,
1401: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
1402: DEFAULT FND_API.G_MISS_DATE,
1403: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1404: P_DATA OUT NOCOPY VARCHAR2,
1405: P_COUNT OUT NOCOPY NUMBER,
1406: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS
1407:

Line 1420: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;

1416: l_max_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
1417: -- clku, team role enhancement
1418: l_team_event_name VARCHAR(60);
1419: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
1420: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
1421: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
1422:
1423: -- Bug 4083951 by mnativ
1424: l_usage VARCHAR2(30);

Line 1421: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;

1417: -- clku, team role enhancement
1418: l_team_event_name VARCHAR(60);
1419: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
1420: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
1421: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
1422:
1423: -- Bug 4083951 by mnativ
1424: l_usage VARCHAR2(30);
1425: -- clku, bug 3718575

Line 1484: from jtf_rs_resource_extns re, jtf_rs_role_relations rr

1480:
1481: -- clku, bug 3718575 get the resource category information
1482: CURSOR resource_category_info IS
1483: select category
1484: from jtf_rs_resource_extns re, jtf_rs_role_relations rr
1485: where re.resource_id = rr.role_resource_id
1486: and rr.role_relate_id = P_ROLE_RELATE_ID;
1487:
1488: BEGIN

Line 1495: from jtf_rs_role_relations rr, jtf_rs_roles_b r

1491:
1492: -- get usage for the role (can't fail)
1493: select rr.role_resource_type, r.role_type_code, r.role_id, rr.role_resource_id
1494: INTO l_role_resource_type, l_usage, l_role_id, l_role_resource_id
1495: from jtf_rs_role_relations rr, jtf_rs_roles_b r
1496: where rr.role_relate_id = p_role_relate_id
1497: and rr.role_id = r.role_id;
1498:
1499: -- only proceed if usage is SALES_COMP or SALES_COMP_PAYMENT_ANALIST

Line 1508: FROM jtf_rs_role_relations rrr

1504: -- Sales Comp role assignment may NOT overlap with Pmt Analyst role assignment
1505: IF l_role_resource_type = 'RS_INDIVIDUAL' THEN
1506: IF l_usage = 'SALES_COMP' THEN
1507: SELECT COUNT(1) INTO l_count
1508: FROM jtf_rs_role_relations rrr
1509: WHERE role_relate_id = P_ROLE_RELATE_ID
1510: AND EXISTS
1511: (
1512: SELECT NULL

Line 1513: FROM jtf_rs_role_relations rr,

1509: WHERE role_relate_id = P_ROLE_RELATE_ID
1510: AND EXISTS
1511: (
1512: SELECT NULL
1513: FROM jtf_rs_role_relations rr,
1514: jtf_rs_roles_b r
1515: WHERE rrr.role_resource_id = rr.role_resource_id
1516: AND rrr.role_relate_id <> rr.role_relate_id
1517: AND rr.role_resource_type = 'RS_INDIVIDUAL'

Line 1537: FROM jtf_rs_role_relations rrr

1533: end if;
1534: ELSIF l_usage = 'SALES_COMP_PAYMENT_ANALIST' THEN
1535: -- Pmt Analyst role assignment may NOT everlap with Sales Comp role assignment
1536: SELECT COUNT(1) INTO l_count
1537: FROM jtf_rs_role_relations rrr
1538: WHERE role_relate_id = P_ROLE_RELATE_ID
1539: AND EXISTS
1540: (
1541: SELECT NULL

Line 1542: FROM jtf_rs_role_relations rr,

1538: WHERE role_relate_id = P_ROLE_RELATE_ID
1539: AND EXISTS
1540: (
1541: SELECT NULL
1542: FROM jtf_rs_role_relations rr,
1543: jtf_rs_roles_b r
1544: WHERE rrr.role_resource_id = rr.role_resource_id
1545: AND rrr.role_relate_id <> rr.role_relate_id
1546: AND rr.role_resource_type = 'RS_INDIVIDUAL'

Line 1784: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

1780: p_encoded => FND_API.g_false);
1781: END update_res_role_relate_post;
1782:
1783: PROCEDURE delete_res_role_relate_pre
1784: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1785: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1786: P_DATA OUT NOCOPY VARCHAR2,
1787: P_COUNT OUT NOCOPY NUMBER,
1788: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS

Line 1785: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

1781: END update_res_role_relate_post;
1782:
1783: PROCEDURE delete_res_role_relate_pre
1784: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1785: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1786: P_DATA OUT NOCOPY VARCHAR2,
1787: P_COUNT OUT NOCOPY NUMBER,
1788: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS
1789:

Line 1792: from jtf_rs_role_relations rr,

1788: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS
1789:
1790: cursor get_role_id is
1791: select rr.role_id
1792: from jtf_rs_role_relations rr,
1793: jtf_rs_roles_b r
1794: where rr.role_relate_id = p_role_relate_id
1795: AND rr.role_id = r.role_id
1796: AND r.role_type_code = 'SALES_COMP'

Line 1828: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;

1824: l_team_id NUMBER;
1825: l_team_name VARCHAR2(30);
1826: l_team_event_name VARCHAR(60);
1827: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
1828: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
1829: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
1830:
1831: l_orig_org_id NUMBER;
1832: l_orig_acc_mode VARCHAR(1);

Line 1829: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;

1825: l_team_name VARCHAR2(30);
1826: l_team_event_name VARCHAR(60);
1827: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
1828: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
1829: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
1830:
1831: l_orig_org_id NUMBER;
1832: l_orig_acc_mode VARCHAR(1);
1833:

Line 1865: jtf_rs_role_relations rr,

1861: sr.salesrep_id, tm.team_id, t.team_name
1862: from jtf_rs_team_members tm,
1863: jtf_rs_salesreps sr,
1864: jtf_rs_team_usages tu,
1865: jtf_rs_role_relations rr,
1866: jtf_rs_roles_b rb,
1867: jtf_rs_teams_vl t
1868: where rr.role_relate_id = p_role_relate_id
1869: and rr.role_resource_type(+) = 'RS_TEAM_MEMBER'

Line 1923: from jtf_rs_resource_extns re, jtf_rs_role_relations rr

1919:
1920: -- clku, bug 3718575 get the resource category information
1921: CURSOR resource_category_info IS
1922: select category
1923: from jtf_rs_resource_extns re, jtf_rs_role_relations rr
1924: where re.resource_id = rr.role_resource_id
1925: and rr.role_relate_id = P_ROLE_RELATE_ID;
1926:
1927: BEGIN

Line 1935: from jtf_rs_role_relations rr, jtf_rs_roles_b r

1931: select rr.role_resource_type, r.role_type_code, r.role_id,
1932: rr.role_resource_id, start_date_active, end_date_active
1933: INTO l_role_resource_type, l_usage, l_role_id,
1934: l_role_resource_id, l_rr_start_date, l_rr_end_date
1935: from jtf_rs_role_relations rr, jtf_rs_roles_b r
1936: where rr.role_relate_id = p_role_relate_id
1937: and rr.role_id = r.role_id;
1938:
1939: -- only proceed if usage is SALES_COMP or SALES_COMP_PAYMENT_ANALIST

Line 2144: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

2140: p_encoded => FND_API.g_false);
2141: END;
2142:
2143: PROCEDURE update_res_role_relate_pre
2144: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2145: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE
2146: DEFAULT FND_API.G_MISS_DATE,
2147: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
2148: DEFAULT FND_API.G_MISS_DATE,

Line 2145: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE

2141: END;
2142:
2143: PROCEDURE update_res_role_relate_pre
2144: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2145: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE
2146: DEFAULT FND_API.G_MISS_DATE,
2147: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
2148: DEFAULT FND_API.G_MISS_DATE,
2149: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 2147: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE

2143: PROCEDURE update_res_role_relate_pre
2144: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2145: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE
2146: DEFAULT FND_API.G_MISS_DATE,
2147: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
2148: DEFAULT FND_API.G_MISS_DATE,
2149: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
2150: P_DATA OUT NOCOPY VARCHAR2,
2151: P_COUNT OUT NOCOPY NUMBER,

Line 2149: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

2145: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE
2146: DEFAULT FND_API.G_MISS_DATE,
2147: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE
2148: DEFAULT FND_API.G_MISS_DATE,
2149: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
2150: P_DATA OUT NOCOPY VARCHAR2,
2151: P_COUNT OUT NOCOPY NUMBER,
2152: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS
2153:

Line 2176: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;

2172: --clku, team member rs role mark event
2173:
2174: l_team_event_name VARCHAR(60);
2175: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
2176: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
2177: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
2178:
2179: -- get the salesrep ID's, org ID's
2180: CURSOR get_srp_org_info IS

Line 2177: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;

2173:
2174: l_team_event_name VARCHAR(60);
2175: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
2176: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
2177: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
2178:
2179: -- get the salesrep ID's, org ID's
2180: CURSOR get_srp_org_info IS
2181: select salesrep_id, org_id

Line 2207: jtf_rs_role_relations rr,

2203: SELECT rr.start_date_active, rr.end_date_active, tm.team_id, t.team_name
2204: from jtf_rs_team_members tm,
2205: jtf_rs_salesreps sr,
2206: jtf_rs_team_usages tu,
2207: jtf_rs_role_relations rr,
2208: jtf_rs_roles_b rb,
2209: jtf_rs_teams_vl t
2210: where rr.role_relate_id = p_role_relate_id
2211: and rr.role_resource_type(+) = 'RS_TEAM_MEMBER'

Line 2276: from jtf_rs_role_relations rr, jtf_rs_roles_b r

2272:
2273: -- get usage for the role (can't fail)
2274: select rr.role_resource_type, r.role_type_code, r.role_id, rr.role_resource_id
2275: INTO l_role_resource_type, l_usage, l_role_id, l_role_resource_id
2276: from jtf_rs_role_relations rr, jtf_rs_roles_b r
2277: where rr.role_relate_id = p_role_relate_id
2278: and rr.role_id = r.role_id;
2279:
2280: -- only proceed if usage is SALES_COMP or SALES_COMP_PAYMENT_ANALIST

Line 2543: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

2539:
2540: /*for create resource role relate */
2541:
2542: PROCEDURE create_res_role_relate_pre
2543: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
2544: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
2545: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
2546: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2547: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,

Line 2544: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,

2540: /*for create resource role relate */
2541:
2542: PROCEDURE create_res_role_relate_pre
2543: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
2544: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
2545: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
2546: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2547: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
2548: P_DATA OUT NOCOPY VARCHAR2,

Line 2545: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

2541:
2542: PROCEDURE create_res_role_relate_pre
2543: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
2544: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
2545: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
2546: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2547: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
2548: P_DATA OUT NOCOPY VARCHAR2,
2549: P_COUNT OUT NOCOPY NUMBER,

Line 2546: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

2542: PROCEDURE create_res_role_relate_pre
2543: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
2544: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
2545: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
2546: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2547: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
2548: P_DATA OUT NOCOPY VARCHAR2,
2549: P_COUNT OUT NOCOPY NUMBER,
2550: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS

Line 2547: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,

2543: (P_ROLE_RESOURCE_TYPE JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
2544: P_ROLE_RESOURCE_ID JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
2545: P_ROLE_ID JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
2546: P_START_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2547: P_END_DATE_ACTIVE JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
2548: P_DATA OUT NOCOPY VARCHAR2,
2549: P_COUNT OUT NOCOPY NUMBER,
2550: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS
2551: BEGIN

Line 2556: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

2552: p_return_code := fnd_api.g_ret_sts_success ;
2553: END create_res_role_relate_pre;
2554:
2555: PROCEDURE delete_res_role_relate_post
2556: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2557: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
2558: P_DATA OUT NOCOPY VARCHAR2,
2559: P_COUNT OUT NOCOPY NUMBER,
2560: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS

Line 2557: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

2553: END create_res_role_relate_pre;
2554:
2555: PROCEDURE delete_res_role_relate_post
2556: (P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2557: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
2558: P_DATA OUT NOCOPY VARCHAR2,
2559: P_COUNT OUT NOCOPY NUMBER,
2560: P_RETURN_CODE OUT NOCOPY VARCHAR2) IS
2561: BEGIN