APPS.IES_META_OBJ_PKG dependencies on IES_META_OBJ_RELATIONSHIPS

Line 584: from IES_META_OBJ_RELATIONSHIPS C,

580: objRelId number := -1;
581: begin
582: select OBJREL_ID
583: into objRelId
584: from IES_META_OBJ_RELATIONSHIPS C,
585: IES_META_RELATIONSHIP_TYPES D
586: where PRIMARY_OBJ_ID = (select OBJECT_ID
587: from IES_META_OBJECTS
588: where OBJECT_UID = x_prim_obj_uid

Line 648: execute immediate 'update IES_META_OBJ_RELATIONSHIPS set

644: relId := getRelationshipId(x_prim_obj_uid,
645: x_sec_obj_uid,
646: x_type_name);
647:
648: execute immediate 'update IES_META_OBJ_RELATIONSHIPS set
649: LAST_UPDATE_DATE = :1,
650: LAST_UPDATED_BY = :2,
651: DELETED_STATUS = :3,
652: TYPE_ID = :4,

Line 676: execute immediate 'select IES_META_OBJ_RELATIONSHIPS_S.NEXTVAL from dual' into seqval;

672: typeId := getRelationshipTypeId(x_type_name);
673: primObjId := getObjectId(x_prim_obj_uid);
674: secObjId := getObjectId(x_sec_obj_uid);
675:
676: execute immediate 'select IES_META_OBJ_RELATIONSHIPS_S.NEXTVAL from dual' into seqval;
677:
678: insertStmt := 'insert into IES_META_OBJ_RELATIONSHIPS (
679: OBJREL_ID,
680: CREATION_DATE,

Line 678: insertStmt := 'insert into IES_META_OBJ_RELATIONSHIPS (

674: secObjId := getObjectId(x_sec_obj_uid);
675:
676: execute immediate 'select IES_META_OBJ_RELATIONSHIPS_S.NEXTVAL from dual' into seqval;
677:
678: insertStmt := 'insert into IES_META_OBJ_RELATIONSHIPS (
679: OBJREL_ID,
680: CREATION_DATE,
681: CREATED_BY,
682: LAST_UPDATE_DATE,

Line 724: from IES_META_OBJ_RELATIONSHIPS C,

720: db_ludate date;
721:
722: CURSOR rels_curs IS
723: select c.last_updated_by, c.last_update_date
724: from IES_META_OBJ_RELATIONSHIPS C,
725: IES_META_RELATIONSHIP_TYPES D
726: where PRIMARY_OBJ_ID = (select OBJECT_ID
727: from IES_META_OBJECTS
728: where OBJECT_UID = x_prim_obj_uid