eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_EXPENDITURE_ITEMS_PKG dependencies on PA_EXPENDITURE_ITEMS

Line 1: package body pa_expenditure_items_pkg as

1: package body pa_expenditure_items_pkg as
2: /* $Header: PAXTITMB.pls 120.7.12020000.3 2013/04/24 10:49:00 rboyalap ship $ */
3:
4: procedure insert_row (x_rowid in out NOCOPY VARCHAR2,
5: x_expenditure_item_id in out NOCOPY NUMBER,

Line 111: cursor return_rowid is select rowid from pa_expenditure_items

107: --,P_Agreement_id IN NUMBER DEFAULT NULL --FSIO Changes
108: p_cbs_element_id IN NUMBER default null -- Added as part of bug 16714738
109: ) is
110:
111: cursor return_rowid is select rowid from pa_expenditure_items
112: where expenditure_item_id = x_expenditure_item_id;
113: cursor get_itemid is select pa_expenditure_items_s.nextval from sys.dual;
114:
115: status NUMBER;

Line 113: cursor get_itemid is select pa_expenditure_items_s.nextval from sys.dual;

109: ) is
110:
111: cursor return_rowid is select rowid from pa_expenditure_items
112: where expenditure_item_id = x_expenditure_item_id;
113: cursor get_itemid is select pa_expenditure_items_s.nextval from sys.dual;
114:
115: status NUMBER;
116: l_rowid VARCHAR2(1000);
117: l_expenditure_item_id NUMBER;

Line 130: insert into pa_expenditure_items (

126: end if;
127:
128: -- if amt is negative, need to update reversed original
129:
130: insert into pa_expenditure_items (
131: expenditure_item_id,
132: last_update_date,
133: last_updated_by,
134: creation_date,

Line 354: update pa_expenditure_items

350: if (((x_quantity < 0) or (x_burden_cost < 0)) and
351: (x_net_zero_adjustment_flag = 'Y')) then */
352:
353: If x_net_zero_adjustment_flag = 'Y' then
354: update pa_expenditure_items
355: set net_zero_adjustment_flag = 'Y',
356: last_update_date = x_last_update_date -- Added as part of Bug 12878265
357: where expenditure_item_id = x_adjusted_expenditure_item_id;
358:

Line 361: UPDATE pa_expenditure_items

357: where expenditure_item_id = x_adjusted_expenditure_item_id;
358:
359: /*Added for bug 5639026 to update transfer price columns*/
360: IF nvl(x_adjusted_expenditure_item_id, 0) <> 0 then
361: UPDATE pa_expenditure_items
362: SET(cc_prvdr_organization_id,
363: cc_recvr_organization_id,
364: cc_rejection_code,
365: denom_tp_currency_code,

Line 429: FROM pa_expenditure_items ei

425: ei.RATE_SOURCE_CODE,
426: ei.PAYROLL_ACCRUAL_FLAG
427: /*End-changes for bug:12588960*/
428: -- ,ei.agreement_id --FSIO Changes
429: FROM pa_expenditure_items ei
430: WHERE ei.expenditure_item_id = x_adjusted_expenditure_item_id)
431: WHERE expenditure_item_id = x_expenditure_item_id;
432: END if;
433: /* End of bug fix for 5639026 */

Line 598: update pa_expenditure_items

594:
595: BEGIN
596: -- need to check status, force user to use adjust if necessary
597:
598: update pa_expenditure_items
599: set expenditure_item_id = x_expenditure_item_id,
600: last_update_date = x_last_update_date,
601: last_updated_by = x_last_updated_by,
602: expenditure_id = x_expenditure_id,

Line 704: update pa_expenditure_items

700: /* Bug 1715308 : Removed the condition of x_quantity < 0
701: if (((x_quantity < 0) or (x_burden_cost < 0)) and
702: (x_net_zero_adjustment_flag = 'Y')) then */
703: if x_net_zero_adjustment_flag = 'Y' then
704: update pa_expenditure_items
705: set net_zero_adjustment_flag = 'Y',
706: last_update_date = x_last_update_date -- Added as part of Bug 12878265
707: where expenditure_item_id = x_adjusted_expenditure_item_id;
708:

Line 770: select adjusted_expenditure_item_id from pa_expenditure_items

766:
767: procedure delete_row (x_expenditure_item_id in NUMBER) is
768:
769: cursor check_reversing is
770: select adjusted_expenditure_item_id from pa_expenditure_items
771: where expenditure_item_id = x_expenditure_item_id;
772:
773: cursor check_source is
774: select expenditure_item_id, adjusted_expenditure_item_id

Line 775: from pa_expenditure_items

771: where expenditure_item_id = x_expenditure_item_id;
772:
773: cursor check_source is
774: select expenditure_item_id, adjusted_expenditure_item_id
775: from pa_expenditure_items
776: where source_expenditure_item_id = x_expenditure_item_id;
777:
778: rev_item check_reversing%rowtype;
779: source_item check_source%rowtype;

Line 787: update pa_expenditure_items

783: -- reset the adjustment flag.
784: open check_reversing;
785: fetch check_reversing into rev_item;
786: if (rev_item.adjusted_expenditure_item_id is not null) then
787: update pa_expenditure_items
788: set net_zero_adjustment_flag = 'N'
789: where expenditure_item_id = rev_item.adjusted_expenditure_item_id;
790:
791: open check_source ;

Line 806: update pa_expenditure_items

802: if check_source%notfound then exit ;
803: end if;
804: fetch check_source into source_item ;
805: if (source_item.adjusted_expenditure_item_id is not null) then
806: update pa_expenditure_items
807: set net_zero_adjustment_flag = 'N'
808: where expenditure_item_id = source_item.adjusted_expenditure_item_id ;
809:
810: delete from pa_expenditure_items

Line 810: delete from pa_expenditure_items

806: update pa_expenditure_items
807: set net_zero_adjustment_flag = 'N'
808: where expenditure_item_id = source_item.adjusted_expenditure_item_id ;
809:
810: delete from pa_expenditure_items
811: where expenditure_item_id = source_item.expenditure_item_id;
812: end if ;
813: END LOOP;
814: --

Line 825: delete from pa_expenditure_items

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;
827:
828:
829: END delete_row;

Line 834: cursor get_itemid is select expenditure_item_id from pa_expenditure_items

830:
831:
832: procedure delete_row (x_rowid in VARCHAR2) is
833:
834: cursor get_itemid is select expenditure_item_id from pa_expenditure_items
835: where rowid = x_rowid;
836: x_expenditure_item_id NUMBER;
837:
838: BEGIN

Line 853: END pa_expenditure_items_pkg;

849: BEGIN
850: null;
851: END lock_row;
852:
853: END pa_expenditure_items_pkg;