APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on JTF_RS_REP_MANAGERS_PKG

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 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 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 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 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 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,