APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on JTF_RS_REP_MANAGERS_PKG

Line 425: jtf_rs_rep_managers_pkg.insert_row(

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

Line 536: jtf_rs_rep_managers_pkg.insert_row(

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

Line 650: jtf_rs_rep_managers_pkg.insert_row(

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

Line 772: jtf_rs_rep_managers_pkg.insert_row(

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

Line 843: jtf_rs_rep_managers_pkg.insert_row(

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

Line 972: jtf_rs_rep_managers_pkg.insert_row(

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

Line 1043: jtf_rs_rep_managers_pkg.insert_row(

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

Line 1519: jtf_rs_rep_managers_pkg.insert_row(

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

Line 1628: jtf_rs_rep_managers_pkg.insert_row(

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

Line 1696: jtf_rs_rep_managers_pkg.insert_row(

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

Line 1802: jtf_rs_rep_managers_pkg.insert_row(

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

Line 1873: jtf_rs_rep_managers_pkg.insert_row(

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

Line 1986: jtf_rs_rep_managers_pkg.insert_row(

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

Line 2055: jtf_rs_rep_managers_pkg.insert_row(

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

Line 2166: jtf_rs_rep_managers_pkg.insert_row(

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

Line 2232: jtf_rs_rep_managers_pkg.insert_row(

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

Line 2369: jtf_rs_rep_managers_pkg.insert_row(

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

Line 2438: jtf_rs_rep_managers_pkg.insert_row(

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

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

2608: OPEN denorm_cur(l_role_relate_id);
2609: FETCH denorm_cur INTO denorm_rec;
2610: WHILE(denorm_cur%FOUND)
2611: LOOP
2612: jtf_rs_rep_managers_pkg.delete_row(denorm_rec.denorm_mgr_id);
2613:
2614:
2615: IF fnd_api.to_boolean (p_commit)
2616: THEN

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

2742: /* OPEN denorm_cur(l_role_relate_id);
2743: FETCH denorm_cur INTO denorm_rec;
2744: WHILE(denorm_cur%FOUND)
2745: LOOP
2746: jtf_rs_rep_managers_pkg.delete_row(denorm_rec.denorm_mgr_id);
2747:
2748: IF fnd_api.to_boolean (p_commit)
2749: THEN
2750: l_count := l_count + 1;

Line 3295: jtf_rs_rep_managers_pkg.insert_row(

3291: OPEN rep_mgr_seq_cur;
3292: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
3293: CLOSE rep_mgr_seq_cur;
3294:
3295: jtf_rs_rep_managers_pkg.insert_row(
3296: X_ROWID => x_row_id,
3297: X_DENORM_MGR_ID => l_denorm_mgr_id,
3298: X_RESOURCE_ID => mem_dtls_rec.resource_id,
3299: X_PERSON_ID => mem_dtls_rec.person_id,

Line 3366: jtf_rs_rep_managers_pkg.insert_row(

3362: OPEN rep_mgr_seq_cur;
3363: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
3364: CLOSE rep_mgr_seq_cur;
3365:
3366: jtf_rs_rep_managers_pkg.insert_row(
3367: X_ROWID => x_row_id,
3368: X_DENORM_MGR_ID => l_denorm_mgr_id,
3369: X_RESOURCE_ID => mem_dtls_rec.resource_id,
3370: X_PERSON_ID => mem_dtls_rec.person_id,

Line 4312: jtf_rs_rep_managers_pkg.insert_row(

4308: OPEN rep_mgr_seq_cur;
4309: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4310: CLOSE rep_mgr_seq_cur;
4311:
4312: jtf_rs_rep_managers_pkg.insert_row(
4313: X_ROWID => x_row_id,
4314: X_DENORM_MGR_ID => l_denorm_mgr_id,
4315: X_RESOURCE_ID => member_rec.resource_id,
4316: X_PERSON_ID => member_rec.person_id,

Line 4367: jtf_rs_rep_managers_pkg.insert_row(

4363: OPEN rep_mgr_seq_cur;
4364: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4365: CLOSE rep_mgr_seq_cur;
4366:
4367: jtf_rs_rep_managers_pkg.insert_row(
4368: X_ROWID => x_row_id,
4369: X_DENORM_MGR_ID => l_denorm_mgr_id,
4370: X_RESOURCE_ID => member_rec.resource_id,
4371: X_PERSON_ID => member_rec.person_id,

Line 4448: jtf_rs_rep_managers_pkg.insert_row(

4444: OPEN rep_mgr_seq_cur;
4445: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4446: CLOSE rep_mgr_seq_cur;
4447:
4448: jtf_rs_rep_managers_pkg.insert_row(
4449: X_ROWID => x_row_id,
4450: X_DENORM_MGR_ID => l_denorm_mgr_id,
4451: X_RESOURCE_ID => member_rec.resource_id,
4452: X_PERSON_ID => member_rec.person_id,

Line 4578: jtf_rs_rep_managers_pkg.insert_row(

4574: OPEN rep_mgr_seq_cur;
4575: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4576: CLOSE rep_mgr_seq_cur;
4577:
4578: jtf_rs_rep_managers_pkg.insert_row(
4579: X_ROWID => x_row_id,
4580: X_DENORM_MGR_ID => l_denorm_mgr_id,
4581: X_RESOURCE_ID => member_rec.resource_id,
4582: X_PERSON_ID => member_rec.person_id,

Line 4636: jtf_rs_rep_managers_pkg.insert_row(

4632: OPEN rep_mgr_seq_cur;
4633: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4634: CLOSE rep_mgr_seq_cur;
4635:
4636: jtf_rs_rep_managers_pkg.insert_row(
4637: X_ROWID => x_row_id,
4638: X_DENORM_MGR_ID => l_denorm_mgr_id,
4639: X_RESOURCE_ID => member_rec.resource_id,
4640: X_PERSON_ID => member_rec.person_id,

Line 4715: jtf_rs_rep_managers_pkg.insert_row(

4711: OPEN rep_mgr_seq_cur;
4712: FETCH rep_mgr_seq_cur INTO l_denorm_mgr_id;
4713: CLOSE rep_mgr_seq_cur;
4714:
4715: jtf_rs_rep_managers_pkg.insert_row(
4716: X_ROWID => x_row_id,
4717: X_DENORM_MGR_ID => l_denorm_mgr_id,
4718: X_RESOURCE_ID => member_rec.resource_id,
4719: X_PERSON_ID => member_rec.person_id,