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.PV_USER_RESP_PVT dependencies on JTF_NUMBER_TABLE

Line 131: RETURN JTF_NUMBER_TABLE

127: FUNCTION get_partner_users (
128: p_partner_id IN NUMBER,
129: p_user_role_code IN VARCHAR2
130: )
131: RETURN JTF_NUMBER_TABLE
132: IS
133: l_user_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
134: l_user_id NUMBER;
135: i NUMBER := 1;

Line 133: l_user_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

129: p_user_role_code IN VARCHAR2
130: )
131: RETURN JTF_NUMBER_TABLE
132: IS
133: l_user_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
134: l_user_id NUMBER;
135: i NUMBER := 1;
136:
137: CURSOR c_primary_user_ids IS

Line 223: RETURN JTF_NUMBER_TABLE

219: FUNCTION get_partner_users_2 (
220: p_partner_id IN NUMBER,
221: p_user_role_code IN VARCHAR2
222: )
223: RETURN JTF_NUMBER_TABLE
224: IS
225: l_user_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
226: l_user_id NUMBER;
227: i NUMBER := 1;

Line 225: l_user_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

221: p_user_role_code IN VARCHAR2
222: )
223: RETURN JTF_NUMBER_TABLE
224: IS
225: l_user_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
226: l_user_id NUMBER;
227: i NUMBER := 1;
228:
229: CURSOR c_primary_user_ids IS

Line 379: RETURN JTF_NUMBER_TABLE

375: */
376: FUNCTION get_partners (
377: p_user_id IN NUMBER
378: )
379: RETURN JTF_NUMBER_TABLE
380: IS
381: l_partner_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
382: l_user_id NUMBER;
383: l_index NUMBER := 1;

Line 381: l_partner_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

377: p_user_id IN NUMBER
378: )
379: RETURN JTF_NUMBER_TABLE
380: IS
381: l_partner_ids_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
382: l_user_id NUMBER;
383: l_index NUMBER := 1;
384:
385: CURSOR c_get_partner_id IS

Line 674: p_user_id IN JTF_NUMBER_TABLE,

670: PROCEDURE revoke_resp(
671: p_api_version_number IN NUMBER,
672: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
673: p_commit IN VARCHAR2 := Fnd_Api.g_false,
674: p_user_id IN JTF_NUMBER_TABLE,
675: p_resp_id IN NUMBER,
676: x_return_status OUT NOCOPY VARCHAR2,
677: x_msg_count OUT NOCOPY NUMBER,
678: x_msg_data OUT NOCOPY VARCHAR2

Line 686: SELECT * FROM TABLE (CAST(p_user_id AS JTF_NUMBER_TABLE))

682: CURSOR c_get_user_resp_groups IS
683: SELECT user_id, responsibility_id, responsibility_application_id, security_group_id, start_date, description
684: FROM fnd_user_resp_groups
685: WHERE user_id in (
686: SELECT * FROM TABLE (CAST(p_user_id AS JTF_NUMBER_TABLE))
687: )
688: AND responsibility_id = p_resp_id;
689:
690: l_api_name CONSTANT VARCHAR2(30) := 'revoke_resp';

Line 905: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

901: AND rmr.delete_flag = 'N';
902:
903: l_api_name CONSTANT VARCHAR2(30) := 'get_default_resp';
904: l_api_version_number CONSTANT NUMBER := 1.0;
905: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
906: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
907: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
908: l_index NUMBER;
909: l_matched_geo_hierarchy_id NUMBER;

Line 906: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

902:
903: l_api_name CONSTANT VARCHAR2(30) := 'get_default_resp';
904: l_api_version_number CONSTANT NUMBER := 1.0;
905: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
906: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
907: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
908: l_index NUMBER;
909: l_matched_geo_hierarchy_id NUMBER;
910: l_responsibility_id NUMBER;

Line 907: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

903: l_api_name CONSTANT VARCHAR2(30) := 'get_default_resp';
904: l_api_version_number CONSTANT NUMBER := 1.0;
905: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
906: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
907: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
908: l_index NUMBER;
909: l_matched_geo_hierarchy_id NUMBER;
910: l_responsibility_id NUMBER;
911:

Line 1101: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1097: AND rmr.delete_flag = 'N';
1098:
1099: l_api_name CONSTANT VARCHAR2(30) := 'get_default_org_resp';
1100: l_api_version_number CONSTANT NUMBER := 1.0;
1101: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1102: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1103: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1104: l_index NUMBER;
1105: l_matched_geo_hierarchy_id NUMBER;

Line 1102: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1098:
1099: l_api_name CONSTANT VARCHAR2(30) := 'get_default_org_resp';
1100: l_api_version_number CONSTANT NUMBER := 1.0;
1101: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1102: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1103: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1104: l_index NUMBER;
1105: l_matched_geo_hierarchy_id NUMBER;
1106: l_responsibility_id NUMBER;

Line 1103: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1099: l_api_name CONSTANT VARCHAR2(30) := 'get_default_org_resp';
1100: l_api_version_number CONSTANT NUMBER := 1.0;
1101: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1102: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1103: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1104: l_index NUMBER;
1105: l_matched_geo_hierarchy_id NUMBER;
1106: l_responsibility_id NUMBER;
1107:

Line 1296: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1292: AND rmr.delete_flag = 'N';
1293:
1294: l_api_name CONSTANT VARCHAR2(30) := 'get_program_resp';
1295: l_api_version_number CONSTANT NUMBER := 1.0;
1296: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1297: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1298: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1299: l_index NUMBER;
1300: l_matched_geo_hierarchy_id NUMBER;

Line 1297: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1293:
1294: l_api_name CONSTANT VARCHAR2(30) := 'get_program_resp';
1295: l_api_version_number CONSTANT NUMBER := 1.0;
1296: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1297: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1298: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1299: l_index NUMBER;
1300: l_matched_geo_hierarchy_id NUMBER;
1301: l_responsibility_id NUMBER;

Line 1298: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1294: l_api_name CONSTANT VARCHAR2(30) := 'get_program_resp';
1295: l_api_version_number CONSTANT NUMBER := 1.0;
1296: l_geo_hierarchy_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1297: l_responsibility_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1298: l_resp_map_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1299: l_index NUMBER;
1300: l_matched_geo_hierarchy_id NUMBER;
1301: l_responsibility_id NUMBER;
1302:

Line 1460: ,p_partner_id IN JTF_NUMBER_TABLE

1456: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1457: ,x_return_status OUT NOCOPY VARCHAR2
1458: ,x_msg_count OUT NOCOPY NUMBER
1459: ,x_msg_data OUT NOCOPY VARCHAR2
1460: ,p_partner_id IN JTF_NUMBER_TABLE
1461: ,x_responsibility_id OUT NOCOPY JTF_NUMBER_TABLE
1462: ,x_resp_map_rule_id OUT NOCOPY JTF_NUMBER_TABLE
1463: )
1464: IS

Line 1461: ,x_responsibility_id OUT NOCOPY JTF_NUMBER_TABLE

1457: ,x_return_status OUT NOCOPY VARCHAR2
1458: ,x_msg_count OUT NOCOPY NUMBER
1459: ,x_msg_data OUT NOCOPY VARCHAR2
1460: ,p_partner_id IN JTF_NUMBER_TABLE
1461: ,x_responsibility_id OUT NOCOPY JTF_NUMBER_TABLE
1462: ,x_resp_map_rule_id OUT NOCOPY JTF_NUMBER_TABLE
1463: )
1464: IS
1465: CURSOR get_resp_id IS

Line 1462: ,x_resp_map_rule_id OUT NOCOPY JTF_NUMBER_TABLE

1458: ,x_msg_count OUT NOCOPY NUMBER
1459: ,x_msg_data OUT NOCOPY VARCHAR2
1460: ,p_partner_id IN JTF_NUMBER_TABLE
1461: ,x_responsibility_id OUT NOCOPY JTF_NUMBER_TABLE
1462: ,x_resp_map_rule_id OUT NOCOPY JTF_NUMBER_TABLE
1463: )
1464: IS
1465: CURSOR get_resp_id IS
1466: SELECT ben.benefit_id, ben.program_benefits_id

Line 1478: FROM pv_pg_memberships mem, (SELECT column_value FROM TABLE (CAST(p_partner_id AS JTF_NUMBER_TABLE))) t

1474: FROM pv_partner_program_b
1475: START WITH program_id in
1476: (
1477: SELECT /*+ leading(T) USE_NL(T MEM)*/ mem.program_id
1478: FROM pv_pg_memberships mem, (SELECT column_value FROM TABLE (CAST(p_partner_id AS JTF_NUMBER_TABLE))) t
1479: WHERE mem.partner_id = t.column_value
1480: AND mem.membership_status_code = 'ACTIVE'
1481: )
1482: CONNECT BY PRIOR program_parent_id = program_id

Line 1487: l_responsibility_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1483: );
1484:
1485: l_api_name CONSTANT VARCHAR2(30) := 'get_store_prgm_resps';
1486: l_api_version_number CONSTANT NUMBER := 1.0;
1487: l_responsibility_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1488: l_resp_map_rule_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1489: i NUMBER;
1490:
1491: BEGIN

Line 1488: l_resp_map_rule_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1484:
1485: l_api_name CONSTANT VARCHAR2(30) := 'get_store_prgm_resps';
1486: l_api_version_number CONSTANT NUMBER := 1.0;
1487: l_responsibility_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1488: l_resp_map_rule_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1489: i NUMBER;
1490:
1491: BEGIN
1492: ---- Initialize----------------

Line 1604: ,x_responsibility_id OUT NOCOPY JTF_NUMBER_TABLE

1600: ,x_return_status OUT NOCOPY VARCHAR2
1601: ,x_msg_count OUT NOCOPY NUMBER
1602: ,x_msg_data OUT NOCOPY VARCHAR2
1603: ,p_program_id IN NUMBER
1604: ,x_responsibility_id OUT NOCOPY JTF_NUMBER_TABLE
1605: ,x_resp_map_rule_id OUT NOCOPY JTF_NUMBER_TABLE
1606: )
1607: IS
1608: CURSOR get_resp_id IS

Line 1605: ,x_resp_map_rule_id OUT NOCOPY JTF_NUMBER_TABLE

1601: ,x_msg_count OUT NOCOPY NUMBER
1602: ,x_msg_data OUT NOCOPY VARCHAR2
1603: ,p_program_id IN NUMBER
1604: ,x_responsibility_id OUT NOCOPY JTF_NUMBER_TABLE
1605: ,x_resp_map_rule_id OUT NOCOPY JTF_NUMBER_TABLE
1606: )
1607: IS
1608: CURSOR get_resp_id IS
1609: SELECT ben.benefit_id, ben.program_benefits_id

Line 1622: l_responsibility_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1618: AND ben.delete_flag = 'N';
1619:
1620: l_api_name CONSTANT VARCHAR2(30) := 'get_store_prgm_resps';
1621: l_api_version_number CONSTANT NUMBER := 1.0;
1622: l_responsibility_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1623: l_resp_map_rule_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1624: i NUMBER;
1625:
1626: BEGIN

Line 1623: l_resp_map_rule_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1619:
1620: l_api_name CONSTANT VARCHAR2(30) := 'get_store_prgm_resps';
1621: l_api_version_number CONSTANT NUMBER := 1.0;
1622: l_responsibility_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1623: l_resp_map_rule_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1624: i NUMBER;
1625:
1626: BEGIN
1627: ---- Initialize----------------

Line 1743: ,p_user_ids_tbl IN JTF_NUMBER_TABLE

1739: ,x_return_status OUT NOCOPY VARCHAR2
1740: ,x_msg_count OUT NOCOPY NUMBER
1741: ,x_msg_data OUT NOCOPY VARCHAR2
1742: ,p_user_role_code IN VARCHAR2
1743: ,p_user_ids_tbl IN JTF_NUMBER_TABLE
1744: ,p_partner_id IN NUMBER
1745: )
1746: IS
1747: l_api_name CONSTANT VARCHAR2(30) := 'get_default_assign_addrow';

Line 1753: l_user_ids_tbl JTF_NUMBER_TABLE;

1749: l_responsibility_id NUMBER;
1750: l_resp_map_rule_id NUMBER;
1751: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
1752: l_ptnr_resp_id NUMBER;
1753: l_user_ids_tbl JTF_NUMBER_TABLE;
1754:
1755: BEGIN
1756: ---- Initialize----------------
1757:

Line 2083: CURSOR c_get_resp_id (cv_partner_id JTF_NUMBER_TABLE, cv_user_role_code VARCHAR2, cv_resp_type_code VARCHAR2) IS

2079: ,p_user_id IN NUMBER
2080: ,p_user_role_code IN VARCHAR2
2081: )
2082: IS
2083: CURSOR c_get_resp_id (cv_partner_id JTF_NUMBER_TABLE, cv_user_role_code VARCHAR2, cv_resp_type_code VARCHAR2) IS
2084: SELECT /*+ CARDINALITY(t 10) */ responsibility_id
2085: FROM pv_ge_ptnr_resps,
2086: (SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t
2087: WHERE partner_id = t.column_value

Line 2086: (SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t

2082: IS
2083: CURSOR c_get_resp_id (cv_partner_id JTF_NUMBER_TABLE, cv_user_role_code VARCHAR2, cv_resp_type_code VARCHAR2) IS
2084: SELECT /*+ CARDINALITY(t 10) */ responsibility_id
2085: FROM pv_ge_ptnr_resps,
2086: (SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t
2087: WHERE partner_id = t.column_value
2088: AND user_role_code = cv_user_role_code
2089: AND resp_type_code = cv_resp_type_code;
2090:

Line 2091: CURSOR c_get_program_id (cv_partner_id JTF_NUMBER_TABLE) IS

2087: WHERE partner_id = t.column_value
2088: AND user_role_code = cv_user_role_code
2089: AND resp_type_code = cv_resp_type_code;
2090:
2091: CURSOR c_get_program_id (cv_partner_id JTF_NUMBER_TABLE) IS
2092: SELECT /*+ CARDINALITY(t 10) */ program_id, partner_id
2093: FROM pv_pg_memberships,
2094: (SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t
2095: WHERE partner_id = t.column_value

Line 2094: (SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t

2090:
2091: CURSOR c_get_program_id (cv_partner_id JTF_NUMBER_TABLE) IS
2092: SELECT /*+ CARDINALITY(t 10) */ program_id, partner_id
2093: FROM pv_pg_memberships,
2094: (SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t
2095: WHERE partner_id = t.column_value
2096: AND membership_status_code = 'ACTIVE';
2097:
2098: l_api_name CONSTANT VARCHAR2(30) := 'assign_user_resps';

Line 2100: l_responsibility_id_tbl JTF_NUMBER_TABLE;

2096: AND membership_status_code = 'ACTIVE';
2097:
2098: l_api_name CONSTANT VARCHAR2(30) := 'assign_user_resps';
2099: l_api_version_number CONSTANT NUMBER := 1.0;
2100: l_responsibility_id_tbl JTF_NUMBER_TABLE;
2101: l_responsibility_id NUMBER;
2102: l_resp_map_rule_id NUMBER;
2103: l_partner_ids_tbl JTF_NUMBER_TABLE;
2104: l_resp_exist VARCHAR(1) := 'N';

Line 2103: l_partner_ids_tbl JTF_NUMBER_TABLE;

2099: l_api_version_number CONSTANT NUMBER := 1.0;
2100: l_responsibility_id_tbl JTF_NUMBER_TABLE;
2101: l_responsibility_id NUMBER;
2102: l_resp_map_rule_id NUMBER;
2103: l_partner_ids_tbl JTF_NUMBER_TABLE;
2104: l_resp_exist VARCHAR(1) := 'N';
2105: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
2106: l_ptnr_resp_id NUMBER;
2107: l_user_ids_tbl JTF_NUMBER_TABLE;

Line 2107: l_user_ids_tbl JTF_NUMBER_TABLE;

2103: l_partner_ids_tbl JTF_NUMBER_TABLE;
2104: l_resp_exist VARCHAR(1) := 'N';
2105: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
2106: l_ptnr_resp_id NUMBER;
2107: l_user_ids_tbl JTF_NUMBER_TABLE;
2108: BEGIN
2109: ---- Initialize----------------
2110:
2111: -- Standard Start of API savepoint

Line 2254: l_user_ids_tbl := JTF_NUMBER_TABLE();

2250: END IF;
2251: -- If there is no program responsibility (l_resp_exist still equals to 'N'),
2252: -- get the default responsibility and assign it to the user
2253: IF (l_resp_exist = 'N') THEN
2254: l_user_ids_tbl := JTF_NUMBER_TABLE();
2255: l_user_ids_tbl.extend;
2256: l_user_ids_tbl(1) := p_user_id;
2257: FOR l_cnt IN 1..l_partner_ids_tbl.count LOOP
2258: get_default_assign_addrow(

Line 2510: CURSOR c_get_respid_and_action (cv_partner_id JTF_NUMBER_TABLE, cv_user_id NUMBER, cv_from_user_role_code VARCHAR2, cv_to_user_role_code VARCHAR2) IS

2506: ,p_from_user_role_code IN VARCHAR2
2507: ,p_to_user_role_code IN VARCHAR2
2508: )
2509: IS
2510: CURSOR c_get_respid_and_action (cv_partner_id JTF_NUMBER_TABLE, cv_user_id NUMBER, cv_from_user_role_code VARCHAR2, cv_to_user_role_code VARCHAR2) IS
2511: (SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'REVOKE' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2512: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2513: WHERE partner_id in (
2514: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))

Line 2514: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))

2510: CURSOR c_get_respid_and_action (cv_partner_id JTF_NUMBER_TABLE, cv_user_id NUMBER, cv_from_user_role_code VARCHAR2, cv_to_user_role_code VARCHAR2) IS
2511: (SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'REVOKE' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2512: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2513: WHERE partner_id in (
2514: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))
2515: )
2516: AND p.user_role_code = cv_from_user_role_code
2517: AND p.responsibility_id = f.responsibility_id
2518: AND f.user_id = cv_user_id

Line 2524: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))

2520: MINUS
2521: SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'REVOKE' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2522: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2523: WHERE partner_id in (
2524: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))
2525: )
2526: AND p.user_role_code = cv_to_user_role_code
2527: AND p.responsibility_id = f.responsibility_id
2528: AND f.user_id = cv_user_id

Line 2535: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))

2531: UNION
2532: (SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'ASSIGN' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2533: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2534: WHERE partner_id in (
2535: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))
2536: )
2537: AND p.user_role_code = cv_to_user_role_code
2538: AND p.responsibility_id = f.responsibility_id
2539: AND f.user_id = cv_user_id

Line 2545: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))

2541: MINUS
2542: SELECT /*+LEADING(T) USE_NL(t p f)*/ p.responsibility_id, 'ASSIGN' action, f.responsibility_application_id, f.security_group_id, f.start_date, f.description
2543: FROM pv_ge_ptnr_resps p, fnd_user_resp_groups f
2544: WHERE partner_id in (
2545: SELECT * FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))
2546: )
2547: AND p.user_role_code = cv_from_user_role_code
2548: AND p.responsibility_id = f.responsibility_id
2549: AND f.user_id = cv_user_id

Line 2555: l_partner_ids_tbl JTF_NUMBER_TABLE;

2551: );
2552:
2553: l_api_name CONSTANT VARCHAR2(30) := 'switch_user_resp';
2554: l_api_version_number CONSTANT NUMBER := 1.0;
2555: l_partner_ids_tbl JTF_NUMBER_TABLE;
2556: l_is_resp_assigned boolean := false;
2557:
2558: BEGIN
2559: ---- Initialize----------------

Line 2736: ,p_user_ids_tbl IN JTF_NUMBER_TABLE

2732: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2733: ,x_return_status OUT NOCOPY VARCHAR2
2734: ,x_msg_count OUT NOCOPY NUMBER
2735: ,x_msg_data OUT NOCOPY VARCHAR2
2736: ,p_user_ids_tbl IN JTF_NUMBER_TABLE
2737: ,p_ptnr_resp_id IN NUMBER
2738: ,p_old_responsibility_id IN NUMBER
2739: ,p_new_responsibility_id IN NUMBER
2740: ,p_program_id IN NUMBER := null

Line 2958: l_user_ids_tbl JTF_NUMBER_TABLE;

2954: AND resp_type_code = G_PROGRAM;
2955:
2956: l_api_name CONSTANT VARCHAR2(30) := 'manage_ter_exp_memb_resp';
2957: l_api_version_number CONSTANT NUMBER := 1.0;
2958: l_user_ids_tbl JTF_NUMBER_TABLE;
2959: l_related_partner_id_tbl JTF_NUMBER_TABLE;
2960: l_exist NUMBER;
2961: l_count NUMBER;
2962: l_responsibility_id JTF_NUMBER_TABLE;

Line 2959: l_related_partner_id_tbl JTF_NUMBER_TABLE;

2955:
2956: l_api_name CONSTANT VARCHAR2(30) := 'manage_ter_exp_memb_resp';
2957: l_api_version_number CONSTANT NUMBER := 1.0;
2958: l_user_ids_tbl JTF_NUMBER_TABLE;
2959: l_related_partner_id_tbl JTF_NUMBER_TABLE;
2960: l_exist NUMBER;
2961: l_count NUMBER;
2962: l_responsibility_id JTF_NUMBER_TABLE;
2963: l_no_revoke BOOLEAN;

Line 2962: l_responsibility_id JTF_NUMBER_TABLE;

2958: l_user_ids_tbl JTF_NUMBER_TABLE;
2959: l_related_partner_id_tbl JTF_NUMBER_TABLE;
2960: l_exist NUMBER;
2961: l_count NUMBER;
2962: l_responsibility_id JTF_NUMBER_TABLE;
2963: l_no_revoke BOOLEAN;
2964: BEGIN
2965: ---- Initialize----------------
2966:

Line 3278: l_store_responsibility_id JTF_NUMBER_TABLE;

3274:
3275: l_api_name CONSTANT VARCHAR2(30) := 'manage_active_memb_resp';
3276: l_api_version_number CONSTANT NUMBER := 1.0;
3277: l_responsibility_id NUMBER;
3278: l_store_responsibility_id JTF_NUMBER_TABLE;
3279: l_store_resp_map_rule_id JTF_NUMBER_TABLE;
3280: l_resp_map_rule_id NUMBER;
3281: l_ptnr_resp_id NUMBER;
3282: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

Line 3279: l_store_resp_map_rule_id JTF_NUMBER_TABLE;

3275: l_api_name CONSTANT VARCHAR2(30) := 'manage_active_memb_resp';
3276: l_api_version_number CONSTANT NUMBER := 1.0;
3277: l_responsibility_id NUMBER;
3278: l_store_responsibility_id JTF_NUMBER_TABLE;
3279: l_store_resp_map_rule_id JTF_NUMBER_TABLE;
3280: l_resp_map_rule_id NUMBER;
3281: l_ptnr_resp_id NUMBER;
3282: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
3283: l_user_ids_tbl JTF_NUMBER_TABLE;

Line 3283: l_user_ids_tbl JTF_NUMBER_TABLE;

3279: l_store_resp_map_rule_id JTF_NUMBER_TABLE;
3280: l_resp_map_rule_id NUMBER;
3281: l_ptnr_resp_id NUMBER;
3282: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
3283: l_user_ids_tbl JTF_NUMBER_TABLE;
3284:
3285: BEGIN
3286: ---- Initialize----------------
3287:

Line 3783: l_user_ids_tbl JTF_NUMBER_TABLE;

3779: WHERE membership_id = cv_membership_id;
3780:
3781: l_api_name CONSTANT VARCHAR2(30) := 'manage_memb_resp';
3782: l_api_version_number CONSTANT NUMBER := 1.0;
3783: l_user_ids_tbl JTF_NUMBER_TABLE;
3784: l_responsibility_id NUMBER;
3785: l_resp_map_rule_id NUMBER;
3786:
3787: BEGIN

Line 3950: l_user_ids_tbl JTF_NUMBER_TABLE;

3946: AND resp_type_code = G_PROGRAM;
3947:
3948: l_api_name CONSTANT VARCHAR2(30) := 'delete_resp_mapping';
3949: l_api_version_number CONSTANT NUMBER := 1.0;
3950: l_user_ids_tbl JTF_NUMBER_TABLE;
3951: l_exist NUMBER;
3952: l_count NUMBER;
3953: l_responsibility_id NUMBER;
3954: l_resp_map_rule_id NUMBER;

Line 4313: l_user_ids_tbl JTF_NUMBER_TABLE;

4309: AND resp_type_code = G_PROGRAM;
4310:
4311: l_api_name CONSTANT VARCHAR2(30) := 'update_resp_mapping';
4312: l_api_version_number CONSTANT NUMBER := 1.0;
4313: l_user_ids_tbl JTF_NUMBER_TABLE;
4314: l_first_time_flag VARCHAR2(1);
4315: l_count NUMBER;
4316: l_new_responsibility_id NUMBER;
4317: l_resp_map_rule_id NUMBER;

Line 4574: l_user_ids_tbl JTF_NUMBER_TABLE;

4570: AND resp_type_code = G_PROGRAM;
4571:
4572: l_api_name CONSTANT VARCHAR2(30) := 'create_resp_mapping';
4573: l_api_version_number CONSTANT NUMBER := 1.0;
4574: l_user_ids_tbl JTF_NUMBER_TABLE;
4575: l_first_time_flag VARCHAR2(1);
4576: l_count NUMBER;
4577: l_new_responsibility_id NUMBER;
4578: l_resp_map_rule_id NUMBER;

Line 4944: CURSOR c_get_resp_info (cv_partner_id JTF_NUMBER_TABLE) IS

4940: ,p_user_role_code IN VARCHAR2
4941: )
4942: IS
4943: -- Fixed for bug 3766776
4944: CURSOR c_get_resp_info (cv_partner_id JTF_NUMBER_TABLE) IS
4945: SELECT /*+ LEADING(T) USE_NL (T P F) */
4946: p.responsibility_id, f.responsibility_application_id, f.security_group_id,
4947: f.start_date, f.description, f.user_id
4948: FROM pv_ge_ptnr_resps p,

Line 4949: (SELECT column_value FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t ,

4945: SELECT /*+ LEADING(T) USE_NL (T P F) */
4946: p.responsibility_id, f.responsibility_application_id, f.security_group_id,
4947: f.start_date, f.description, f.user_id
4948: FROM pv_ge_ptnr_resps p,
4949: (SELECT column_value FROM TABLE (CAST(cv_partner_id AS JTF_NUMBER_TABLE))) t ,
4950: fnd_user_resp_groups f
4951: WHERE p.partner_id = t.column_value
4952: AND nvl(end_date, sysdate) >= sysdate
4953: AND f.user_id = p_user_id

Line 4958: CURSOR c_get_user_resp_groups (cv_responsibility_id_tbl JTF_NUMBER_TABLE) IS

4954: AND f.responsibility_id = p.responsibility_id
4955: AND user_role_code in (p_user_role_code, G_ALL);
4956:
4957: -- Fixed for bug 3766776
4958: CURSOR c_get_user_resp_groups (cv_responsibility_id_tbl JTF_NUMBER_TABLE) IS
4959: SELECT
4960: user_id, responsibility_id, responsibility_application_id, security_group_id,
4961: start_date, description
4962: FROM fnd_user_resp_groups,

Line 4963: (SELECT column_value FROM TABLE (CAST(cv_responsibility_id_tbl AS JTF_NUMBER_TABLE))) t

4959: SELECT
4960: user_id, responsibility_id, responsibility_application_id, security_group_id,
4961: start_date, description
4962: FROM fnd_user_resp_groups,
4963: (SELECT column_value FROM TABLE (CAST(cv_responsibility_id_tbl AS JTF_NUMBER_TABLE))) t
4964: WHERE responsibility_id = t.column_value
4965: AND user_id = p_user_id;
4966:
4967: l_api_name CONSTANT VARCHAR2(30) := 'revoke_user_resps';

Line 4969: primary_user_ids_tbl JTF_NUMBER_TABLE;

4965: AND user_id = p_user_id;
4966:
4967: l_api_name CONSTANT VARCHAR2(30) := 'revoke_user_resps';
4968: l_api_version_number CONSTANT NUMBER := 1.0;
4969: primary_user_ids_tbl JTF_NUMBER_TABLE;
4970: business_user_ids_tbl JTF_NUMBER_TABLE;
4971: l_responsibility_id_tbl JTF_NUMBER_TABLE;
4972: l_partner_ids_tbl JTF_NUMBER_TABLE;
4973:

Line 4970: business_user_ids_tbl JTF_NUMBER_TABLE;

4966:
4967: l_api_name CONSTANT VARCHAR2(30) := 'revoke_user_resps';
4968: l_api_version_number CONSTANT NUMBER := 1.0;
4969: primary_user_ids_tbl JTF_NUMBER_TABLE;
4970: business_user_ids_tbl JTF_NUMBER_TABLE;
4971: l_responsibility_id_tbl JTF_NUMBER_TABLE;
4972: l_partner_ids_tbl JTF_NUMBER_TABLE;
4973:
4974: BEGIN

Line 4971: l_responsibility_id_tbl JTF_NUMBER_TABLE;

4967: l_api_name CONSTANT VARCHAR2(30) := 'revoke_user_resps';
4968: l_api_version_number CONSTANT NUMBER := 1.0;
4969: primary_user_ids_tbl JTF_NUMBER_TABLE;
4970: business_user_ids_tbl JTF_NUMBER_TABLE;
4971: l_responsibility_id_tbl JTF_NUMBER_TABLE;
4972: l_partner_ids_tbl JTF_NUMBER_TABLE;
4973:
4974: BEGIN
4975: ---- Initialize----------------

Line 4972: l_partner_ids_tbl JTF_NUMBER_TABLE;

4968: l_api_version_number CONSTANT NUMBER := 1.0;
4969: primary_user_ids_tbl JTF_NUMBER_TABLE;
4970: business_user_ids_tbl JTF_NUMBER_TABLE;
4971: l_responsibility_id_tbl JTF_NUMBER_TABLE;
4972: l_partner_ids_tbl JTF_NUMBER_TABLE;
4973:
4974: BEGIN
4975: ---- Initialize----------------
4976:

Line 5257: l_user_ids_tbl JTF_NUMBER_TABLE;

5253: AND membership_status_code = 'ACTIVE';
5254:
5255: l_api_name CONSTANT VARCHAR2(30) := 'manage_store_resp_on_create';
5256: l_api_version_number CONSTANT NUMBER := 1.0;
5257: l_user_ids_tbl JTF_NUMBER_TABLE;
5258: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
5259: l_ptnr_resp_id NUMBER;
5260: l_exist NUMBER;
5261: BEGIN

Line 5750: l_partner_ids_tbl JTF_NUMBER_TABLE;

5746: l_api_name CONSTANT VARCHAR2(30) := 'assign_default_resp';
5747: l_api_version_number CONSTANT NUMBER := 1.0;
5748: l_responsibility_id NUMBER;
5749: l_resp_map_rule_id NUMBER;
5750: l_partner_ids_tbl JTF_NUMBER_TABLE;
5751: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
5752: l_ptnr_resp_id NUMBER;
5753:
5754: BEGIN

Line 6013: primary_user_ids_tbl JTF_NUMBER_TABLE;

6009: AND resp_type_code = G_PROGRAM;
6010:
6011: l_api_name CONSTANT VARCHAR2(30) := 'manage_resp_on_address_change';
6012: l_api_version_number CONSTANT NUMBER := 1.0;
6013: primary_user_ids_tbl JTF_NUMBER_TABLE;
6014: business_user_ids_tbl JTF_NUMBER_TABLE;
6015: l_responsibility_id NUMBER;
6016: l_resp_map_rule_id NUMBER;
6017: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;

Line 6014: business_user_ids_tbl JTF_NUMBER_TABLE;

6010:
6011: l_api_name CONSTANT VARCHAR2(30) := 'manage_resp_on_address_change';
6012: l_api_version_number CONSTANT NUMBER := 1.0;
6013: primary_user_ids_tbl JTF_NUMBER_TABLE;
6014: business_user_ids_tbl JTF_NUMBER_TABLE;
6015: l_responsibility_id NUMBER;
6016: l_resp_map_rule_id NUMBER;
6017: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;
6018: l_ptnr_resp_id NUMBER;

Line 6389: primary_user_ids_tbl JTF_NUMBER_TABLE;

6385: AND resp_type_code = G_PROGRAM;
6386:
6387: l_api_name CONSTANT VARCHAR2(30) := 'revoke_default_resp';
6388: l_api_version_number CONSTANT NUMBER := 1.0;
6389: primary_user_ids_tbl JTF_NUMBER_TABLE;
6390: business_user_ids_tbl JTF_NUMBER_TABLE;
6391:
6392: BEGIN
6393: ---- Initialize----------------

Line 6390: business_user_ids_tbl JTF_NUMBER_TABLE;

6386:
6387: l_api_name CONSTANT VARCHAR2(30) := 'revoke_default_resp';
6388: l_api_version_number CONSTANT NUMBER := 1.0;
6389: primary_user_ids_tbl JTF_NUMBER_TABLE;
6390: business_user_ids_tbl JTF_NUMBER_TABLE;
6391:
6392: BEGIN
6393: ---- Initialize----------------
6394:

Line 7111: l_user_ids_tbl JTF_NUMBER_TABLE;

7107: l_api_name CONSTANT VARCHAR2(30) := 'manage_merged_party_memb_resp';
7108: l_api_version_number CONSTANT NUMBER := 1.0;
7109: l_exist NUMBER;
7110: l_last_program_id NUMBER := 0;
7111: l_user_ids_tbl JTF_NUMBER_TABLE;
7112: l_resp_exist VARCHAR(1) := 'N';
7113: l_responsibility_id NUMBER;
7114: l_resp_map_rule_id NUMBER;
7115: l_ge_ptnr_resps_rec PV_Ge_Ptnr_Resps_PVT.ge_ptnr_resps_rec_type;