APPS.ZPB_BUSAREA_VAL dependencies on ZPB_AW

Line 130: if (zpb_aw.interpbool('shw aw(attached ''' || p_codeAW || ''')')) then

126: procedure DETACH_AWS(p_codeAW IN VARCHAR,
127: p_sharedAW IN VARCHAR)
128: is
129: begin
130: if (zpb_aw.interpbool('shw aw(attached ''' || p_codeAW || ''')')) then
131: zpb_aw.execute ('aw detach '||p_codeAW);
132: end if;
133: if (zpb_aw.interpbool('shw aw(attached ''' || p_sharedAW || ''')')) then
134: zpb_aw.execute ('aw detach '||p_sharedAW);

Line 131: zpb_aw.execute ('aw detach '||p_codeAW);

127: p_sharedAW IN VARCHAR)
128: is
129: begin
130: if (zpb_aw.interpbool('shw aw(attached ''' || p_codeAW || ''')')) then
131: zpb_aw.execute ('aw detach '||p_codeAW);
132: end if;
133: if (zpb_aw.interpbool('shw aw(attached ''' || p_sharedAW || ''')')) then
134: zpb_aw.execute ('aw detach '||p_sharedAW);
135: end if;

Line 133: if (zpb_aw.interpbool('shw aw(attached ''' || p_sharedAW || ''')')) then

129: begin
130: if (zpb_aw.interpbool('shw aw(attached ''' || p_codeAW || ''')')) then
131: zpb_aw.execute ('aw detach '||p_codeAW);
132: end if;
133: if (zpb_aw.interpbool('shw aw(attached ''' || p_sharedAW || ''')')) then
134: zpb_aw.execute ('aw detach '||p_sharedAW);
135: end if;
136: EXCEPTION
137: WHEN OTHERS THEN

Line 134: zpb_aw.execute ('aw detach '||p_sharedAW);

130: if (zpb_aw.interpbool('shw aw(attached ''' || p_codeAW || ''')')) then
131: zpb_aw.execute ('aw detach '||p_codeAW);
132: end if;
133: if (zpb_aw.interpbool('shw aw(attached ''' || p_sharedAW || ''')')) then
134: zpb_aw.execute ('aw detach '||p_sharedAW);
135: end if;
136: EXCEPTION
137: WHEN OTHERS THEN
138: null;

Line 3078: l_codeAW := zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(FND_GLOBAL.USER_ID);

3074: end;
3075:
3076:
3077: BEGIN
3078: l_codeAW := zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(FND_GLOBAL.USER_ID);
3079: l_sharedAW := 'ZPB.ZPBDATA'||l_ba_id;
3080: ATTACH_AWS(l_codeAW, l_sharedAW);
3081:
3082: SELECT SHAR_TABLE_ID INTO l_tableID FROM zpb_dimensions