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_REP_MGR_DENORM_PVT dependencies on JTF_RS_REP_MANAGERS

Line 31: SELECT jtf_rs_rep_managers_s.nextval

27: X_MSG_DATA OUT NOCOPY VARCHAR2 )
28: IS
29: CURSOR rep_mgr_seq_cur
30: IS
31: SELECT jtf_rs_rep_managers_s.nextval
32: FROM dual;
33:
34:
35: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

Line 122: FROM jtf_rs_rep_managers

118: l_start_date_active DATE,
119: l_end_date_active DATE)
120: IS
121: SELECT person_id
122: FROM jtf_rs_rep_managers
123: WHERE group_id = l_group_id
124: AND ( person_id = l_person_id
125: OR (l_person_id IS NULL AND person_id IS NULL))
126: AND manager_person_id = l_manager_person_id

Line 139: FROM jtf_rs_rep_managers

135: l_start_date_active date,
136: l_end_date_active date)
137: IS
138: SELECT person_id
139: FROM jtf_rs_rep_managers
140: WHERE par_role_relate_id = l_par_role_relate_id
141: AND child_role_relate_id = l_child_role_relate_id
142: AND group_id = l_group_id
143: AND ((l_start_date_active between start_date_active and

Line 340: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;

336:
337: child_mem_rec child_mem_cur%rowtype;
338:
339: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
340: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
341: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
342: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
343: x_row_id VARCHAR2(100);
344:

Line 341: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;

337: child_mem_rec child_mem_cur%rowtype;
338:
339: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
340: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
341: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
342: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
343: x_row_id VARCHAR2(100);
344:
345: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_REP_MANAGER';

Line 342: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;

338:
339: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
340: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
341: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
342: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
343: x_row_id VARCHAR2(100);
344:
345: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_REP_MANAGER';
346: l_api_version CONSTANT NUMBER :=1.0;

Line 426: jtf_rs_rep_managers_pkg.insert_row(

422:
423: OPEN rep_mgr_seq_cur;
424: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
425: CLOSE rep_mgr_seq_cur;
426: jtf_rs_rep_managers_pkg.insert_row(
427: X_ROWID => x_row_id,
428: X_DENORM_MGR_ID => l_denorm_mgr_id,
429: X_RESOURCE_ID => mem_dtls_rec.resource_id,
430: X_PERSON_ID => mem_dtls_rec.person_id,

Line 537: jtf_rs_rep_managers_pkg.insert_row(

533: --INSERT INTO TABLE
534: OPEN rep_mgr_seq_cur;
535: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
536: CLOSE rep_mgr_seq_cur;
537: jtf_rs_rep_managers_pkg.insert_row(
538: X_ROWID => x_row_id,
539: X_DENORM_MGR_ID => l_denorm_mgr_id,
540: X_RESOURCE_ID => mem_dtls_rec.resource_id,
541: X_PERSON_ID => mem_dtls_rec.person_id,

Line 651: jtf_rs_rep_managers_pkg.insert_row(

647: OPEN rep_mgr_seq_cur;
648: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
649: CLOSE rep_mgr_seq_cur;
650:
651: jtf_rs_rep_managers_pkg.insert_row(
652: X_ROWID => x_row_id,
653: X_DENORM_MGR_ID => l_denorm_mgr_id,
654: X_RESOURCE_ID =>other_rec.resource_id,
655: X_PERSON_ID =>other_rec.person_id,

Line 773: jtf_rs_rep_managers_pkg.insert_row(

769: OPEN rep_mgr_seq_cur;
770: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
771: CLOSE rep_mgr_seq_cur;
772:
773: jtf_rs_rep_managers_pkg.insert_row(
774: X_ROWID => x_row_id,
775: X_DENORM_MGR_ID => l_denorm_mgr_id,
776: X_RESOURCE_ID => mem_dtls_rec.resource_id,
777: X_PERSON_ID => mem_dtls_rec.person_id,

Line 844: jtf_rs_rep_managers_pkg.insert_row(

840: OPEN rep_mgr_seq_cur;
841: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
842: CLOSE rep_mgr_seq_cur;
843:
844: jtf_rs_rep_managers_pkg.insert_row(
845: X_ROWID => x_row_id,
846: X_DENORM_MGR_ID => l_denorm_mgr_id,
847: X_RESOURCE_ID => mem_dtls_rec.resource_id,
848: X_PERSON_ID => mem_dtls_rec.person_id,

Line 973: jtf_rs_rep_managers_pkg.insert_row(

969: OPEN rep_mgr_seq_cur;
970: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
971: CLOSE rep_mgr_seq_cur;
972:
973: jtf_rs_rep_managers_pkg.insert_row(
974: X_ROWID => x_row_id,
975: X_DENORM_MGR_ID => l_denorm_mgr_id,
976: X_RESOURCE_ID =>child_mem_rec.resource_id,
977: X_PERSON_ID => child_mem_rec.person_id,

Line 1044: jtf_rs_rep_managers_pkg.insert_row(

1040: OPEN rep_mgr_seq_cur;
1041: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
1042: CLOSE rep_mgr_seq_cur;
1043:
1044: jtf_rs_rep_managers_pkg.insert_row(
1045: X_ROWID => x_row_id,
1046: X_DENORM_MGR_ID => l_denorm_mgr_id,
1047: X_RESOURCE_ID =>child_mem_rec.resource_id,
1048: X_PERSON_ID => child_mem_rec.person_id,

Line 1161: SELECT jtf_rs_rep_managers_s.nextval

1157: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1158: IS
1159: CURSOR rep_mgr_seq_cur
1160: IS
1161: SELECT jtf_rs_rep_managers_s.nextval
1162: FROM dual;
1163:
1164:
1165: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

Line 1245: FROM jtf_rs_rep_managers

1241: l_start_date_active DATE,
1242: l_end_date_active DATE)
1243: IS
1244: SELECT person_id
1245: FROM jtf_rs_rep_managers
1246: WHERE group_id = l_group_id
1247: AND ( person_id = l_person_id
1248: OR (l_person_id IS NULL AND person_id IS NULL))
1249: AND manager_person_id = l_manager_person_id

Line 1260: FROM jtf_rs_rep_managers

1256: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1257: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
1258: IS
1259: SELECT person_id
1260: FROM jtf_rs_rep_managers
1261: WHERE par_role_relate_id = l_par_role_relate_id
1262: AND child_role_relate_id = l_child_role_relate_id
1263: AND group_id = l_group_id;
1264:

Line 1443: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;

1439:
1440: child_mem_rec child_mem_cur%rowtype;
1441:
1442: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
1443: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
1444: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
1445: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
1446: x_row_id VARCHAR2(100);
1447:

Line 1444: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;

1440: child_mem_rec child_mem_cur%rowtype;
1441:
1442: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
1443: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
1444: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
1445: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
1446: x_row_id VARCHAR2(100);
1447:
1448: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_REP_MANAGER';

Line 1445: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;

1441:
1442: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
1443: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
1444: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
1445: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
1446: x_row_id VARCHAR2(100);
1447:
1448: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_REP_MANAGER';
1449: l_api_version CONSTANT NUMBER :=1.0;

Line 1520: jtf_rs_rep_managers_pkg.insert_row(

1516:
1517: OPEN rep_mgr_seq_cur;
1518: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
1519: CLOSE rep_mgr_seq_cur;
1520: jtf_rs_rep_managers_pkg.insert_row(
1521: X_ROWID => x_row_id,
1522: X_DENORM_MGR_ID => l_denorm_mgr_id,
1523: X_RESOURCE_ID => mem_dtls_rec.resource_id,
1524: X_PERSON_ID => mem_dtls_rec.person_id,

Line 1629: jtf_rs_rep_managers_pkg.insert_row(

1625: --INSERT INTO TABLE
1626: OPEN rep_mgr_seq_cur;
1627: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
1628: CLOSE rep_mgr_seq_cur;
1629: jtf_rs_rep_managers_pkg.insert_row(
1630: X_ROWID => x_row_id,
1631: X_DENORM_MGR_ID => l_denorm_mgr_id,
1632: X_RESOURCE_ID => mem_dtls_rec.resource_id,
1633: X_PERSON_ID => mem_dtls_rec.person_id,

Line 1697: jtf_rs_rep_managers_pkg.insert_row(

1693: OPEN rep_mgr_seq_cur;
1694: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
1695: CLOSE rep_mgr_seq_cur;
1696:
1697: jtf_rs_rep_managers_pkg.insert_row(
1698: X_ROWID => x_row_id,
1699: X_DENORM_MGR_ID => l_denorm_mgr_id,
1700: X_RESOURCE_ID => mem_dtls_rec.resource_id,
1701: X_PERSON_ID => mem_dtls_rec.person_id,

Line 1803: jtf_rs_rep_managers_pkg.insert_row(

1799: OPEN rep_mgr_seq_cur;
1800: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
1801: CLOSE rep_mgr_seq_cur;
1802:
1803: jtf_rs_rep_managers_pkg.insert_row(
1804: X_ROWID => x_row_id,
1805: X_DENORM_MGR_ID => l_denorm_mgr_id,
1806: X_RESOURCE_ID =>other_rec.resource_id,
1807: X_PERSON_ID =>other_rec.person_id,

Line 1874: jtf_rs_rep_managers_pkg.insert_row(

1870: OPEN rep_mgr_seq_cur;
1871: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
1872: CLOSE rep_mgr_seq_cur;
1873:
1874: jtf_rs_rep_managers_pkg.insert_row(
1875: X_ROWID => x_row_id,
1876: X_DENORM_MGR_ID => l_denorm_mgr_id,
1877: X_RESOURCE_ID =>other_rec.resource_id,
1878: X_PERSON_ID =>other_rec.person_id,

Line 1987: jtf_rs_rep_managers_pkg.insert_row(

1983: OPEN rep_mgr_seq_cur;
1984: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
1985: CLOSE rep_mgr_seq_cur;
1986:
1987: jtf_rs_rep_managers_pkg.insert_row(
1988: X_ROWID => x_row_id,
1989: X_DENORM_MGR_ID => l_denorm_mgr_id,
1990: X_RESOURCE_ID => mem_dtls_rec.resource_id,
1991: X_PERSON_ID => mem_dtls_rec.person_id,

Line 2056: jtf_rs_rep_managers_pkg.insert_row(

2052: OPEN rep_mgr_seq_cur;
2053: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
2054: CLOSE rep_mgr_seq_cur;
2055:
2056: jtf_rs_rep_managers_pkg.insert_row(
2057: X_ROWID => x_row_id,
2058: X_DENORM_MGR_ID => l_denorm_mgr_id,
2059: X_RESOURCE_ID => mem_dtls_rec.resource_id,
2060: X_PERSON_ID => mem_dtls_rec.person_id,

Line 2167: jtf_rs_rep_managers_pkg.insert_row(

2163: OPEN rep_mgr_seq_cur;
2164: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
2165: CLOSE rep_mgr_seq_cur;
2166:
2167: jtf_rs_rep_managers_pkg.insert_row(
2168: X_ROWID => x_row_id,
2169: X_DENORM_MGR_ID => l_denorm_mgr_id,
2170: X_RESOURCE_ID => mem_dtls_rec.resource_id,
2171: X_PERSON_ID => mem_dtls_rec.person_id,

Line 2233: jtf_rs_rep_managers_pkg.insert_row(

2229: OPEN rep_mgr_seq_cur;
2230: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
2231: CLOSE rep_mgr_seq_cur;
2232:
2233: jtf_rs_rep_managers_pkg.insert_row(
2234: X_ROWID => x_row_id,
2235: X_DENORM_MGR_ID => l_denorm_mgr_id,
2236: X_RESOURCE_ID => mem_dtls_rec.resource_id,
2237: X_PERSON_ID => mem_dtls_rec.person_id,

Line 2370: jtf_rs_rep_managers_pkg.insert_row(

2366: OPEN rep_mgr_seq_cur;
2367: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
2368: CLOSE rep_mgr_seq_cur;
2369:
2370: jtf_rs_rep_managers_pkg.insert_row(
2371: X_ROWID => x_row_id,
2372: X_DENORM_MGR_ID => l_denorm_mgr_id,
2373: X_RESOURCE_ID =>child_mem_rec.resource_id,
2374: X_PERSON_ID => child_mem_rec.person_id,

Line 2439: jtf_rs_rep_managers_pkg.insert_row(

2435: OPEN rep_mgr_seq_cur;
2436: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
2437: CLOSE rep_mgr_seq_cur;
2438:
2439: jtf_rs_rep_managers_pkg.insert_row(
2440: X_ROWID => x_row_id,
2441: X_DENORM_MGR_ID => l_denorm_mgr_id,
2442: X_RESOURCE_ID =>child_mem_rec.resource_id,
2443: X_PERSON_ID => child_mem_rec.person_id,

Line 2564: FROM jtf_rs_rep_managers den

2560: IS
2561: /* CURSOR denorm_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
2562: IS
2563: SELECT distinct(den.denorm_mgr_id) denorm_mgr_id
2564: FROM jtf_rs_rep_managers den
2565: WHERE par_role_relate_id = l_role_relate_id
2566: OR child_role_relate_id = l_role_relate_id;
2567:
2568: denorm_rec denorm_cur%rowtype;

Line 2617: jtf_rs_rep_managers_pkg.delete_row(denorm_rec.denorm_mgr_id);

2613: OPEN denorm_cur(l_role_relate_id);
2614: FETCH denorm_cur INTO denorm_rec;
2615: WHILE(denorm_cur%FOUND)
2616: LOOP
2617: jtf_rs_rep_managers_pkg.delete_row(denorm_rec.denorm_mgr_id);
2618:
2619:
2620: IF fnd_api.to_boolean (p_commit)
2621: THEN

Line 2634: DELETE FROM jtf_rs_rep_managers

2630: FETCH denorm_cur INTO denorm_rec;
2631: END LOOP; --end of denorm cur loop
2632: */
2633: -- Single delete statement is added instead of Delete in loop.
2634: DELETE FROM jtf_rs_rep_managers
2635: WHERE par_role_relate_id = p_role_relate_id
2636: OR child_role_relate_id = p_role_relate_id;
2637:
2638: IF fnd_api.to_boolean (p_commit)

Line 2706: FROM jtf_rs_rep_managers den

2702: IS
2703: CURSOR denorm_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
2704: IS
2705: SELECT distinct(den.denorm_mgr_id) denorm_mgr_id
2706: FROM jtf_rs_rep_managers den
2707: WHERE par_role_relate_id = l_role_relate_id
2708: OR child_role_relate_id = l_role_relate_id;
2709:
2710: denorm_rec denorm_cur%rowtype;

Line 2759: jtf_rs_rep_managers_pkg.delete_row(denorm_rec.denorm_mgr_id);

2755: /* OPEN denorm_cur(l_role_relate_id);
2756: FETCH denorm_cur INTO denorm_rec;
2757: WHILE(denorm_cur%FOUND)
2758: LOOP
2759: jtf_rs_rep_managers_pkg.delete_row(denorm_rec.denorm_mgr_id);
2760:
2761: IF fnd_api.to_boolean (p_commit)
2762: THEN
2763: l_count := l_count + 1;

Line 2775: delete jtf_rs_rep_managers where par_role_relate_id = p_role_relate_id;

2771: FETCH denorm_cur INTO denorm_rec;
2772: END LOOP; --end of denorm cur loop
2773: */
2774:
2775: delete jtf_rs_rep_managers where par_role_relate_id = p_role_relate_id;
2776:
2777: IF fnd_api.to_boolean (p_commit)
2778: THEN
2779: COMMIT WORK;

Line 2782: delete jtf_rs_rep_managers where child_role_relate_id = p_role_relate_id;

2778: THEN
2779: COMMIT WORK;
2780: END IF;
2781:
2782: delete jtf_rs_rep_managers where child_role_relate_id = p_role_relate_id;
2783:
2784: IF fnd_api.to_boolean (p_commit)
2785: THEN
2786: COMMIT WORK;

Line 2872: FROM jtf_rs_rep_managers

2868: CURSOR rep_denorm_cur(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
2869: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
2870: IS
2871: SELECT denorm_mgr_id
2872: FROM jtf_rs_rep_managers
2873: WHERE par_role_relate_id = l_par_role_relate_id
2874: AND child_role_relate_id = l_child_role_relate_id;
2875:
2876: rep_denorm_rec rep_denorm_cur%rowtype;

Line 2937: delete jtf_rs_rep_managers

2933: OPEN child_role_relate_cur(denorm_rec.group_id);
2934: FETCH child_role_relate_cur INTO child_role_relate_rec;
2935: WHILE(child_role_relate_cur%FOUND)
2936: LOOP
2937: delete jtf_rs_rep_managers
2938: where par_role_relate_id = par_role_relate_rec.role_relate_id
2939: and child_role_relate_id = child_role_relate_rec.role_relate_id;
2940:
2941:

Line 3029: SELECT jtf_rs_rep_managers_s.nextval

3025: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3026: IS
3027: CURSOR rep_mgr_seq_cur
3028: IS
3029: SELECT jtf_rs_rep_managers_s.nextval
3030: FROM dual;
3031:
3032:
3033: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

Line 3072: FROM jtf_rs_rep_managers

3068: l_start_date_active DATE,
3069: l_end_date_active DATE)
3070: IS
3071: SELECT person_id
3072: FROM jtf_rs_rep_managers
3073: WHERE group_id = l_group_id
3074: AND ( person_id = l_person_id
3075: OR (l_person_id IS NULL AND person_id IS NULL))
3076: AND manager_person_id = l_manager_person_id

Line 3087: FROM jtf_rs_rep_managers

3083: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
3084: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
3085: IS
3086: SELECT person_id
3087: FROM jtf_rs_rep_managers
3088: WHERE par_role_relate_id = l_par_role_relate_id
3089: AND child_role_relate_id = l_child_role_relate_id
3090: AND group_id = l_group_id;
3091:

Line 3180: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;

3176:
3177:
3178:
3179: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
3180: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
3181: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
3182: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
3183: x_row_id VARCHAR2(100);
3184:

Line 3181: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;

3177:
3178:
3179: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
3180: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
3181: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
3182: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
3183: x_row_id VARCHAR2(100);
3184:
3185: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_REP_MGR_PARENT';

Line 3182: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;

3178:
3179: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := p_role_relate_id;
3180: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
3181: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE;
3182: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
3183: x_row_id VARCHAR2(100);
3184:
3185: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_REP_MGR_PARENT';
3186: l_api_version CONSTANT NUMBER :=1.0;

Line 3308: jtf_rs_rep_managers_pkg.insert_row(

3304: OPEN rep_mgr_seq_cur;
3305: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
3306: CLOSE rep_mgr_seq_cur;
3307:
3308: jtf_rs_rep_managers_pkg.insert_row(
3309: X_ROWID => x_row_id,
3310: X_DENORM_MGR_ID => l_denorm_mgr_id,
3311: X_RESOURCE_ID => mem_dtls_rec.resource_id,
3312: X_PERSON_ID => mem_dtls_rec.person_id,

Line 3379: jtf_rs_rep_managers_pkg.insert_row(

3375: OPEN rep_mgr_seq_cur;
3376: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
3377: CLOSE rep_mgr_seq_cur;
3378:
3379: jtf_rs_rep_managers_pkg.insert_row(
3380: X_ROWID => x_row_id,
3381: X_DENORM_MGR_ID => l_denorm_mgr_id,
3382: X_RESOURCE_ID => mem_dtls_rec.resource_id,
3383: X_PERSON_ID => mem_dtls_rec.person_id,

Line 3613: SELECT jtf_rs_rep_managers_s.nextval

3609: IF l_start_date_active > l_end_date_active THEN
3610: RAISE skip_row;
3611: END IF;
3612:
3613: SELECT jtf_rs_rep_managers_s.nextval
3614: INTO l_denorm_manager_id
3615: FROM dual;
3616:
3617: /* to_char(l_process_table(k).PERSON_ID)||'..'||

Line 3630: INSERT INTO JTF_RS_REP_MANAGERS

3626: to_char(l_process_table(k).CHILD_ROLE_RELATE_ID)||'..'||
3627: to_char(l_process_table(k).PARENT_RESOURCE_ID));
3628:
3629: */
3630: INSERT INTO JTF_RS_REP_MANAGERS
3631: ( DENORM_MGR_ID,
3632: RESOURCE_ID,
3633: PERSON_ID,
3634: CATEGORY,

Line 3949: DELETE JTF_RS_REP_MANAGERS

3945: OPEN c_parent_role_relate_cur(p_parent_group_id);
3946: FETCH c_parent_role_relate_cur INTO r_parent_role_relate_rec;
3947: WHILE(c_parent_role_relate_cur%found)
3948: LOOP
3949: DELETE JTF_RS_REP_MANAGERS
3950: WHERE child_role_relate_id = r_child_role_relate_rec.role_relate_id
3951: AND par_role_relate_id = r_parent_role_relate_rec.role_relate_id ;
3952:
3953: FETCH c_parent_role_relate_cur INTO r_parent_role_relate_rec;

Line 4004: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;

4000: l_date Date;
4001: l_user_id Number;
4002: l_login_id Number;
4003:
4004: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
4005: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE := 'N';
4006: x_row_id VARCHAR2(100);
4007: l_start_date_active DATE;
4008: l_end_date_active DATE;

Line 4005: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE := 'N';

4001: l_user_id Number;
4002: l_login_id Number;
4003:
4004: l_hierarchy_type JTF_RS_REP_MANAGERS.HIERARCHY_TYPE%TYPE;
4005: l_reports_to_flag JTF_RS_REP_MANAGERS.REPORTS_TO_FLAG%TYPE := 'N';
4006: x_row_id VARCHAR2(100);
4007: l_start_date_active DATE;
4008: l_end_date_active DATE;
4009:

Line 4164: SELECT jtf_rs_rep_managers_s.nextval

4160: member_rec member_cur%rowtype;
4161:
4162: CURSOR rep_mgr_seq_cur
4163: IS
4164: SELECT jtf_rs_rep_managers_s.nextval
4165: FROM dual;
4166:
4167: --dupliacte check cursor to be added
4168:

Line 4174: FROM jtf_rs_rep_managers

4170: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4171: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
4172: IS
4173: SELECT person_id
4174: FROM jtf_rs_rep_managers
4175: WHERE par_role_relate_id = l_par_role_relate_id
4176: AND child_role_relate_id = l_child_role_relate_id
4177: AND group_id = l_group_id;
4178: /*

Line 4194: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;

4190:
4191: dup NUMBER := 0;
4192:
4193:
4194: l_denorm_mgr_id JTF_RS_REP_MANAGERS.DENORM_MGR_ID%TYPE;
4195: l_commit number := 0;
4196:
4197: l_count number := 0;
4198: BEGIN

Line 4325: jtf_rs_rep_managers_pkg.insert_row(

4321: OPEN rep_mgr_seq_cur;
4322: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4323: CLOSE rep_mgr_seq_cur;
4324:
4325: jtf_rs_rep_managers_pkg.insert_row(
4326: X_ROWID => x_row_id,
4327: X_DENORM_MGR_ID => l_denorm_mgr_id,
4328: X_RESOURCE_ID => member_rec.resource_id,
4329: X_PERSON_ID => member_rec.person_id,

Line 4380: jtf_rs_rep_managers_pkg.insert_row(

4376: OPEN rep_mgr_seq_cur;
4377: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4378: CLOSE rep_mgr_seq_cur;
4379:
4380: jtf_rs_rep_managers_pkg.insert_row(
4381: X_ROWID => x_row_id,
4382: X_DENORM_MGR_ID => l_denorm_mgr_id,
4383: X_RESOURCE_ID => member_rec.resource_id,
4384: X_PERSON_ID => member_rec.person_id,

Line 4461: jtf_rs_rep_managers_pkg.insert_row(

4457: OPEN rep_mgr_seq_cur;
4458: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4459: CLOSE rep_mgr_seq_cur;
4460:
4461: jtf_rs_rep_managers_pkg.insert_row(
4462: X_ROWID => x_row_id,
4463: X_DENORM_MGR_ID => l_denorm_mgr_id,
4464: X_RESOURCE_ID => member_rec.resource_id,
4465: X_PERSON_ID => member_rec.person_id,

Line 4591: jtf_rs_rep_managers_pkg.insert_row(

4587: OPEN rep_mgr_seq_cur;
4588: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4589: CLOSE rep_mgr_seq_cur;
4590:
4591: jtf_rs_rep_managers_pkg.insert_row(
4592: X_ROWID => x_row_id,
4593: X_DENORM_MGR_ID => l_denorm_mgr_id,
4594: X_RESOURCE_ID => member_rec.resource_id,
4595: X_PERSON_ID => member_rec.person_id,

Line 4649: jtf_rs_rep_managers_pkg.insert_row(

4645: OPEN rep_mgr_seq_cur;
4646: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4647: CLOSE rep_mgr_seq_cur;
4648:
4649: jtf_rs_rep_managers_pkg.insert_row(
4650: X_ROWID => x_row_id,
4651: X_DENORM_MGR_ID => l_denorm_mgr_id,
4652: X_RESOURCE_ID => member_rec.resource_id,
4653: X_PERSON_ID => member_rec.person_id,

Line 4728: jtf_rs_rep_managers_pkg.insert_row(

4724: OPEN rep_mgr_seq_cur;
4725: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4726: CLOSE rep_mgr_seq_cur;
4727:
4728: jtf_rs_rep_managers_pkg.insert_row(
4729: X_ROWID => x_row_id,
4730: X_DENORM_MGR_ID => l_denorm_mgr_id,
4731: X_RESOURCE_ID => member_rec.resource_id,
4732: X_PERSON_ID => member_rec.person_id,