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.AP_EXPENSE_REPORT_HEADERS_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 1: PACKAGE BODY AP_EXPENSE_REPORT_HEADERS_PKG as

1: PACKAGE BODY AP_EXPENSE_REPORT_HEADERS_PKG as
2: /* $Header: apixxrhb.pls 120.5 2005/11/16 07:18:23 srinvenk ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 90: CURSOR C IS SELECT rowid FROM AP_EXPENSE_REPORT_HEADERS

86: X_global_attribute19 VARCHAR2 DEFAULT NULL,
87: X_global_attribute20 VARCHAR2 DEFAULT NULL,
88: X_calling_sequence IN VARCHAR2
89: ) IS
90: CURSOR C IS SELECT rowid FROM AP_EXPENSE_REPORT_HEADERS
91: WHERE report_header_id = X_Report_Header_Id;
92: current_calling_sequence VARCHAR2(2000);
93: debug_info VARCHAR2(100);
94:

Line 98: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.INSERT_ROW<-' ||

94:
95: BEGIN
96: -- Update the calling sequence
97: --
98: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.INSERT_ROW<-' ||
99: X_calling_sequence;
100:
101: debug_info := 'Insert into AP_EXPENSE_REPORT_HEADERS';
102: INSERT INTO AP_EXPENSE_REPORT_HEADERS(

Line 101: debug_info := 'Insert into AP_EXPENSE_REPORT_HEADERS';

97: --
98: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.INSERT_ROW<-' ||
99: X_calling_sequence;
100:
101: debug_info := 'Insert into AP_EXPENSE_REPORT_HEADERS';
102: INSERT INTO AP_EXPENSE_REPORT_HEADERS(
103:
104: report_header_id,
105: employee_id,

Line 102: INSERT INTO AP_EXPENSE_REPORT_HEADERS(

98: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.INSERT_ROW<-' ||
99: X_calling_sequence;
100:
101: debug_info := 'Insert into AP_EXPENSE_REPORT_HEADERS';
102: INSERT INTO AP_EXPENSE_REPORT_HEADERS(
103:
104: report_header_id,
105: employee_id,
106: week_end_date,

Line 381: FROM AP_EXPENSE_REPORT_HEADERS

377: X_calling_sequence IN VARCHAR2
378: ) IS
379: CURSOR C IS
380: SELECT *
381: FROM AP_EXPENSE_REPORT_HEADERS
382: WHERE rowid = X_Rowid
383: FOR UPDATE of Report_Header_Id NOWAIT;
384: Recinfo C%ROWTYPE;
385:

Line 392: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.LOCK_ROW<-' ||

388:
389: BEGIN
390: -- Update the calling sequence
391: --
392: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.LOCK_ROW<-' ||
393: X_calling_sequence;
394: debug_info := 'Open cursor C';
395: OPEN C;
396: debug_info := 'Fetch cursor C';

Line 750: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.UPDATE_ROW<-' ||

746: debug_info VARCHAR2(100);
747: BEGIN
748: -- Update the calling sequence
749: --
750: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.UPDATE_ROW<-' ||
751: X_calling_sequence;
752: debug_info := 'Update AP_EXPENSE_REPORT_HEADERS';
753: UPDATE AP_EXPENSE_REPORT_HEADERS
754: SET

Line 752: debug_info := 'Update AP_EXPENSE_REPORT_HEADERS';

748: -- Update the calling sequence
749: --
750: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.UPDATE_ROW<-' ||
751: X_calling_sequence;
752: debug_info := 'Update AP_EXPENSE_REPORT_HEADERS';
753: UPDATE AP_EXPENSE_REPORT_HEADERS
754: SET
755: report_header_id = X_Report_Header_Id,
756: employee_id = X_Employee_Id,

Line 753: UPDATE AP_EXPENSE_REPORT_HEADERS

749: --
750: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.UPDATE_ROW<-' ||
751: X_calling_sequence;
752: debug_info := 'Update AP_EXPENSE_REPORT_HEADERS';
753: UPDATE AP_EXPENSE_REPORT_HEADERS
754: SET
755: report_header_id = X_Report_Header_Id,
756: employee_id = X_Employee_Id,
757: week_end_date = X_Week_End_Date,

Line 862: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.DELETE_ROW<-' ||

858: debug_info VARCHAR2(100);
859: BEGIN
860: -- Update the calling sequence
861: --
862: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.DELETE_ROW<-' ||
863: X_calling_sequence;
864: debug_info := 'Delete from AP_EXPENSE_REPORT_HEADERS';
865: DELETE FROM AP_EXPENSE_REPORT_HEADERS
866: WHERE rowid = X_Rowid;

Line 864: debug_info := 'Delete from AP_EXPENSE_REPORT_HEADERS';

860: -- Update the calling sequence
861: --
862: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.DELETE_ROW<-' ||
863: X_calling_sequence;
864: debug_info := 'Delete from AP_EXPENSE_REPORT_HEADERS';
865: DELETE FROM AP_EXPENSE_REPORT_HEADERS
866: WHERE rowid = X_Rowid;
867:
868: if (SQL%NOTFOUND) then

Line 865: DELETE FROM AP_EXPENSE_REPORT_HEADERS

861: --
862: current_calling_sequence := 'AP_EXPENSE_REPORT_HEADERS_PKG.DELETE_ROW<-' ||
863: X_calling_sequence;
864: debug_info := 'Delete from AP_EXPENSE_REPORT_HEADERS';
865: DELETE FROM AP_EXPENSE_REPORT_HEADERS
866: WHERE rowid = X_Rowid;
867:
868: if (SQL%NOTFOUND) then
869: Raise NO_DATA_FOUND;

Line 886: END AP_EXPENSE_REPORT_HEADERS_PKG;

882:
883: END Delete_Row;
884:
885:
886: END AP_EXPENSE_REPORT_HEADERS_PKG;