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.12010000.2 2009/10/07 07:10:57 sodash ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 91: CURSOR C IS SELECT rowid FROM AP_EXPENSE_REPORT_HEADERS

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

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

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

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

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

Line 103: INSERT INTO AP_EXPENSE_REPORT_HEADERS(

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

Line 384: FROM AP_EXPENSE_REPORT_HEADERS

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

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

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

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

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

Line 755: debug_info := 'Update AP_EXPENSE_REPORT_HEADERS';

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

Line 756: UPDATE AP_EXPENSE_REPORT_HEADERS

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

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

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

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

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

Line 868: DELETE FROM AP_EXPENSE_REPORT_HEADERS

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

Line 889: END AP_EXPENSE_REPORT_HEADERS_PKG;

885:
886: END Delete_Row;
887:
888:
889: END AP_EXPENSE_REPORT_HEADERS_PKG;