43: SELECT as_sales_methodology_s.nextval
44: INTO v_sales_methodology_id
45: FROM dual;
46: -- call table handler to insert into as_sales_methodology_b
47: as_sales_methodology_pkg.insert_row (
48: v_rowid,
49: v_sales_methodology_id,
50: p_sales_methodology_name,
51: p_start_date_active,
156: BEGIN
157: x_return_status := fnd_api.g_ret_sts_success;
158: SAVEPOINT update_sales_methodology_pvt;
159: -- call locking table handler
160: as_sales_methodology_pkg.lock_row (
161: p_sales_methodology_id,
162: x_object_version_number
163: );
164: -- call table handler to update into as_sales_methodology
161: p_sales_methodology_id,
162: x_object_version_number
163: );
164: -- call table handler to update into as_sales_methodology
165: as_sales_methodology_pkg.update_row (
166: p_sales_methodology_id,
167: x_object_version_number,
168: p_sales_methodology_name,
169: p_start_date_active,
255: DELETE FROM AS_SALES_METH_STAGE_MAP
256: WHERE SALES_METHODOLOGY_ID = P_SALES_METHODOLOGY_ID;
257:
258: -- call table handler to insert into jtf_tasks_temp_groups
259: as_sales_methodology_pkg.delete_row (p_sales_methodology_id);
260:
261: -- standard check of p_commit
262: IF (fnd_api.to_boolean (p_commit))
263: THEN