APPS.FII_CCC_SEC_UPL_PKG dependencies on FND_GRANTS

Line 128: -- Validate Data in FII_CCC_SEC_INTERFACE before uploading into FND_GRANTS

124:
125:
126:
127: --------------------------------------------------------------------------
128: -- Validate Data in FII_CCC_SEC_INTERFACE before uploading into FND_GRANTS
129: --------------------------------------------------------------------------
130: PROCEDURE Validate (retcode IN OUT NOCOPY VARCHAR2) IS
131:
132: l_violations_found BOOLEAN := FALSE;

Line 283: -- Upload Data into FND_GRANTS

279:
280: END validate;
281:
282: -------------------------------------------------------------------
283: -- Upload Data into FND_GRANTS
284: -------------------------------------------------------------------
285: PROCEDURE upload (retcode IN OUT NOCOPY VARCHAR2) IS
286:
287:

Line 299: FROM fnd_grants g,

295:
296:
297: CURSOR get_grant_guid_csr IS
298: SELECT g.grant_guid --, g.grantee_key, g.menu_id, int.menu_name
299: FROM fnd_grants g,
300: fnd_menus m,
301: (
302: SELECT distinct grantee_key, menu_name
303: FROM fii_ccc_sec_interface

Line 330: fnd_grants_pkg.revoke_grant

326: dbg('upload: delete any existing grant for the grant to / role pair');
327:
328: FOR get_grant_guid_rec IN get_grant_guid_csr LOOP
329:
330: fnd_grants_pkg.revoke_grant
331: (
332: p_api_version => 1.0,
333: p_grant_guid => get_grant_guid_rec.grant_guid,
334: x_success => x_success,

Line 349: -- Upload Data into FND_GRANTS

345: END LOOP;
346:
347:
348: --
349: -- Upload Data into FND_GRANTS
350: --
351: dbg('upload: upload data into fnd_grants');
352: FOR c1_rec IN c1_csr LOOP
353:

Line 351: dbg('upload: upload data into fnd_grants');

347:
348: --
349: -- Upload Data into FND_GRANTS
350: --
351: dbg('upload: upload data into fnd_grants');
352: FOR c1_rec IN c1_csr LOOP
353:
354: dbg('upload: grantee_key=' || c1_rec.grantee_key
355: || ' menu_name=' || c1_rec.menu_name

Line 361: fnd_grants_pkg.grant_function

357: || ' end_date=' || c1_rec.end_date
358: || ' dimension_code=' || c1_rec.dimension_code
359: || ' dimension_id=' || c1_rec.dimension_id);
360:
361: fnd_grants_pkg.grant_function
362: (
363: p_api_version => 1.0,
364: p_menu_name => c1_rec.menu_name,
365: p_object_name => 'HRI_PER',

Line 401: dbg('upload: record created in fnd_grants. grant_guid = '||to_char(x_grant_guid));

397: -- p_description IN VARCHAR2 default null
398: );
399:
400: IF x_success = FND_API.G_TRUE THEN
401: dbg('upload: record created in fnd_grants. grant_guid = '||to_char(x_grant_guid));
402: ELSE
403: dbg('upload: record creation failed');
404: retcode := 'E';
405: RETURN;

Line 432: -- to fnd_grants

428: END upload;
429:
430: ----------------------------------------------------------------------
431: -- Upload Company Cost Center Security Data from interface table
432: -- to fnd_grants
433: -- Called by concurrent program "Upload Company Cost Center Security"
434: --
435: -- CP: FII_CCC_SEC_UPLOAD_C (Upload Company Cost Center Security)
436: -- Executable: FII_CCC_SEC_UPLOAD_C

Line 500: -- upload into fnd_grants

496: RETURN;
497: END IF;
498:
499: --
500: -- upload into fnd_grants
501: --
502: dbg('conc_upload: Upload data in interface table into fnd_grants. Calling upload procedure...');
503:
504: upload(retcode);

Line 502: dbg('conc_upload: Upload data in interface table into fnd_grants. Calling upload procedure...');

498:
499: --
500: -- upload into fnd_grants
501: --
502: dbg('conc_upload: Upload data in interface table into fnd_grants. Calling upload procedure...');
503:
504: upload(retcode);
505:
506: IF retcode <> 'S' THEN

Line 509: dbg('conc_upload: Upload to fnd_grants process failed. Exit.');

505:
506: IF retcode <> 'S' THEN
507: errbuf := fnd_message.get_string('FII', 'FII_CCC_SEC_CP_UPLOAD_ERR');
508: l_ret_status := FND_CONCURRENT.Set_Completion_Status(status => 'ERROR',message => errbuf);
509: dbg('conc_upload: Upload to fnd_grants process failed. Exit.');
510: -- debug msg time stamp of exiting this procedure
511: IF g_debug_flag = 'Y' THEN
512: FII_MESSAGE.Func_Succ('FII_CCC_SEC_UPL_PKG.conc_upload');
513: END IF;