[Home] [Help]
585:
586: IF (ctx_type = 'BG') THEN
587: BEGIN
588: SELECT name INTO v_ctxt_name
589: FROM per_business_groups
590: WHERE date_from < SYSDATE
591: AND (date_to IS NULL
592: OR date_to > SYSDATE)
593: AND organization_id = ctx_id;
596: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
597: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
598: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
599: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
600: fnd_message.set_token('AZW_ERROR_STMT','select name from per_business_groups');
601: APP_EXCEPTION.RAISE_EXCEPTION;
602: END;
603:
604: ELSIF (ctx_type = 'IO') THEN
856:
857: i BINARY_INTEGER DEFAULT 0;
858: CURSOR bg_cursor IS
859: SELECT organization_id, name
860: FROM per_business_groups
861: WHERE date_from < SYSDATE
862: AND (date_to IS NULL
863: OR date_to > SYSDATE)
864: ORDER BY organization_id;
1321:
1322: CURSOR invalid_bg_processes_cursor IS
1323: SELECT ap.item_type, ap.process_name, ap.context_id
1324: FROM az_processes ap,
1325: per_business_groups pbg
1326: WHERE ap.context_type = 'BG'
1327: AND ap.process_type = g_current_mode
1328: AND ap.context_id > -1
1329: AND ap.context_id = pbg.organization_id
1364: DELETE from az_processes
1365: WHERE context_type = 'BG'
1366: AND context_id not in
1367: ( select distinct organization_id
1368: from per_business_groups);
1369: -- get rid of non-existent IO processes from az_processes
1370: DELETE from az_processes
1371: WHERE context_type = 'IO'
1372: AND context_id not in