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_WEB_DFLEX_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 4: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;

1: PACKAGE AP_WEB_DFLEX_PKG AS
2: /* $Header: apwdflxs.pls 120.18.12010000.3 2009/01/23 07:18:47 stalasil ship $ */
3:
4: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
5: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
6: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
7:
8: -- Constants

Line 5: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;

1: PACKAGE AP_WEB_DFLEX_PKG AS
2: /* $Header: apwdflxs.pls 120.18.12010000.3 2009/01/23 07:18:47 stalasil ship $ */
3:
4: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
5: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
6: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
7:
8: -- Constants
9: C_CustValidResMsgTypeNone CONSTANT VARCHAR(20) := NULL;

Line 104: nFreeBreakfasts1 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,

100: award_id gms_awards_all.award_id%TYPE,
101: cost_center VARCHAR2(240),
102: category_code VARCHAR2(20), --Bug 2292854
103: -- Per Diem data
104: nFreeBreakfasts1 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
105: nFreeBreakfasts2 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
106: nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,

Line 105: nFreeBreakfasts2 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,

101: cost_center VARCHAR2(240),
102: category_code VARCHAR2(20), --Bug 2292854
103: -- Per Diem data
104: nFreeBreakfasts1 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
105: nFreeBreakfasts2 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
106: nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,

Line 106: nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,

102: category_code VARCHAR2(20), --Bug 2292854
103: -- Per Diem data
104: nFreeBreakfasts1 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
105: nFreeBreakfasts2 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
106: nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,

Line 107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,

103: -- Per Diem data
104: nFreeBreakfasts1 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
105: nFreeBreakfasts2 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
106: nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,

Line 108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,

104: nFreeBreakfasts1 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
105: nFreeBreakfasts2 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
106: nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,

Line 109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,

105: nFreeBreakfasts2 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
106: nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,

Line 110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,

106: nFreeBreakfasts3 ap_expense_report_lines.NUM_FREE_BREAKFASTS1%type,
107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
114: nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,

Line 111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,

107: nFreeLunches1 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
114: nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
115: nFreeAccommodations3 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,

Line 112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,

108: nFreeLunches2 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
114: nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
115: nFreeAccommodations3 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
116: location ap_expense_report_lines.LOCATION%type,

Line 113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,

109: nFreeLunches3 ap_expense_report_lines.NUM_FREE_LUNCHES1%type,
110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
114: nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
115: nFreeAccommodations3 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
116: location ap_expense_report_lines.LOCATION%type,
117: -- Bug 3600198

Line 114: nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,

110: nFreeDinners1 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
114: nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
115: nFreeAccommodations3 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
116: location ap_expense_report_lines.LOCATION%type,
117: -- Bug 3600198
118: startTime VARCHAR(5), -- in HH24:MM format

Line 115: nFreeAccommodations3 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,

111: nFreeDinners2 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
114: nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
115: nFreeAccommodations3 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
116: location ap_expense_report_lines.LOCATION%type,
117: -- Bug 3600198
118: startTime VARCHAR(5), -- in HH24:MM format
119: endTime VARCHAR(5), -- in HH24:MM format

Line 116: location ap_expense_report_lines.LOCATION%type,

112: nFreeDinners3 ap_expense_report_lines.NUM_FREE_DINNERS1%type,
113: nFreeAccommodations1 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
114: nFreeAccommodations2 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
115: nFreeAccommodations3 ap_expense_report_lines.NUM_FREE_ACCOMMODATIONS1%type,
116: location ap_expense_report_lines.LOCATION%type,
117: -- Bug 3600198
118: startTime VARCHAR(5), -- in HH24:MM format
119: endTime VARCHAR(5), -- in HH24:MM format
120: -- Mileage data

Line 121: dailyDistance ap_expense_report_lines.DAILY_DISTANCE%type,

117: -- Bug 3600198
118: startTime VARCHAR(5), -- in HH24:MM format
119: endTime VARCHAR(5), -- in HH24:MM format
120: -- Mileage data
121: dailyDistance ap_expense_report_lines.DAILY_DISTANCE%type,
122: tripDistance ap_expense_report_lines.TRIP_DISTANCE%type,
123: mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,
124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,

Line 122: tripDistance ap_expense_report_lines.TRIP_DISTANCE%type,

118: startTime VARCHAR(5), -- in HH24:MM format
119: endTime VARCHAR(5), -- in HH24:MM format
120: -- Mileage data
121: dailyDistance ap_expense_report_lines.DAILY_DISTANCE%type,
122: tripDistance ap_expense_report_lines.TRIP_DISTANCE%type,
123: mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,
124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126: fuelType ap_expense_report_lines.FUEL_TYPE%type,

Line 123: mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,

119: endTime VARCHAR(5), -- in HH24:MM format
120: -- Mileage data
121: dailyDistance ap_expense_report_lines.DAILY_DISTANCE%type,
122: tripDistance ap_expense_report_lines.TRIP_DISTANCE%type,
123: mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,
124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126: fuelType ap_expense_report_lines.FUEL_TYPE%type,
127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,

Line 124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,

120: -- Mileage data
121: dailyDistance ap_expense_report_lines.DAILY_DISTANCE%type,
122: tripDistance ap_expense_report_lines.TRIP_DISTANCE%type,
123: mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,
124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126: fuelType ap_expense_report_lines.FUEL_TYPE%type,
127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,

Line 125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,

121: dailyDistance ap_expense_report_lines.DAILY_DISTANCE%type,
122: tripDistance ap_expense_report_lines.TRIP_DISTANCE%type,
123: mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,
124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126: fuelType ap_expense_report_lines.FUEL_TYPE%type,
127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,

Line 126: fuelType ap_expense_report_lines.FUEL_TYPE%type,

122: tripDistance ap_expense_report_lines.TRIP_DISTANCE%type,
123: mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,
124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126: fuelType ap_expense_report_lines.FUEL_TYPE%type,
127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130: destinationFrom ap_expense_report_lines_all.destination_from%type,

Line 127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,

123: mileageRate ap_expense_report_lines.AVG_MILEAGE_RATE%type,
124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126: fuelType ap_expense_report_lines.FUEL_TYPE%type,
127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130: destinationFrom ap_expense_report_lines_all.destination_from%type,
131: destinationTo ap_expense_report_lines_all.destination_to%type,

Line 128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,

124: vehicleCategory ap_expense_report_lines.VEHICLE_CATEGORY_CODE%type,
125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126: fuelType ap_expense_report_lines.FUEL_TYPE%type,
127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130: destinationFrom ap_expense_report_lines_all.destination_from%type,
131: destinationTo ap_expense_report_lines_all.destination_to%type,
132: distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,

Line 129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,

125: vehicleType ap_expense_report_lines.VEHICLE_TYPE%type,
126: fuelType ap_expense_report_lines.FUEL_TYPE%type,
127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130: destinationFrom ap_expense_report_lines_all.destination_from%type,
131: destinationTo ap_expense_report_lines_all.destination_to%type,
132: distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,
133: report_line_id ap_expense_report_lines_all.report_line_id%type,

Line 130: destinationFrom ap_expense_report_lines_all.destination_from%type,

126: fuelType ap_expense_report_lines.FUEL_TYPE%type,
127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130: destinationFrom ap_expense_report_lines_all.destination_from%type,
131: destinationTo ap_expense_report_lines_all.destination_to%type,
132: distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,
133: report_line_id ap_expense_report_lines_all.report_line_id%type,
134: itemization_parent_id ap_expense_report_lines_all.itemization_parent_id%type,

Line 131: destinationTo ap_expense_report_lines_all.destination_to%type,

127: numberPassengers ap_expense_report_lines.NUMBER_PEOPLE%type,
128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130: destinationFrom ap_expense_report_lines_all.destination_from%type,
131: destinationTo ap_expense_report_lines_all.destination_to%type,
132: distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,
133: report_line_id ap_expense_report_lines_all.report_line_id%type,
134: itemization_parent_id ap_expense_report_lines_all.itemization_parent_id%type,
135: emp_attendee_count NUMBER, -- Bug 6919132

Line 132: distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,

128: licensePlateNumber ap_expense_report_lines_all.license_plate_number%type,
129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130: destinationFrom ap_expense_report_lines_all.destination_from%type,
131: destinationTo ap_expense_report_lines_all.destination_to%type,
132: distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,
133: report_line_id ap_expense_report_lines_all.report_line_id%type,
134: itemization_parent_id ap_expense_report_lines_all.itemization_parent_id%type,
135: emp_attendee_count NUMBER, -- Bug 6919132
136: nonemp_attendee_count NUMBER -- Bug 6919132

Line 133: report_line_id ap_expense_report_lines_all.report_line_id%type,

129: passengerRateUsed ap_expense_report_lines_all.rate_per_passenger%type,
130: destinationFrom ap_expense_report_lines_all.destination_from%type,
131: destinationTo ap_expense_report_lines_all.destination_to%type,
132: distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,
133: report_line_id ap_expense_report_lines_all.report_line_id%type,
134: itemization_parent_id ap_expense_report_lines_all.itemization_parent_id%type,
135: emp_attendee_count NUMBER, -- Bug 6919132
136: nonemp_attendee_count NUMBER -- Bug 6919132
137: );

Line 134: itemization_parent_id ap_expense_report_lines_all.itemization_parent_id%type,

130: destinationFrom ap_expense_report_lines_all.destination_from%type,
131: destinationTo ap_expense_report_lines_all.destination_to%type,
132: distanceUnitCode ap_expense_report_lines_all.distance_unit_code%type,
133: report_line_id ap_expense_report_lines_all.report_line_id%type,
134: itemization_parent_id ap_expense_report_lines_all.itemization_parent_id%type,
135: emp_attendee_count NUMBER, -- Bug 6919132
136: nonemp_attendee_count NUMBER -- Bug 6919132
137: );
138: