61:
62:
63: BEGIN
64:
65: pnp_debug_pkg.debug(l_desc ||' (+)');
66:
67: IF x_org_id IS NULL THEN
68: FOR rec IN org_cur LOOP
69: l_org_id := rec.org_id;
153: x_attribute14,
154: x_attribute15
155: ) RETURNING expense_line_dtl_id INTO x_expense_line_dtl_id;
156:
157: pnp_debug_pkg.debug(l_desc ||' (-)');
158:
159: EXCEPTION
160: WHEN OTHERS THEN
161: app_exception.raise_exception;
209: IS
210: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.update_row';
211: BEGIN
212:
213: pnp_debug_pkg.debug(l_desc ||' (+)');
214:
215: UPDATE pn_rec_exp_line_dtl_all
216: SET parent_expense_line_id = x_parent_expense_line_id,
217: location_id = x_location_id,
250: attribute14 = x_attribute14,
251: attribute15 = x_attribute15
252: WHERE expense_line_dtl_id = x_expense_line_dtl_id;
253:
254: pnp_debug_pkg.debug(l_desc ||' (-)');
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
271: PROCEDURE delete_row(x_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE) IS
272: l_desc VARCHAR2(100) := 'pn_rec_exp_line_dtl_pkg.delete_row';
273: BEGIN
274:
275: pnp_debug_pkg.debug(l_desc ||' (+)');
276:
277: DELETE pn_rec_exp_line_dtl_all
278: WHERE expense_line_dtl_id = x_expense_line_dtl_id;
279:
276:
277: DELETE pn_rec_exp_line_dtl_all
278: WHERE expense_line_dtl_id = x_expense_line_dtl_id;
279:
280: pnp_debug_pkg.debug(l_desc ||' (-)');
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));