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_ITEM_PEOPLE_IMPORT_PKG dependencies on FND_GRANTS

Line 97: -- TYPE g_t_grant_guid_table IS TABLE OF fnd_grants.grant_guid%TYPE INDEX BY BINARY_INTEGER;

93:
94: -- =================================================================
95: -- Global variables used for Bulk Processing
96: -- =================================================================
97: -- TYPE g_t_grant_guid_table IS TABLE OF fnd_grants.grant_guid%TYPE INDEX BY BINARY_INTEGER;
98: --
99: -- TYPE g_t_transaction_id_table IS TABLE OF ego_item_people_intf.transaction_id%TYPE INDEX BY BINARY_INTEGER;
100: -- TYPE g_t_start_date_table IS TABLE OF ego_item_people_intf.start_date%TYPE INDEX BY BINARY_INTEGER;
101: -- TYPE g_t_end_date_table IS TABLE OF ego_item_people_intf.end_date%TYPE INDEX BY BINARY_INTEGER;

Line 613: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, mtl_system_items out_msib ';

609: -- Bug 13637215 BINDING Start
610: --First query for User privilege
611: l_select_sql :=
612: ' SELECT OUT_MSIB.INVENTORY_ITEM_ID, OUT_MSIB.ORGANIZATION_ID, ' || G_REQUEST_ID ||
613: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf, mtl_system_items out_msib ';
614:
615: l_user_name := 'HZ_PARTY:'||TO_CHAR(p_login_person_id);
616: get_orig_key( x_user_name => l_user_name
617: , x_orig_system_id => l_orig_system_id);

Line 650: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||

646: ' FROM MTL_SYSTEM_ITEMS_B, ego_item_cat_denorm_hier cathier ' ||
647: ' WHERE item_catalog_group_id = cathier.child_catalog_group_id ';
648:
649: l_dynamic_sql_1 := ' SELECT DISTINCT instance_sets.predicate ' ||
650: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
651: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
652: ' WHERE grants.instance_type = ''SET'' ' ||
653: ' AND grants.start_date <= SYSDATE ' ||
654: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 886: -- and updates fnd_grants if required

882: -- TYPE : PRIVATE
883: -- Pre-reqs : NONE
884: --
885: -- FUNCTION : To check if the required grant can be updated
886: -- and updates fnd_grants if required
887: -- NO ACTION IS PERFORMED ON ego_item_people_intf
888: --
889: -- Parameters:
890: -- IN : NONE

Line 911: FROM fnd_grants grants

907: ,cp_global_party_id_char IN VARCHAR2
908: ,cp_start_date IN DATE
909: ) IS
910: SELECT grant_guid
911: FROM fnd_grants grants
912: WHERE grants.object_id = G_FND_OBJECT_ID
913: AND grants.menu_id = cp_menu_id
914: AND grants.instance_type = 'INSTANCE'
915: AND grants.instance_pk1_value = TO_CHAR(cp_inv_item_id)

Line 938: FROM fnd_grants grants

934: ,cp_start_date IN DATE
935: ,cp_end_date IN DATE
936: ) IS
937: SELECT grant_guid
938: FROM fnd_grants grants
939: WHERE grants.grant_guid <> cp_grant_guid
940: AND grants.object_id = cp_object_id
941: AND grants.menu_id = cp_menu_id
942: AND grants.instance_type = 'INSTANCE'

Line 955: l_grant_guid fnd_grants.grant_guid%TYPE;

951: AND NVL(end_date,cp_start_date) >= cp_start_date;
952:
953: l_token_tbl_two Error_Handler.Token_Tbl_Type;
954: l_token_tbl_one Error_Handler.Token_Tbl_Type;
955: l_grant_guid fnd_grants.grant_guid%TYPE;
956: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
957:
958: l_success VARCHAR2(999);
959: l_item_number VARCHAR2(100);

Line 956: l_temp_grant_guid fnd_grants.grant_guid%TYPE;

952:
953: l_token_tbl_two Error_Handler.Token_Tbl_Type;
954: l_token_tbl_one Error_Handler.Token_Tbl_Type;
955: l_grant_guid fnd_grants.grant_guid%TYPE;
956: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
957:
958: l_success VARCHAR2(999);
959: l_item_number VARCHAR2(100);
960:

Line 1019: FND_GRANTS_PKG.Update_Grant

1015: );
1016: END IF;
1017: ELSE
1018: -- update the grants
1019: FND_GRANTS_PKG.Update_Grant
1020: (p_api_version => 1.0
1021: ,p_grant_guid => l_grant_guid
1022: ,p_start_date => p_start_date
1023: ,p_end_date => p_end_date

Line 1097: -- and inserts the record into fnd_grants if valid

1093: -- TYPE : PRIVATE
1094: -- Pre-reqs : NONE
1095: --
1096: -- FUNCTION : To check if the required grant is valid for insert
1097: -- and inserts the record into fnd_grants if valid
1098: -- NO ACTION IS PERFORMED ON ego_item_people_intf
1099: --
1100: -- Parameters:
1101: -- IN : NONE

Line 1123: FROM fnd_grants grants

1119: ,cp_start_date IN DATE
1120: ,cp_end_date IN DATE
1121: ) IS
1122: SELECT grant_guid
1123: FROM fnd_grants grants
1124: WHERE grants.object_id = cp_object_id
1125: AND grants.menu_id = cp_menu_id
1126: AND grants.instance_type = 'INSTANCE'
1127: AND grants.instance_pk1_value = TO_CHAR(cp_inv_item_id)

Line 1139: l_grant_guid fnd_grants.grant_guid%TYPE;

1135: AND NVL(end_date,cp_start_date) >= cp_start_date;
1136:
1137:
1138: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1139: l_grant_guid fnd_grants.grant_guid%TYPE;
1140: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
1141:
1142: l_success VARCHAR2(999);
1143: l_errorcode NUMBER;

Line 1140: l_temp_grant_guid fnd_grants.grant_guid%TYPE;

1136:
1137:
1138: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1139: l_grant_guid fnd_grants.grant_guid%TYPE;
1140: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
1141:
1142: l_success VARCHAR2(999);
1143: l_errorcode NUMBER;
1144:

Line 1182: -- insert record into fnd_grants

1178: );
1179: END IF;
1180: ELSE
1181: --
1182: -- insert record into fnd_grants
1183: --
1184: FND_GRANTS_PKG.Grant_Function
1185: (p_api_version => 1.0
1186: ,p_menu_name => p_internal_role_name

Line 1184: FND_GRANTS_PKG.Grant_Function

1180: ELSE
1181: --
1182: -- insert record into fnd_grants
1183: --
1184: FND_GRANTS_PKG.Grant_Function
1185: (p_api_version => 1.0
1186: ,p_menu_name => p_internal_role_name
1187: ,p_object_name => G_FND_OBJECT_NAME
1188: ,p_instance_type => 'INSTANCE'

Line 1255: -- All Users is now represented by grantee_key = 'GLOBAL' in fnd_grants

1251: DECODE(grantee_type, 'USER', 'HZ_PARTY:'||TO_CHAR(grantee_party_id),
1252: 'GROUP','HZ_GROUP:'||TO_CHAR(grantee_party_id),
1253: 'COMPANY','HZ_COMPANY:'||TO_CHAR(grantee_party_id),
1254: -- bug: 3460466
1255: -- All Users is now represented by grantee_key = 'GLOBAL' in fnd_grants
1256: -- 'GLOBAL','HZ_GLOBAL:'||TO_CHAR(grantee_party_id),
1257: 'GLOBAL',grantee_type,
1258: TO_CHAR(grantee_party_id)) grantee_key,
1259: DECODE(transaction_type, 'CREATE', ORDER_BY_CREATE,

Line 1283: FROM fnd_grants grants

1279: ,cp_start_date IN DATE
1280: ,cp_end_date IN DATE
1281: ) IS
1282: SELECT grant_guid
1283: FROM fnd_grants grants
1284: WHERE grants.object_id = G_FND_OBJECT_ID
1285: AND grants.menu_id = cp_menu_id
1286: AND grants.instance_type = 'INSTANCE'
1287: AND grants.instance_pk1_value = TO_CHAR(cp_inv_item_id)

Line 1313: l_grant_guid fnd_grants.grant_guid%TYPE;

1309: l_group_party_id_char VARCHAR2(100);
1310: l_company_party_id_char VARCHAR2(100);
1311: l_global_party_id_char VARCHAR2(100);
1312:
1313: l_grant_guid fnd_grants.grant_guid%TYPE;
1314: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
1315: l_grant_guid_count NUMBER := 0;
1316:
1317: l_ipi_lines_count NUMBER := 0;

Line 1314: l_temp_grant_guid fnd_grants.grant_guid%TYPE;

1310: l_company_party_id_char VARCHAR2(100);
1311: l_global_party_id_char VARCHAR2(100);
1312:
1313: l_grant_guid fnd_grants.grant_guid%TYPE;
1314: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
1315: l_grant_guid_count NUMBER := 0;
1316:
1317: l_ipi_lines_count NUMBER := 0;
1318: l_record_count NUMBER := 0;

Line 1358: -- All Users is now represented by grantee_key = 'GLOBAL' in fnd_grants

1354: l_user_party_id_char := NULL;
1355: l_group_party_id_char := NULL;
1356: l_company_party_id_char:= NULL;
1357: -- bug: 3460466
1358: -- All Users is now represented by grantee_key = 'GLOBAL' in fnd_grants
1359: -- l_global_party_id_char := 'HZ_GLOBAL:'||TO_CHAR(cr.grantee_party_id);
1360: l_global_party_id_char := cr.grantee_type;
1361: ELSE
1362: l_user_party_id_char := NULL;

Line 1385: FND_GRANTS_PKG.Revoke_Grant

1381: ,cp_end_date => cr.end_date);
1382: FETCH c_get_delete_grantid INTO l_grant_guid;
1383:
1384: IF c_get_delete_grantid%FOUND THEN
1385: FND_GRANTS_PKG.Revoke_Grant
1386: (p_api_version => 1.0
1387: ,p_grant_guid => l_grant_guid
1388: ,x_success => l_success
1389: ,x_errorcode => l_return_status

Line 1649: -- FUNCTION : Process and Load interfance lines into FND_GRANTS.

1645: -- Start OF comments
1646: -- API name : Load Interfance Lines
1647: -- TYPE : Public (called by SQL Loader)
1648: -- Pre-reqs : None
1649: -- FUNCTION : Process and Load interfance lines into FND_GRANTS.
1650: -- Errors are populated in MTL_INTERFACE_ERRORS
1651: BEGIN
1652: IF G_CURR_DATASET_ID = -1 THEN
1653: SELECT EGO_IPI_DATASET_ID_S.NEXTVAL

Line 1683: -- FUNCTION : Process and Load interfance lines into FND_GRANTS.

1679: -- Start OF comments
1680: -- API name : Load Interfance Lines
1681: -- TYPE : Public (called by Concurrent Program)
1682: -- Pre-reqs : None
1683: -- FUNCTION : Process and Load interfance lines into FND_GRANTS.
1684: -- Errors are populated in MTL_INTERFACE_ERRORS
1685:
1686: -- ======================================================================
1687: -- the record types used from other procedures

Line 2854: ' SELECT /+ no_unnest index(grants FND_GRANTS_N5) / ''X'' ' || --Bug 13637215 add hint

2850: || ' AND eipi.inventory_item_id IS NOT NULL '
2851: || ' AND NOT EXISTS ( ';
2852:
2853: l_select_sql :=
2854: ' SELECT /*+ no_unnest index(grants FND_GRANTS_N5) */ ''X'' ' || --Bug 13637215 add hint
2855: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
2856: ' WHERE grants.instance_pk1_value = to_char(eipi.INVENTORY_ITEM_ID) ' ||
2857: ' AND grants.instance_pk2_value = to_char(eipi.ORGANIZATION_ID) ' ||
2858: ' AND grants.start_date <= sysdate ' ||

Line 2855: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||

2851: || ' AND NOT EXISTS ( ';
2852:
2853: l_select_sql :=
2854: ' SELECT /*+ no_unnest index(grants FND_GRANTS_N5) */ ''X'' ' || --Bug 13637215 add hint
2855: ' FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries cmf ' ||
2856: ' WHERE grants.instance_pk1_value = to_char(eipi.INVENTORY_ITEM_ID) ' ||
2857: ' AND grants.instance_pk2_value = to_char(eipi.ORGANIZATION_ID) ' ||
2858: ' AND grants.start_date <= sysdate ' ||
2859: ' AND (grants.end_date IS NULL OR grants.end_date >= sysdate) ' ||

Line 2882: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||

2878: ' AND msi.organization_id = eipi.organization_id' ||
2879: ' AND msi.item_catalog_group_id = cathier.child_catalog_group_id ';
2880:
2881: l_dynamic_sql_1 := ' SELECT DISTINCT instance_sets.predicate ' ||
2882: ' FROM fnd_grants grants, fnd_form_functions functions, ' ||
2883: ' fnd_menu_entries cmf, fnd_object_instance_sets instance_sets ' ||
2884: ' WHERE grants.instance_type = ''SET'' ' ||
2885: ' AND grants.start_date <= SYSDATE ' ||
2886: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||

Line 2997: -- upload the data into fnd_grants

2993: END LOOP; -- l_count_ipi_records
2994:
2995: Write_Debug('Checking for Grant Overlap on the items');
2996: --
2997: -- upload the data into fnd_grants
2998: --
2999: validate_no_grant_overlap(x_retcode => x_retcode);
3000: check_and_write_log(p_msg_size => 0
3001: ,x_retcode => x_retcode);