8: --
9: -- API Name : create_status
10: -- Type : Public
11: -- Function : To create status codes using the table handler
12: -- Pre-Reqs : The table handler API AS_STATUSES_PKG.INSERT_ROW
13: -- should exist
14: -- Parameters :
15: -- IN : p_api_version_number IN NUMBER
16: -- p_init_msg_list IN VARCHAR2
360: END IF;
361:
362:
363: -- Insert into as_statuses_b and as_statuses_tl using api
364: -- AS_STATUSES_PKG.INSERT_ROW
365:
366: AS_STATUSES_PKG.INSERT_ROW(
367: l_row_id,
368: p_status_rec.status_code,
362:
363: -- Insert into as_statuses_b and as_statuses_tl using api
364: -- AS_STATUSES_PKG.INSERT_ROW
365:
366: AS_STATUSES_PKG.INSERT_ROW(
367: l_row_id,
368: p_status_rec.status_code,
369: p_status_rec.enabled_flag,
370: p_status_rec.lead_flag,
440: --
441: -- API Name : update_status
442: -- Type : Public
443: -- Function : To update the status code using the table handler
444: -- Pre-Reqs : Table Handler AS_STATUSES_PKG.UPDATE_ROW should exist
445: -- Parameters :
446: -- IN : p_api_version_number IN NUMBER
447: -- p_init_msg_list IN VARCHAR2
448: -- p_commit IN VARCHAR2
924: fnd_msg_pub.add;
925: RAISE fnd_api.g_exc_error;
926: END IF;
927:
928: AS_STATUSES_PKG.UPDATE_ROW(
929: p_status_rec.status_code,
930: v_enabled_flag,
931: v_lead_flag,
932: v_opp_flag,