APPS.IEB_SVC_CAT_TEMPS_SEED_PKG dependencies on IEB_SVC_CAT_TEMPS_B

Line 28: FROM ieb_svc_cat_temps_b

24: , x_MEDIA_CATEGORY_LABEL IN VARCHAR2
25: ) IS
26: CURSOR l_insert IS
27: SELECT 'X'
28: FROM ieb_svc_cat_temps_b
29: WHERE wbsc_id = x_wbsc_id;
30: BEGIN
31: INSERT INTO ieb_svc_cat_temps_b (
32: wbsc_id

Line 31: INSERT INTO ieb_svc_cat_temps_b (

27: SELECT 'X'
28: FROM ieb_svc_cat_temps_b
29: WHERE wbsc_id = x_wbsc_id;
30: BEGIN
31: INSERT INTO ieb_svc_cat_temps_b (
32: wbsc_id
33: , svcpln_svcpln_id
34: , created_by
35: , creation_date

Line 127: UPDATE ieb_svc_cat_temps_b

123: , x_DESCRIPTION IN VARCHAR2
124: , x_MEDIA_CATEGORY_LABEL IN VARCHAR2
125: ) IS
126: BEGIN
127: UPDATE ieb_svc_cat_temps_b
128: SET
129: svcpln_svcpln_id=DECODE(x_svcpln_svcpln_id,FND_API.G_MISS_NUM,NULL,x_svcpln_svcpln_id)
130: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
131: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

Line 300: from IEB_SVC_CAT_TEMPS_B B

296: begin
297: delete from IEB_SVC_CAT_TEMPS_TL T
298: where not exists
299: (select NULL
300: from IEB_SVC_CAT_TEMPS_B B
301: where B.WBSC_ID = T.WBSC_ID
302: );
303:
304: update IEB_SVC_CAT_TEMPS_TL T set (