DBA Data[Home] [Help]

APPS.HZ_BES_BO_TRACKING_PVT dependencies on HZ_BUS_OBJ_TRACKING

Line 144: FROM HZ_BUS_OBJ_TRACKING

140: -- if the record is not existing in BOT, only then insert.
141: BEGIN
142: l_child_rec_exists_no := 0;
143: SELECT child_id INTO l_child_rec_exists_no
144: FROM HZ_BUS_OBJ_TRACKING
145: WHERE event_id IS NULL
146: AND CHILD_ENTITY_NAME = P_CHILD_TBL_NAME
147: AND CHILD_ID = p_CHILD_ID
148: AND PARENT_ENTITY_NAME = P_PARENT_TBL_NAME

Line 160: INSERT INTO HZ_BUS_OBJ_TRACKING (

156: p_msg_level=>fnd_log.level_procedure);
157: END IF;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: INSERT INTO HZ_BUS_OBJ_TRACKING (
161: POPULATED_FLAG ,
162: CHILD_BO_CODE ,
163: CHILD_ENTITY_NAME ,
164: CHILD_ID ,