APPS.PA_ADJUSTMENTS dependencies on PA_EXPENDITURE_COMMENTS

Line 275: DELETE FROM pa_expenditure_comments

271: PROCEDURE DelComment( X_exp_item_id IN NUMBER
272: , X_status OUT NOCOPY NUMBER )
273: IS
274: BEGIN
275: DELETE FROM pa_expenditure_comments
276: WHERE
277: expenditure_item_id = X_exp_item_id;
278:
279: X_status := 0;

Line 301: UPDATE pa_expenditure_comments

297: , X_status OUT NOCOPY NUMBER )
298: IS
299: BEGIN
300:
301: UPDATE pa_expenditure_comments
302: SET
303: expenditure_comment = X_new_comment
304: , last_update_date = sysdate
305: , last_updated_by = X_user

Line 326: FROM pa_expenditure_comments

322: INTO dummy
323: FROM sys.dual
324: WHERE EXISTS
325: ( SELECT NULL
326: FROM pa_expenditure_comments
327: WHERE expenditure_item_id = X_exp_item_id);
328:
329: IF( dummy = 0 ) THEN
330:

Line 740: and storing it in pa_expenditure_comments table */

736: END IF ;
737:
738: /* Fix for bug 2211472 */
739: /* Adding the comment of original expenditure_item to the reversed expenditure item
740: and storing it in pa_expenditure_comments table */
741: BEGIN
742: SELECT
743: ec.expenditure_comment
744: INTO

Line 747: pa_expenditure_comments ec

743: ec.expenditure_comment
744: INTO
745: item_comment
746: FROM
747: pa_expenditure_comments ec
748: WHERE
749: ec.expenditure_item_id = X_exp_item_id;
750: EXCEPTION
751: WHEN NO_DATA_FOUND THEN

Line 3043: pa_expenditure_comments ec

3039: ec.expenditure_comment
3040: INTO
3041: item_comment
3042: FROM
3043: pa_expenditure_comments ec
3044: WHERE
3045: ec.expenditure_item_id = X_exp_item_id;
3046:
3047: EXCEPTION

Line 3619: , pa_expenditure_comments ec

3615: pa_expenditures_all e
3616: , pa_expenditure_items_all ei
3617: , pa_expenditure_items_all ei2
3618: , pa_transaction_sources ts
3619: , pa_expenditure_comments ec
3620: /* R12 changes - Removed table pa_cost_distribution_lines */
3621: WHERE
3622: e.expenditure_id = ei.expenditure_id
3623: AND ei.expenditure_item_id = ei2.expenditure_item_id