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.EGO_DATA_SECURITY dependencies on EGO_VARCHAR_TBL_TYPE

Line 225: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE,

221: PROCEDURE getPrivilege_for_profileOption
222: (p_api_version IN NUMBER,
223: p_object_name IN VARCHAR2,
224: p_user_name IN VARCHAR2,
225: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
226: x_return_status OUT NOCOPY VARCHAR2
227: )
228: IS
229: l_role_name VARCHAR2(30);

Line 720: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;

716: l_company_info VARCHAR2(32767); /* Must match g_pred_buf_size*/
717: l_menu_info VARCHAR2(32767); /* Must match g_pred_buf_size*/
718: l_object_id NUMBER;
719: l_user_name VARCHAR2(80);
720: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;
721:
722: candidate_sets_c DYNAMIC_CUR;
723: instance_set DYNAMIC_CUR;
724: l_dynamic_sql_1 VARCHAR2(32767);

Line 1870: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;

1866: l_object_id number;
1867: l_user_name varchar2(80);
1868: -- l_orig_system varchar2(48);
1869: l_orig_system_id NUMBER;
1870: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;
1871:
1872: l_pk2_value VARCHAR2(200);
1873: l_pk3_value VARCHAR2(200);
1874: l_pk4_value VARCHAR2(200);

Line 2520: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE

2516: p_parent_instance_pk3_value IN VARCHAR2 DEFAULT NULL,
2517: p_parent_instance_pk4_value IN VARCHAR2 DEFAULT NULL,
2518: p_parent_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
2519: x_return_status OUT NOCOPY VARCHAR2,
2520: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
2521: )
2522: IS
2523:
2524: l_api_name CONSTANT VARCHAR2(30) := 'GET_INHERITED_FUNCTIONS';

Line 2575: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;

2571: m_privilege_tbl_count NUMBER;
2572: m_privilege_tbl_index NUMBER;
2573: x_index NUMBER;
2574:
2575: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;
2576: l_profile_role VARCHAR2(80);
2577:
2578: instance_set DYNAMIC_CUR;
2579: candidate_sets_c DYNAMIC_CUR;

Line 3289: x_privilege_tbl := EGO_VARCHAR_TBL_TYPE();

3285: end if;
3286:
3287: m_privilege_tbl_count := m_privilege_tbl.COUNT;
3288:
3289: x_privilege_tbl := EGO_VARCHAR_TBL_TYPE();
3290:
3291: x_index := 0;
3292: if (m_privilege_tbl_count > 0) then
3293: x_privilege_tbl.extend(m_privilege_tbl_count);

Line 3392: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;

3388:
3389: instance_set_grants_c DYNAMIC_CUR;
3390: l_dynamic_sql_1 VARCHAR2(32767);
3391: l_set_predicate_segment VARCHAR2(32767);
3392: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;
3393:
3394: BEGIN
3395: SetGlobals();
3396: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE

Line 3898: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;

3894:
3895: instance_set_grants_c DYNAMIC_CUR;
3896: l_dynamic_sql_1 VARCHAR2(32767);
3897: l_one_set_predicate VARCHAR2(32767);
3898: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;
3899:
3900: CURSOR get_user_grantee_key (cp_party_id NUMBER)
3901: IS
3902: --SELECT decode (party_type,'PERSON','HZ_PARTY:'||party_id,'GROUP','HZ_GROUP:'||party_id,'ORGANIZATION','HZ_COMPANY:'||party_id) grantee_key

Line 4383: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;

4379: l_sub_pred_clause varchar2(512);
4380:
4381: l_group_info VARCHAR2(32767); /* Must match g_pred_buf_size*/
4382: l_company_info VARCHAR2(32767); /* Must match g_pred_buf_size*/
4383: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;
4384: l_dynamic_sql VARCHAR2(32767);
4385: instance_set_grants_c DYNAMIC_CUR;
4386: l_set_predicate VARCHAR2(32767);
4387:

Line 4838: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,

4834: p_pk3_alias IN VARCHAR2 DEFAULT NULL,
4835: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
4836: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4837: p_object_type IN VARCHAR2 default null,
4838: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4839: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4840: p_parent_obj_alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4841: x_predicate OUT NOCOPY varchar2,
4842: x_return_status OUT NOCOPY varchar2

Line 4839: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

4835: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
4836: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4837: p_object_type IN VARCHAR2 default null,
4838: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4839: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4840: p_parent_obj_alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4841: x_predicate OUT NOCOPY varchar2,
4842: x_return_status OUT NOCOPY varchar2
4843: )

Line 4840: p_parent_obj_alias_tbl IN EGO_VARCHAR_TBL_TYPE,

4836: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4837: p_object_type IN VARCHAR2 default null,
4838: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4839: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4840: p_parent_obj_alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4841: x_predicate OUT NOCOPY varchar2,
4842: x_return_status OUT NOCOPY varchar2
4843: )
4844: IS

Line 4890: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,

4886: p_pk3_alias IN VARCHAR2 DEFAULT NULL,
4887: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
4888: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4889: p_object_type IN VARCHAR2 default null,
4890: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4891: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4892: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4893: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4894: x_predicate OUT NOCOPY varchar2,

Line 4891: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

4887: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
4888: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4889: p_object_type IN VARCHAR2 default null,
4890: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4891: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4892: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4893: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4894: x_predicate OUT NOCOPY varchar2,
4895: x_return_status OUT NOCOPY varchar2

Line 4892: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,

4888: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4889: p_object_type IN VARCHAR2 default null,
4890: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4891: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4892: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4893: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4894: x_predicate OUT NOCOPY varchar2,
4895: x_return_status OUT NOCOPY varchar2
4896: ) IS

Line 4893: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,

4889: p_object_type IN VARCHAR2 default null,
4890: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4891: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4892: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4893: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4894: x_predicate OUT NOCOPY varchar2,
4895: x_return_status OUT NOCOPY varchar2
4896: ) IS
4897: l_clob_predicate CLOB;

Line 4943: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,

4939: p_pk3_alias IN VARCHAR2 DEFAULT NULL,
4940: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
4941: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4942: p_object_type IN VARCHAR2 default null,
4943: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4944: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4945: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4946: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4947: x_predicate OUT NOCOPY varchar2,

Line 4944: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

4940: p_pk4_alias IN VARCHAR2 DEFAULT NULL,
4941: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4942: p_object_type IN VARCHAR2 default null,
4943: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4944: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4945: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4946: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4947: x_predicate OUT NOCOPY varchar2,
4948: x_clob_predicate OUT NOCOPY CLOB, --gnanda:Added for Bug 4756970.

Line 4945: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,

4941: p_pk5_alias IN VARCHAR2 DEFAULT NULL,
4942: p_object_type IN VARCHAR2 default null,
4943: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4944: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4945: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4946: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4947: x_predicate OUT NOCOPY varchar2,
4948: x_clob_predicate OUT NOCOPY CLOB, --gnanda:Added for Bug 4756970.
4949: x_return_status OUT NOCOPY varchar2

Line 4946: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,

4942: p_object_type IN VARCHAR2 default null,
4943: p_parent_object_tbl IN EGO_VARCHAR_TBL_TYPE,
4944: p_relationship_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
4945: p_parent_obj_pk1alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4946: p_parent_obj_pk2alias_tbl IN EGO_VARCHAR_TBL_TYPE,
4947: x_predicate OUT NOCOPY varchar2,
4948: x_clob_predicate OUT NOCOPY CLOB, --gnanda:Added for Bug 4756970.
4949: x_return_status OUT NOCOPY varchar2
4950: ) IS

Line 5000: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;

4996: parent_instance_set_grants_c DYNAMIC_CUR;
4997: l_dynamic_sql_2 VARCHAR2(32767);
4998:
4999: l_profile_optionFound BOOLEAN DEFAULT FALSE;
5000: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;
5001:
5002: l_parent_object_name VARCHAR2(100);
5003:
5004: CURSOR parent_instance_set_grants_c2 (

Line 6958: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE

6954: (
6955: p_api_version IN NUMBER,
6956: p_role_name IN VARCHAR2,
6957: x_return_status OUT NOCOPY VARCHAR2,
6958: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
6959: )
6960: IS
6961:
6962: l_api_name CONSTANT VARCHAR2(30) := 'GET_ROLE_FUNCTIONS';

Line 6995: x_privilege_tbl := EGO_VARCHAR_TBL_TYPE();

6991: ' - p_role_name: '||p_role_name
6992: );
6993: x_return_status := G_RETURN_SUCCESS; /* Assume Success */
6994:
6995: x_privilege_tbl := EGO_VARCHAR_TBL_TYPE();
6996:
6997: l_index := 0;
6998:
6999: FOR privileges_rec IN role_function_c (p_role_name)

Line 7044: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,

7040: p_instance_pk4_value IN VARCHAR2 DEFAULT NULL,
7041: p_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
7042: p_user_name IN VARCHAR2 DEFAULT NULL,
7043: p_object_type IN VARCHAR2 DEFAULT NULL,
7044: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
7045: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
7046: x_return_status OUT NOCOPY VARCHAR2,
7047: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
7048: )

Line 7045: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

7041: p_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
7042: p_user_name IN VARCHAR2 DEFAULT NULL,
7043: p_object_type IN VARCHAR2 DEFAULT NULL,
7044: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
7045: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
7046: x_return_status OUT NOCOPY VARCHAR2,
7047: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
7048: )
7049: IS

Line 7047: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE

7043: p_object_type IN VARCHAR2 DEFAULT NULL,
7044: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
7045: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
7046: x_return_status OUT NOCOPY VARCHAR2,
7047: x_privilege_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
7048: )
7049: IS
7050:
7051: l_api_name CONSTANT VARCHAR2(30) := 'GET_INHERITED_FUNCTIONS';

Line 7097: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;

7093: m_privilege_tbl_count NUMBER;
7094: m_privilege_tbl_index NUMBER;
7095: x_index NUMBER;
7096:
7097: l_prof_privilege_tbl EGO_VARCHAR_TBL_TYPE;
7098: l_profile_role VARCHAR2(80);
7099:
7100: l_parent_object_count NUMBER; /** ADDING A VARIABLE FOR COUNT ***/
7101:

Line 7621: x_privilege_tbl := EGO_VARCHAR_TBL_TYPE();

7617: l_index:=l_index+1;
7618: END LOOP;
7619: END IF;
7620: m_privilege_tbl_count := m_privilege_tbl.COUNT;
7621: x_privilege_tbl := EGO_VARCHAR_TBL_TYPE();
7622: x_index := 0;
7623: if (m_privilege_tbl_count > 0) then
7624: x_privilege_tbl.extend(m_privilege_tbl_count);
7625: FOR i IN m_privilege_tbl.first .. m_privilege_tbl.last LOOP

Line 7678: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,

7674: p_instance_pk2_value IN VARCHAR2 DEFAULT NULL,
7675: p_instance_pk3_value IN VARCHAR2 DEFAULT NULL,
7676: p_instance_pk4_value IN VARCHAR2 DEFAULT NULL,
7677: p_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
7678: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
7679: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
7680: p_user_name IN VARCHAR2 DEFAULT NULL,
7681: p_object_type IN VARCHAR2 DEFAULT NULL
7682: )

Line 7679: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,

7675: p_instance_pk3_value IN VARCHAR2 DEFAULT NULL,
7676: p_instance_pk4_value IN VARCHAR2 DEFAULT NULL,
7677: p_instance_pk5_value IN VARCHAR2 DEFAULT NULL,
7678: p_parent_object_name_tbl IN EGO_VARCHAR_TBL_TYPE,
7679: p_parent_object_sql_tbl IN EGO_VARCHAR_TBL_TYPE,
7680: p_user_name IN VARCHAR2 DEFAULT NULL,
7681: p_object_type IN VARCHAR2 DEFAULT NULL
7682: )
7683: RETURN VARCHAR2 IS