APPS.ZPB_METADATA_PKG dependencies on ZPB_METADATA_PKG

Line 1: package body ZPB_METADATA_PKG as

1: package body ZPB_METADATA_PKG as
2: /* $Header: ZPBMDPKB.pls 120.31 2007/12/04 14:35:35 mbhat noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(16) := 'ZPB_METADATA_PKG';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(16) := 'ZPB_METADATA_PKG';

1: package body ZPB_METADATA_PKG as
2: /* $Header: ZPBMDPKB.pls 120.31 2007/12/04 14:35:35 mbhat noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(16) := 'ZPB_METADATA_PKG';
5:
6: -------------------------------------------------------------------------------
7: -- insertDimensionRecord - Private function that inserts a
8: -- zpb_md_records.dimensions_entry into zpb_dimensions and

Line 1136: -- zpb_log.write_error('zpb_metadata_pkg.deleteCubeRecord',

1132: procedure deleteCubeRecord(p_cube_id in number) is
1133:
1134: begin
1135:
1136: -- zpb_log.write_error('zpb_metadata_pkg.deleteCubeRecord',
1137: -- 'Deleteing Cube '||p_cube_id);
1138:
1139: -- delete cube measures and measure scoping entries
1140:

Line 3247: zpb_log.write('zpb_metadata_pkg.build_cube.begin',

3243: bus_area_id_num number;
3244:
3245: begin
3246:
3247: zpb_log.write('zpb_metadata_pkg.build_cube.begin',
3248: 'Creating metadata in ' || p_aw ||
3249: ' for cube ' || p_cubeView ||
3250: ' of type '|| p_cube_type);
3251: l_gid := false;

Line 3408: zpb_log.write('zpb_metadata_pkg.build_instance.end',

3404: end if;
3405: exit when j=0;
3406: end loop;
3407:
3408: zpb_log.write('zpb_metadata_pkg.build_instance.end',
3409: 'succesfull completion');
3410:
3411: EXCEPTION
3412: WHEN OTHERS THEN

Line 3466: zpb_log.write('zpb_metadata_pkg.build_instance.begin',

3462: begin
3463:
3464:
3465:
3466: zpb_log.write('zpb_metadata_pkg.build_instance.begin',
3467: 'Creating metadata in ' || p_aw ||
3468: ' of type ' || p_type ||
3469: ' for instance '|| p_instance ||
3470: ' and template ' || p_template ||

Line 3859: zpb_log.write('zpb_metadata_pkg.build_instance.end',

3855:
3856: end if; -- shared or shared view for currency building
3857: zpb_aw.execute ('pop '||l_measAw||'MEASURE');
3858:
3859: zpb_log.write('zpb_metadata_pkg.build_instance.end',
3860: 'succesfull completion');
3861:
3862: EXCEPTION
3863: WHEN OTHERS THEN

Line 3926: zpb_log.write('zpb_metadata_pkg.build_measure.begin',

3922: bus_area_id_num number;
3923:
3924: begin
3925:
3926: zpb_log.write('zpb_metadata_pkg.build_measure.begin',
3927: 'Creating metadata in ' || p_aw ||
3928: ' in cube ' || p_cube ||
3929: ' for measure ' || p_meas ||
3930: ' for instance '|| p_instance ||

Line 4149: zpb_log.write_event('zpb_metadata_pkg.build_measure.error',

4145:
4146: m_meas_id := InsertMeasureRecord(m_meas_en);
4147:
4148: else
4149: zpb_log.write_event('zpb_metadata_pkg.build_measure.error',
4150: 'No metadata created because no metadata for' ||
4151: 'cube ' || p_cube);
4152:
4153: end if;

Line 4231: zpb_log.write('zpb_metadata_pkg.build.begin',

4227: m_column_id_num number;
4228:
4229: begin
4230:
4231: zpb_log.write('zpb_metadata_pkg.build.begin',
4232: 'Creating metadata map for '||p_aw);
4233: -- dbms_output.put_line('Creating metadata map for '||p_aw);
4234:
4235: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');

Line 4662: zpb_log.write('zpb_metadata_pkg.build.end',

4658: end if;
4659:
4660: zpb_aw.execute('pop oknullstatus '||l_global_ecm.AttrDim);
4661:
4662: zpb_log.write('zpb_metadata_pkg.build.end',
4663: 'Created metadata map for '||p_aw);
4664:
4665: EXCEPTION
4666: WHEN OTHERS THEN

Line 5276: -- zpb_log.write_error('zpb_metadata_pkg.delete_user',

5272: name like p_sharaw || '%';
5273:
5274: begin
5275:
5276: -- zpb_log.write_error('zpb_metadata_pkg.delete_user',
5277: -- 'Deleteing User '||p_user);
5278:
5279: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
5280:

Line 5303: -- zpb_log.write_error('zpb_metadata_pkg.delete_user',

5299: name like p_user || '/_%' escape '/';
5300:
5301: begin
5302:
5303: -- zpb_log.write_error('zpb_metadata_pkg.delete_user',
5304: -- 'Deleteing User '||p_user);
5305:
5306: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
5307:

Line 5971: end ZPB_METADATA_PKG;

5967:
5968:
5969: end cleanBusArea;
5970:
5971: end ZPB_METADATA_PKG;