APPS.FND_GRANTS_PKG dependencies on FND_GLOBAL

Line 1076: l_user_id number:=fnd_global.user_id;

1072: -- to change i.e. for eg. X.6 to X.7.
1073: l_api_version CONSTANT NUMBER := 1.0;
1074: l_menu_id fnd_grants.menu_id%TYPE;
1075: l_sys_date DATE := Sysdate;
1076: l_user_id number:=fnd_global.user_id;
1077: l_grant_guid raw(16);
1078: l_row_id varchar2(18) ;
1079: l_object_id number;
1080: l_grantee_key varchar2(240);

Line 1565: where_clause := fnd_global.newline||'WHERE 1=1 ';

1561: -- bug3625804 initialize the delete and select statement
1562:
1563: del_sql_stmt := 'DELETE FROM FND_GRANTS';
1564: sel_sql_stmt := 'SELECT GRANT_GUID FROM FND_GRANTS';
1565: where_clause := fnd_global.newline||'WHERE 1=1 ';
1566:
1567: grantee_stmt := fnd_global.newline||'AND grantee_type = '''||
1568: replace(p_grantee_type, '''', '''''')||''' AND grantee_key = '''||
1569: replace(p_grantee_key, '''', '''''')||'''';

Line 1567: grantee_stmt := fnd_global.newline||'AND grantee_type = '''||

1563: del_sql_stmt := 'DELETE FROM FND_GRANTS';
1564: sel_sql_stmt := 'SELECT GRANT_GUID FROM FND_GRANTS';
1565: where_clause := fnd_global.newline||'WHERE 1=1 ';
1566:
1567: grantee_stmt := fnd_global.newline||'AND grantee_type = '''||
1568: replace(p_grantee_type, '''', '''''')||''' AND grantee_key = '''||
1569: replace(p_grantee_key, '''', '''''')||'''';
1570:
1571: IF(p_object_name is NOT NULL ) THEN

Line 1591: object_stmt := fnd_global.newline||'AND object_id = '||l_object_id||' AND instance_type = '''||replace(p_instance_type, '''', '''''')||'''';

1587: return;
1588: END IF;
1589: CLOSE get_object_id; -- bug5122727 moved to inside of if block
1590: end if;
1591: object_stmt := fnd_global.newline||'AND object_id = '||l_object_id||' AND instance_type = '''||replace(p_instance_type, '''', '''''')||'''';
1592:
1593: IF(p_instance_type = 'SET') THEN
1594: IF(p_instance_set_id IS NOT NULL) THEN
1595: object_stmt := object_stmt||

Line 1641: menu_stmt := fnd_global.newline||'AND menu_id = '||l_menu_id;

1637: x_errcode := 1;
1638: return;
1639: END IF;
1640: CLOSE get_menu_id;
1641: menu_stmt := fnd_global.newline||'AND menu_id = '||l_menu_id;
1642: END IF;
1643:
1644: program_stmt := fnd_global.newline||'AND program_name = '''||replace(p_program_name, '''', '''''')||'''';
1645:

Line 1644: program_stmt := fnd_global.newline||'AND program_name = '''||replace(p_program_name, '''', '''''')||'''';

1640: CLOSE get_menu_id;
1641: menu_stmt := fnd_global.newline||'AND menu_id = '||l_menu_id;
1642: END IF;
1643:
1644: program_stmt := fnd_global.newline||'AND program_name = '''||replace(p_program_name, '''', '''''')||'''';
1645:
1646: IF(p_program_tag IS NOT NULL ) THEN
1647: program_stmt := program_stmt||' AND program_tag = '''||
1648: replace(p_program_tag, '''', '''''')||'''';