APPS.AZW_PROC dependencies on ORG_ACCESS_VIEW

Line 2342: org_code org_access_view.organization_code%TYPE DEFAULT NULL;

2338: p_name az_processes.process_name%TYPE;
2339: ctx_id az_processes.context_id%TYPE;
2340: ctx_type az_processes.context_type%TYPE;
2341: ctx_name az_processes.context_name%TYPE;
2342: org_code org_access_view.organization_code%TYPE DEFAULT NULL;
2343: coa_id org_access_view.chart_of_accounts_id%TYPE DEFAULT NULL;
2344: p_role wf_roles.name%TYPE;
2345: msg az_webform_messages.mesg%TYPE;
2346:

Line 2343: coa_id org_access_view.chart_of_accounts_id%TYPE DEFAULT NULL;

2339: ctx_id az_processes.context_id%TYPE;
2340: ctx_type az_processes.context_type%TYPE;
2341: ctx_name az_processes.context_name%TYPE;
2342: org_code org_access_view.organization_code%TYPE DEFAULT NULL;
2343: coa_id org_access_view.chart_of_accounts_id%TYPE DEFAULT NULL;
2344: p_role wf_roles.name%TYPE;
2345: msg az_webform_messages.mesg%TYPE;
2346:
2347: BEGIN

Line 2361: FROM org_access_view

2357: BEGIN
2358: IF(ctx_type = 'IO') THEN
2359: SELECT distinct organization_code, chart_of_accounts_id
2360: INTO org_code, coa_id
2361: FROM org_access_view
2362: WHERE organization_id = ctx_id;
2363: END IF;
2364: EXCEPTION
2365: WHEN OTHERS THEN

Line 2370: fnd_message.set_token('AZW_ERROR_STMT','select organization_code from org_access_view');

2366: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2367: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2368: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2369: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2370: fnd_message.set_token('AZW_ERROR_STMT','select organization_code from org_access_view');
2371: APP_EXCEPTION.RAISE_EXCEPTION;
2372: END;
2373:
2374: AIWStart(p_type, p_name, ctx_name, p_role ,ctx_type, ctx_id, org_code,