475: dbg(l_view_sql);
476: dbg(' ');
477:
478: -- Execute view creation statement
479: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
480: application_short_name => 'APPS',
481: statement_type => ad_ddl.create_view,
482: statement => l_view_sql,
483: object_name => 'HRI_CL_JOB_FAMILY_V');
477:
478: -- Execute view creation statement
479: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
480: application_short_name => 'APPS',
481: statement_type => ad_ddl.create_view,
482: statement => l_view_sql,
483: object_name => 'HRI_CL_JOB_FAMILY_V');
484: -- -------------------------------------------------------------------------
485: -- Generate OBI Job Family View
508: dbg(l_view_sql);
509: dbg(' ');
510:
511: -- Execute view creation statement
512: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
513: application_short_name => 'APPS',
514: statement_type => ad_ddl.create_view,
515: statement => l_view_sql,
516: object_name => 'HRI_OBI_CL_JOB_FAMILY_V');
510:
511: -- Execute view creation statement
512: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
513: application_short_name => 'APPS',
514: statement_type => ad_ddl.create_view,
515: statement => l_view_sql,
516: object_name => 'HRI_OBI_CL_JOB_FAMILY_V');
517:
518:
569: dbg(l_view_sql);
570: dbg(' ');
571:
572: -- Execute view creation statement
573: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
574: application_short_name => 'APPS',
575: statement_type => ad_ddl.create_view,
576: statement => l_view_sql,
577: object_name => 'HRI_CL_JOB_FUNCTION_V');
571:
572: -- Execute view creation statement
573: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
574: application_short_name => 'APPS',
575: statement_type => ad_ddl.create_view,
576: statement => l_view_sql,
577: object_name => 'HRI_CL_JOB_FUNCTION_V');
578:
579: -- ----------------------------------------------------------------------------
602: dbg(l_view_sql);
603: dbg(' ');
604:
605: -- Execute view creation statement
606: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
607: application_short_name => 'APPS',
608: statement_type => ad_ddl.create_view,
609: statement => l_view_sql,
610: object_name => 'HRI_OBI_CL_JOB_FUNCTION_V');
604:
605: -- Execute view creation statement
606: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
607: application_short_name => 'APPS',
608: statement_type => ad_ddl.create_view,
609: statement => l_view_sql,
610: object_name => 'HRI_OBI_CL_JOB_FUNCTION_V');
611:
612: -- Reset view sql
671: dbg(l_view_sql);
672: dbg(' ');
673:
674: -- Execute view creation statement
675: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
676: application_short_name => 'APPS',
677: statement_type => ad_ddl.create_view,
678: statement => l_view_sql,
679: object_name => 'HRI_OBI_CL_JOB_FMLYFNCT_V');
673:
674: -- Execute view creation statement
675: ad_ddl.do_ddl(applsys_schema => l_fnd_schema,
676: application_short_name => 'APPS',
677: statement_type => ad_ddl.create_view,
678: statement => l_view_sql,
679: object_name => 'HRI_OBI_CL_JOB_FMLYFNCT_V');
680:
681: