APPS.CCT_UPGRADE_PKG dependencies on CCT_MIDDLEWARES

Line 582: from cct_middlewares a,cct_middleware_types b

578: IS
579: Cursor c_mw
580: is
581: Select a.middleware_id
582: from cct_middlewares a,cct_middleware_types b
583: where a.middleware_type_id=b.middleware_type_id
584: and b.middleware_type='PROSPECT_ASPECT';
585:
586: Begin

Line 607: delete cct_middlewares

603: --dbms_output.put_line('error in deleting resourcE_middleware values for Prospect Aspect');
604: null;
605: End;
606: Begin
607: delete cct_middlewares
608: where middleware_id=v_mw.middleware_id;
609: Exception
610: When others then
611: --dbms_output.put_line('error in deleting middleware for type Prospect Aspect');

Line 659: cct_middlewares c

655: Cursor c_mvp
656: is
657: Select a.middleware_value_id,a.name,b.middleware_param_id
658: from cct_middleware_values a, cct_middleware_params b,
659: cct_middlewares c
660: where a.name=b.name
661: and a.middleware_param_id is null
662: and a.middleware_id=c.middleware_id
663: and c.middleware_type_id=b.middleware_type_id;

Line 748: from cct_middlewares m,cct_middleware_types t

744: IS
745: Cursor c_middleware
746: is
747: Select m.middleware_id
748: from cct_middlewares m,cct_middleware_types t
749: where t.middleware_type=p_old_type
750: and t.middleware_type_id=m.middleware_type_id
751: and m.middleware_id=p_middleware_id;
752:

Line 763: update cct_middlewares

759: from cct_middleware_types
760: where middleware_type=p_new_type;
761:
762: for v_middleware in c_middleware Loop
763: update cct_middlewares
764: set middleware_Type_id=l_new_type_id
765: where middleware_id=p_middleware_id;
766: end loop;
767:

Line 811: from cct_middlewares a,cct_middleware_types b

807: IS
808: Cursor c_mw
809: is
810: Select a.middleware_id
811: from cct_middlewares a,cct_middleware_types b
812: where a.middleware_type_id=b.middleware_type_id
813: and b.middleware_type_id=p_middleware_type_id;
814:
815: Begin

Line 836: delete cct_middlewares

832: --dbms_output.put_line('error in deleting resourcE_middleware values for Prospect Aspect');
833: null;
834: End;
835: Begin
836: delete cct_middlewares
837: where middleware_id=v_mw.middleware_id;
838: Exception
839: When others then
840: --dbms_output.put_line('error in deleting middleware for type Prospect Aspect');