APPS.PA_EXPENDITURE_ITEMS_PKG dependencies on PA_EXPENDITURE_COMMENTS

Line 455: insert into pa_expenditure_comments (expenditure_item_id,

451: end if;
452:
453:
454: if (x_expenditure_comment is not null) then
455: insert into pa_expenditure_comments (expenditure_item_id,
456: line_number,
457: expenditure_comment,
458: last_update_date,
459: last_updated_by,

Line 584: from pa_expenditure_comments

580: p_cbs_element_id IN NUMBER default null -- Added as part of bug 16714738
581: ) is
582:
583: cursor c_get_comment is select expenditure_comment
584: from pa_expenditure_comments
585: where expenditure_item_id = x_expenditure_item_id;
586:
587: temp_comment c_get_comment%rowtype;
588:

Line 732: insert into pa_expenditure_comments (expenditure_item_id,

728: open c_get_comment;
729: fetch c_get_comment into temp_comment;
730: if (c_get_comment%notfound) then
731: if (x_expenditure_comment is not null) then
732: insert into pa_expenditure_comments (expenditure_item_id,
733: line_number,
734: expenditure_comment,
735: last_update_date,
736: last_updated_by,

Line 751: update pa_expenditure_comments

747: x_last_update_login);
748: end if;
749: else
750: if (x_expenditure_comment is not null) then
751: update pa_expenditure_comments
752: set expenditure_comment = x_expenditure_comment
753: where expenditure_item_id = x_expenditure_item_id;
754: else
755: delete from pa_expenditure_comments

Line 755: delete from pa_expenditure_comments

751: update pa_expenditure_comments
752: set expenditure_comment = x_expenditure_comment
753: where expenditure_item_id = x_expenditure_item_id;
754: else
755: delete from pa_expenditure_comments
756: where expenditure_item_id = x_expenditure_item_id;
757: end if;
758: end if;
759:

Line 822: delete from pa_expenditure_comments

818:
819: end if;
820:
821: -- error checking?
822: delete from pa_expenditure_comments
823: where expenditure_item_id = x_expenditure_item_id;
824:
825: delete from pa_expenditure_items
826: where expenditure_item_id = x_expenditure_item_id;