APPS.FII_CCC_SEC_UPL_PKG dependencies on FII_CCC_SEC_INTERFACE

Line 90: INSERT INTO fii_ccc_sec_interface

86: return l_err_msg;
87: END IF;
88: END IF;
89:
90: INSERT INTO fii_ccc_sec_interface
91: (grantee_key,
92: menu_name,
93: start_date,
94: end_date,

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 151: FROM fii_ccc_sec_interface

147: SELECT grantee_key, menu_name, count(*)
148: FROM
149: (
150: SELECT distinct grantee_key, menu_name, start_date, end_date
151: FROM fii_ccc_sec_interface
152: WHERE status_code IS NULL
153: ) a
154: GROUP BY grantee_key, menu_name
155: HAVING COUNT(*) > 1;

Line 159: FROM fii_ccc_sec_interface

155: HAVING COUNT(*) > 1;
156:
157: CURSOR get_sd_ed_csr(p_grantee_key VARCHAR2, p_menu_name VARCHAR2) IS
158: SELECT distinct start_date, end_date
159: FROM fii_ccc_sec_interface
160: WHERE status_code IS NULL
161: AND grantee_key = p_grantee_key
162: AND menu_name = p_menu_name;
163:

Line 236: UPDATE fii_ccc_sec_interface

232: END LOOP;
233:
234:
235: --Update the Status_Code
236: UPDATE fii_ccc_sec_interface
237: SET status_code = 'ERR - DIFFERENT DATES',
238: last_update_date = g_sys_date,
239: last_updated_by = g_user_id,
240: last_update_login = g_user_id

Line 265: UPDATE fii_ccc_sec_interface

261: -- to VALIDATED to avoid being picked up in the next run.
262: --------------------------------------------------------------
263: dbg('validate: validation 1 - failed');
264: dbg('validate: update remaining valid records to VALIDATED');
265: UPDATE fii_ccc_sec_interface
266: SET status_code = 'VALIDATED',
267: last_update_date = g_sys_date,
268: last_updated_by = g_user_id,
269: last_update_login = g_user_id

Line 292: FROM fii_ccc_sec_interface

288: CURSOR c1_csr IS
289: SELECT grantee_key, menu_name,
290: start_date, end_date,
291: dimension_code, dimension_id
292: FROM fii_ccc_sec_interface
293: WHERE status_code IS NULL
294: ORDER BY grantee_key, menu_name, dimension_code;
295:
296:

Line 303: FROM fii_ccc_sec_interface

299: FROM fnd_grants g,
300: fnd_menus m,
301: (
302: SELECT distinct grantee_key, menu_name
303: FROM fii_ccc_sec_interface
304: WHERE status_code IS NULL
305: ) int
306: WHERE int.grantee_key = g.grantee_key
307: AND int.menu_name = m.menu_name

Line 413: UPDATE fii_ccc_sec_interface

409:
410:
411: -- update status_code column in the interface table to 'UPLOADED'
412: dbg('upload: update status_code to UPLOADED in the interface table');
413: UPDATE fii_ccc_sec_interface
414: SET status_code = 'UPLOADED',
415: upload_date = g_sys_date,
416: last_update_date = g_sys_date,
417: last_updated_by = g_user_id,

Line 459: dbg('conc_upload: Check if any data in fii_ccc_sec_interface to process.');

455:
456: --
457: -- check if any data to process, exit if not
458: --
459: dbg('conc_upload: Check if any data in fii_ccc_sec_interface to process.');
460: SELECT count(*) INTO l_record_count
461: FROM fii_ccc_sec_interface
462: WHERE status_code IS null;
463:

Line 461: FROM fii_ccc_sec_interface

457: -- check if any data to process, exit if not
458: --
459: dbg('conc_upload: Check if any data in fii_ccc_sec_interface to process.');
460: SELECT count(*) INTO l_record_count
461: FROM fii_ccc_sec_interface
462: WHERE status_code IS null;
463:
464: IF l_record_count = 0 THEN
465: dbg('conc_upload: No data in the interface table to process. Exit.');

Line 477: -- validate records in fii_ccc_sec_interface table

473: RETURN;
474: END IF;
475:
476: --
477: -- validate records in fii_ccc_sec_interface table
478: --
479: dbg('conc_upload: Validate records in fii_ccc_sec_interface table. Calling validate procedure...');
480:
481: validate(retcode);

Line 479: dbg('conc_upload: Validate records in fii_ccc_sec_interface table. Calling validate procedure...');

475:
476: --
477: -- validate records in fii_ccc_sec_interface table
478: --
479: dbg('conc_upload: Validate records in fii_ccc_sec_interface table. Calling validate procedure...');
480:
481: validate(retcode);
482:
483: IF retcode <> 'S' THEN

Line 535: -- Purge interface table FII_CCC_SEC_INTERFACE

531:
532:
533:
534: --------------------------------------------------------------------------
535: -- Purge interface table FII_CCC_SEC_INTERFACE
536: -- Called by concurrent program
537: -- "Purge Company Cost Center Security Interface Table"
538: --
539: -- CP: FII_CCC_SEC_PURGE_C

Line 563: -- purge fii_ccc_sec_interface table

559: FII_MESSAGE.Func_Ent('FII_CCC_SEC_UPL_PKG.purge_interface');
560: END IF;
561:
562: --
563: -- purge fii_ccc_sec_interface table
564: --
565: dbg('purge_interface: truncate fii_ccc_sec_interface table.');
566: fii_util.truncate_table('FII_CCC_SEC_INTERFACE', 'FII', l_trunc_retcode);
567:

Line 565: dbg('purge_interface: truncate fii_ccc_sec_interface table.');

561:
562: --
563: -- purge fii_ccc_sec_interface table
564: --
565: dbg('purge_interface: truncate fii_ccc_sec_interface table.');
566: fii_util.truncate_table('FII_CCC_SEC_INTERFACE', 'FII', l_trunc_retcode);
567:
568:
569: IF l_trunc_retcode = -1 THEN

Line 566: fii_util.truncate_table('FII_CCC_SEC_INTERFACE', 'FII', l_trunc_retcode);

562: --
563: -- purge fii_ccc_sec_interface table
564: --
565: dbg('purge_interface: truncate fii_ccc_sec_interface table.');
566: fii_util.truncate_table('FII_CCC_SEC_INTERFACE', 'FII', l_trunc_retcode);
567:
568:
569: IF l_trunc_retcode = -1 THEN
570: dbg('purge_interface: purge interface table failed. Exit.');