DBA Data[Home] [Help]

APPS.ZPB_SECURITY_CONTEXT dependencies on DBMS_AW

Line 53: dbms_aw.execute ('aw attach ' || l_zpb_pref || 'ZPBCODE');

49:
50: l_zpb_pref := zpb_aw.get_schema;
51: l_zpb_pref := l_zpb_pref || '.';
52:
53: dbms_aw.execute ('aw attach ' || l_zpb_pref || 'ZPBCODE');
54: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_annot_aw);
55: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_shar_aw);
56: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias SHARED');
57: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias S');

Line 54: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_annot_aw);

50: l_zpb_pref := zpb_aw.get_schema;
51: l_zpb_pref := l_zpb_pref || '.';
52:
53: dbms_aw.execute ('aw attach ' || l_zpb_pref || 'ZPBCODE');
54: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_annot_aw);
55: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_shar_aw);
56: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias SHARED');
57: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias S');
58: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias AGGAW');

Line 55: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_shar_aw);

51: l_zpb_pref := l_zpb_pref || '.';
52:
53: dbms_aw.execute ('aw attach ' || l_zpb_pref || 'ZPBCODE');
54: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_annot_aw);
55: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_shar_aw);
56: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias SHARED');
57: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias S');
58: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias AGGAW');
59:

Line 56: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias SHARED');

52:
53: dbms_aw.execute ('aw attach ' || l_zpb_pref || 'ZPBCODE');
54: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_annot_aw);
55: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_shar_aw);
56: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias SHARED');
57: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias S');
58: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias AGGAW');
59:
60: -- if provided, limit the language dimension

Line 57: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias S');

53: dbms_aw.execute ('aw attach ' || l_zpb_pref || 'ZPBCODE');
54: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_annot_aw);
55: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_shar_aw);
56: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias SHARED');
57: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias S');
58: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias AGGAW');
59:
60: -- if provided, limit the language dimension
61: if p_lang is not null then

Line 58: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias AGGAW');

54: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_annot_aw);
55: dbms_aw.execute ('aw attach ' || l_zpb_pref || l_shar_aw);
56: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias SHARED');
57: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias S');
58: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias AGGAW');
59:
60: -- if provided, limit the language dimension
61: if p_lang is not null then
62: dbms_aw.execute ('limit ' || l_zpb_pref || l_shar_aw || '!LANG to ''' || p_lang || '''');

Line 62: dbms_aw.execute ('limit ' || l_zpb_pref || l_shar_aw || '!LANG to ''' || p_lang || '''');

58: dbms_aw.execute ('aw aliaslist ' || l_zpb_pref || l_shar_aw ||' alias AGGAW');
59:
60: -- if provided, limit the language dimension
61: if p_lang is not null then
62: dbms_aw.execute ('limit ' || l_zpb_pref || l_shar_aw || '!LANG to ''' || p_lang || '''');
63: end if;
64:
65:
66: END INITOPENSQL;