APPS.PA_EXPENDITURE_ITEMS_PKG dependencies on PA_EXPENDITURE_COMMENTS

Line 423: insert into pa_expenditure_comments (expenditure_item_id,

419: end if;
420:
421:
422: if (x_expenditure_comment is not null) then
423: insert into pa_expenditure_comments (expenditure_item_id,
424: line_number,
425: expenditure_comment,
426: last_update_date,
427: last_updated_by,

Line 548: from pa_expenditure_comments

544: p_capital_event_id IN number default null
545: ) is
546:
547: cursor c_get_comment is select expenditure_comment
548: from pa_expenditure_comments
549: where expenditure_item_id = x_expenditure_item_id;
550:
551: temp_comment c_get_comment%rowtype;
552:

Line 691: insert into pa_expenditure_comments (expenditure_item_id,

687: open c_get_comment;
688: fetch c_get_comment into temp_comment;
689: if (c_get_comment%notfound) then
690: if (x_expenditure_comment is not null) then
691: insert into pa_expenditure_comments (expenditure_item_id,
692: line_number,
693: expenditure_comment,
694: last_update_date,
695: last_updated_by,

Line 710: update pa_expenditure_comments

706: x_last_update_login);
707: end if;
708: else
709: if (x_expenditure_comment is not null) then
710: update pa_expenditure_comments
711: set expenditure_comment = x_expenditure_comment
712: where expenditure_item_id = x_expenditure_item_id;
713: else
714: delete from pa_expenditure_comments

Line 714: delete from pa_expenditure_comments

710: update pa_expenditure_comments
711: set expenditure_comment = x_expenditure_comment
712: where expenditure_item_id = x_expenditure_item_id;
713: else
714: delete from pa_expenditure_comments
715: where expenditure_item_id = x_expenditure_item_id;
716: end if;
717: end if;
718:

Line 781: delete from pa_expenditure_comments

777:
778: end if;
779:
780: -- error checking?
781: delete from pa_expenditure_comments
782: where expenditure_item_id = x_expenditure_item_id;
783:
784: delete from pa_expenditure_items
785: where expenditure_item_id = x_expenditure_item_id;