[Home] [Help]
PACKAGE: APPS.AP_WEB_DB_EXPLINE_PKG
Source
1 PACKAGE AP_WEB_DB_EXPLINE_PKG AS
2 /* $Header: apwdbels.pls 120.33.12000000.2 2007/10/16 12:56:36 sodash ship $ */
3
4 C_InitialDistLineNumber CONSTANT NUMBER := 1000;
5 C_NumDaysRollForward CONSTANT NUMBER := 7;
6 C_Unchanged CONSTANT VARCHAR2(1) := 'U';
7 C_New CONSTANT VARCHAR2(1) := 'N';
8 C_Modified CONSTANT VARCHAR2(1) := 'M';
9 C_Split CONSTANT VARCHAR2(1) := 'S';
10
11 ---------------------------------------------------------------------------------------------------
12 SUBTYPE expLines_headerID IS AP_EXPENSE_REPORT_LINES.report_header_id%TYPE;
13 SUBTYPE expLines_codeCombID IS AP_EXPENSE_REPORT_LINES.code_combination_id%TYPE;
14 SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;
15 SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16 SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17 SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18 SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19 SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20 SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21 SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22 SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23 SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24 SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25 SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26 SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27 SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28 SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29 SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30 SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31 SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32 SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33 SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34 SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35 SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36 SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37 SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38 SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39 SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40 SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41 SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42 SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43 SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44 SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45 SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46 SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47 SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48 SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49 SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50 SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51 SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52 SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53 SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54 SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55 SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56 SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57 SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58 SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59 SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60 SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61 SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62 SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63 SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64 SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65 SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66 SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67 SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68 SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69 SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70 SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71 SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72 SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73 SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74 SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75 SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76 SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77 SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78 SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79 SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80 SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81 SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;
82 SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;
83 SUBTYPE expLines_number_people IS AP_EXPENSE_REPORT_LINES.NUMBER_PEOPLE%TYPE;
84 SUBTYPE expLines_rate_per_passenger IS AP_EXPENSE_REPORT_LINES.RATE_PER_PASSENGER%TYPE;
85 ---------------------------------------------------------------------------------------------------
86
87
88 TYPE CCTrxnCursor IS REF CURSOR;
89 TYPE ReportLinesCursor IS REF CURSOR;
90 TYPE XpenseLinesCursor IS REF CURSOR;
91 TYPE DisplayXpenseLinesCursor IS REF CURSOR;
92 TYPE XpenseLineAcctCursor IS REF CURSOR;
93 TYPE ShortpayXpenseLineCursor IS REF CURSOR;
94 TYPE CCardLinesCursor IS REF CURSOR;
95 TYPE ExpLinesCursor IS REF CURSOR;
96 TYPE ExpLineCCIDCursor IS REF CURSOR;
97
98 -------------------------------------------------------------------
99 TYPE XpenseLineRec IS RECORD (
100 new_report_header_id expLines_headerID,
101 code_combination_id expLines_codeCombID,
102 set_of_books_id expLines_setOfBooksID,
103 item_description expLines_itemDescription,
104 line_type_lookup_code expLines_lineTypeLookupCode,
105 reimbursement_currency_code expLines_currCode,
106 require_receipt_flag expLines_receiptReqdFlag,
107 date1_temp expLines_startExpDate,
108 date2_temp expLines_endExpDate,
109 rate expLines_receiptConvRate,
110 preparer_id expLines_createdBy, -- Bug 875565
111 IsReceiptProjectEnabled expLines_projAcctContext,
112 expenditure_organization_id expLines_expOrgID,
113 company_prepaid_invoice_id expLines_compPrepaidInvID
114 ); /* end TYPE XpenseLineRec */
115 -------------------------------------------------------------------
116 TYPE Mileage_Line_Rec IS RECORD (
117 orig_dist_line_number expLines_distLineNum,
118 new_dist_line_number expLines_distLineNum,
119 report_header_id expLines_headerID,
120 start_date expLines_startExpDate,
121 end_date expLines_endExpDate,
122 number_of_days NUMBER,
123 policy_id AP_POL_LINES.policy_id%TYPE,
124 avg_mileage_rate expLines_avg_mileage_rate,
125 trip_distance expLines_trip_distance,
126 daily_distance expLines_daily_distance,
127 distance_unit_code expLines_distance_unit_code,
128 amount expLines_amount,
129 status VARCHAR2(1) := C_Unchanged,
130 category_code ap_expense_report_params.category_code%TYPE,
131 copy_From expLines_distLineNum,
132 daily_amount expLines_dailyAmount,
133 receipt_currency_amount ap_expense_report_lines.receipt_currency_amount%TYPE,
134 reimbursement_currency_code expLines_currCode,
135 number_people expLines_number_people,
136 web_parameter_id expLines_webParamID,
137 rate_per_passenger expLines_rate_per_passenger,
138 attribute1 expLines_attr1,
139 attribute2 expLines_attr2,
140 attribute3 expLines_attr3,
141 attribute4 expLines_attr4,
142 attribute5 expLines_attr5,
143 attribute6 expLines_attr6,
144 attribute7 expLines_attr7,
145 attribute8 expLines_attr8,
146 attribute9 expLines_attr9,
147 attribute10 expLines_attr10,
148 attribute11 expLines_attr11,
149 attribute12 expLines_attr12,
150 attribute13 expLines_attr13,
151 attribute14 expLines_attr14,
152 attribute15 expLines_attr15,
153 report_line_id ap_expense_report_lines.report_line_id%type
154 ); /* end TYPE Mileage_Line_Rec */
155
156 TYPE Mileage_Line_Array IS TABLE OF Mileage_Line_Rec
157 INDEX BY BINARY_INTEGER;
158
159 -------------------------------------------------------------------
160 FUNCTION GetTrxIdsAndAmtsCursor(p_reportId IN expLines_headerID,
161 p_cc_cursor OUT NOCOPY CCTrxnCursor)
162 RETURN BOOLEAN;
163 -------------------------------------------------------------------
164
165 PROCEDURE FetchReportLineCursor(p_ReportLinesCursor IN OUT NOCOPY ReportLinesCursor,
166 p_expLines IN OUT NOCOPY AP_WEB_DFLEX_PKG.ExpReportLines_A,
167 Attribute_Array IN OUT NOCOPY AP_WEB_PARENT_PKG.BigString_Array,
168 p_ReceiptIndex IN OUT NOCOPY NUMBER,
169 p_Rate OUT NOCOPY expLines_receiptConvRate,
170 p_AmtInclTax OUT NOCOPY expLines_amtInclTaxFlag,
171 p_TaxName OUT NOCOPY expLines_vatCode,
172 p_ExpenditureType OUT NOCOPY expLines_expendType);
173
174 --------------------------------------------------------------------------------
175 FUNCTION GetReportLineCursor(p_reportId IN expLines_headerID,
176 p_line_cursor OUT NOCOPY ReportLinesCursor)
177 RETURN BOOLEAN;
178 --------------------------------------------------------------------------------
179
180 -------------------------------------------------------------------
181 FUNCTION GetDisplayXpenseLinesCursor(
182 p_report_header_id IN expLines_headerID,
183 p_xpense_lines_cursor OUT NOCOPY DisplayXpenseLinesCursor)
184 RETURN BOOLEAN;
185 -------------------------------------------------------------------
186
187 -------------------------------------------------------------------
188 FUNCTION GetDisplayXpenseLinesCursor(
189 p_report_header_id IN expLines_headerID,
190 p_is_cc_lines IN BOOLEAN,
191 p_xpense_lines_cursor OUT NOCOPY DisplayXpenseLinesCursor)
192 RETURN BOOLEAN;
193 -------------------------------------------------------------------
194
195 -------------------------------------------------------------------
196 FUNCTION GetDisplayPersonalLinesCursor(
197 p_report_header_id IN expLines_headerID,
198 p_personal_lines_cursor OUT NOCOPY DisplayXpenseLinesCursor)
199 RETURN BOOLEAN;
200 -------------------------------------------------------------------
201
202 --------------------------------------------------------------------------------------------
203 FUNCTION GetExpDistAcctCursor(p_exp_report_id IN expLines_headerID,
204 p_cursor OUT NOCOPY XpenseLineAcctCursor)
205 RETURN BOOLEAN;
206 --------------------------------------------------------------------------------------------
207
208
209 --------------------------------------------------------------------------------------------
210 FUNCTION CalcNoReceiptsShortpayAmts(
211 p_report_header_id IN expLines_headerID,
212 p_no_receipts_ccard_amt OUT NOCOPY NUMBER,
213 p_no_receipts_emp_amt OUT NOCOPY NUMBER
214 ) RETURN BOOLEAN;
215 --------------------------------------------------------------------------------------------
216
217 --------------------------------------------------------------------------------------------
218 FUNCTION CalcNoReceiptsPersonalTotal(p_report_header_id IN expLines_headerID,
219 p_personal_total OUT NOCOPY NUMBER
220 ) RETURN BOOLEAN;
221 --------------------------------------------------------------------------------------------
222
223 --------------------------------------------------------------------------------------------
224 FUNCTION CalculatePolicyShortpayAmts(
225 p_report_header_id IN expLines_headerID,
226 p_policy_ccard_amt OUT NOCOPY NUMBER,
227 p_policy_emp_amt OUT NOCOPY NUMBER,
228 p_policy_shortpay_total OUT NOCOPY NUMBER
229 ) RETURN BOOLEAN;
230 --------------------------------------------------------------------------------------------
231 FUNCTION GetReceiptMissingTotal(p_report_header_id IN expLines_headerID,
232 p_sum_missing_receipts OUT NOCOPY NUMBER)
233 RETURN BOOLEAN;
234 --------------------------------------------------------------------------------------------
235 FUNCTION GetReceiptViolationsTotal(p_report_header_id IN expLines_headerID,
236 p_sum_violations OUT NOCOPY NUMBER)
237 RETURN BOOLEAN;
238 --------------------------------------------------------------------------------------------
239
240 --------------------------------------------------------------------------------------------
241 FUNCTION GetPersonalTotalOfExpRpt(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
242 p_personal_total OUT NOCOPY NUMBER)
243 RETURN BOOLEAN;
244 --------------------------------------------------------------------------------------------
245
246 --------------------------------------------------------------------------------------------
247 FUNCTION GetNumReceiptRequiredLines(p_report_header_id IN expLines_headerID,
248 p_num_req_receipts OUT NOCOPY NUMBER)
249 RETURN BOOLEAN;
250 --------------------------------------------------------------------------------------------
251
252 --------------------------------------------------------------------------------------------
253 FUNCTION GetNumReceiptShortpaidLines(p_report_header_id IN expLines_headerID,
254 p_num_req_receipt_not_verified OUT NOCOPY NUMBER)
255 RETURN BOOLEAN;
256 --------------------------------------------------------------------------------------------
257
258 --------------------------------------------------------------------------------------------
259 FUNCTION GetNumShortpaidLines(p_report_header_id IN expLines_headerID,
260 p_count OUT NOCOPY NUMBER)
261 RETURN BOOLEAN;
262 --------------------------------------------------------------------------------------------
263
264 --------------------------------------------------------------------------------------------
265 FUNCTION GetNumJustReqdLines(p_report_header_id IN expLines_headerID,
266 p_num_req_receipts OUT NOCOPY NUMBER)
267 RETURN BOOLEAN;
268 --------------------------------------------------------------------------------------------
269
270 --------------------------------------------------------------------------------------------
271 FUNCTION GetNumberOfExpLines(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
272 p_count OUT NOCOPY NUMBER)
273 RETURN BOOLEAN;
274 --------------------------------------------------------------------------------------------
275
276 --------------------------------------------------------------------------------------------
277 FUNCTION GetNumCCLinesIncluded(p_report_header_id IN expLines_headerID,
278 p_crd_card_count OUT NOCOPY NUMBER)
279 RETURN BOOLEAN;
280 --------------------------------------------------------------------------------------------
281
282 --------------------------------------------------------------------------------------------
283 FUNCTION GetNumberOfPersonalLines(p_report_header_id IN expLines_headerID,
284 p_personal_count OUT NOCOPY NUMBER)
285 RETURN BOOLEAN;
286 --------------------------------------------------------------------------------------------
287
288
289
290 --------------------------------------------------------------------------------
291 FUNCTION ContainsProjectRelatedLine(
292 p_ReportHeaderID IN expLines_headerID
293 ) RETURN BOOLEAN;
294
295
296 --------------------------------------------------------------------------------
297 FUNCTION ContainsNonProjectRelatedLine(
301
298 p_ReportHeaderID IN expLines_headerID
299 ) RETURN BOOLEAN;
300 --------------------------------------------------------------------------------
302 --------------------------------------------------------------------------------------------
303 FUNCTION AddReportLines(
304 p_xpense_lines IN XpenseLineRec,
305 p_expLines IN AP_WEB_DFLEX_PKG.ExpReportLineRec,
306 P_AttributeCol IN AP_WEB_PARENT_PKG.BigString_Array,
307 i IN NUMBER
308 ) RETURN BOOLEAN;
309 --------------------------------------------------------------------------------------------
310
311 --------------------------------------------------------------------------------------------
312 FUNCTION AddPolicyShortPaidExpLines(
313 p_new_expense_report_id IN expLines_headerID,
314 p_orig_expense_report_id IN expLines_headerID
315 ) RETURN BOOLEAN;
316 --------------------------------------------------------------------------------------------
317
318 --------------------------------------------------------------------------------------------
319 FUNCTION AddUnverifiedShortpaidLines(
320 p_new_expense_report_id IN expLines_headerID,
321 p_orig_expense_report_id IN expLines_headerID
322 ) RETURN BOOLEAN;
323 --------------------------------------------------------------------------------------------
324
325 --------------------------------------------------------------------------------------------
326 FUNCTION AddCCReportLines(p_report_header_id IN expLines_headerID,
327 p_new_report_id IN expLines_headerID
328 ) RETURN BOOLEAN;
329 --------------------------------------------------------------------------------------------
330
331 --------------------------------------------------------------------------------------------
332 FUNCTION DeleteReportLines(P_ReportID IN expLines_headerID)
333 RETURN BOOLEAN;
334 --------------------------------------------------------------------------------------------
335
336 --------------------------------------------------------------------------------------------
337 FUNCTION DeletePersonalLines(p_report_header_id IN expLines_headerID
338 ) RETURN BOOLEAN;
339 --------------------------------------------------------------------------------------------
340
341 --------------------------------------------------------------------------------------------
342 FUNCTION DeleteCreditReportLines(p_report_header_id IN expLines_headerID)
343 RETURN BOOLEAN;
344 --------------------------------------------------------------------------------------------
345
346 --------------------------------------------------------------------------------------------
347 FUNCTION SetAWTGroupIDAndJustif(p_report_header_id IN expLines_headerID,
348 p_sys_allow_awt_flag IN VARCHAR2,
349 p_ven_allow_awt_flag IN VARCHAR2,
350 p_ven_awt_group_id IN expLines_awtGroupID
351 ) RETURN BOOLEAN;
352 --------------------------------------------------------------------------------------------
353
354 --------------------------------------------------------------------------------------------
355 FUNCTION SetReceiptMissing(p_report_header_id IN expLines_headerID,
356 p_flag IN expLines_receiptMissingFlag)
357 RETURN BOOLEAN;
358 --------------------------------------------------------------------------------------------
359
360 --------------------------------------------------------------------------------------------
361 FUNCTION SetReceiptRequired( p_report_header_id IN expLines_headerID,
362 p_required_flag IN expLines_receiptReqdFlag
363 ) RETURN BOOLEAN;
364 --------------------------------------------------------------------------------------------
365
366 --------------------------------------------------------------------------------
367 FUNCTION GetCCardLineCursor(p_expReportHeaderId IN expLines_headerID,
368 p_cCardLineCursor OUT NOCOPY CCardLinesCursor)
369 RETURN BOOLEAN;
370 --------------------------------------------------------------------------------
371
372 --------------------------------------------------------------------------------
373 PROCEDURE GetCCPrepaidAdjustedInvAmt(p_expReportHeaderId IN NUMBER,
374 p_invAmt IN OUT NOCOPY VARCHAR2);
375 --------------------------------------------------------------------------------
376
377 -------------------------------------------------------------------
378 FUNCTION GetReceiptsMissingFlag( p_report_header_id IN expLines_headerID,
379 p_missing_receipts_flag OUT NOCOPY VARCHAR2 )
380 RETURN BOOLEAN;
381
382 --------------------------------------------------------------------------------
383 FUNCTION GetExpMileageLinesCursor(
384 p_report_header_id IN expLines_headerID,
385 p_mileage_lines_cursor OUT NOCOPY ExpLinesCursor)
386 RETURN BOOLEAN;
387 --------------------------------------------------------------------------------
388 PROCEDURE updateMileageExpLine(
389 p_avg_mileage_rate IN expLines_avg_mileage_rate,
390 p_report_header_id IN expLines_headerID,
391 p_distribution_line_number IN expLines_distLineNum,
392 p_new_dist_line_number IN expLines_distLineNum,
393 p_amount IN expLines_amount,
394 p_trip_distance IN expLines_trip_distance,
395 p_daily_distance IN NUMBER,
396 p_daily_amount IN expLines_dailyAmount,
397 p_receipt_currency_amount IN NUMBER,
398 p_status_code IN expLines_mrate_adj_flag);
399 --------------------------------------------------------------------------------
400 PROCEDURE updateExpenseMileageLines(
401 p_mileage_line_array IN Mileage_Line_Array,
402 p_bUpdatedHeader OUT NOCOPY BOOLEAN
403 );
407 p_new_trip_distance IN NUMBER,
404 --------------------------------------------------------------------------------
405 PROCEDURE AddMileageExpLine(
406 p_new_distribution_line_number IN NUMBER,
408 p_new_daily_distance IN NUMBER,
409 p_new_amount IN NUMBER,
410 p_new_avg_mileage_rate IN NUMBER,
411 p_orig_expense_report_id IN expLines_headerID,
412 p_orig_dist_line_number IN expLines_distLineNum,
413 p_daily_amount IN NUMBER,
414 p_receipt_currency_amount IN NUMBER,
415 x_report_line_id OUT NOCOPY NUMBER
416
417 );
418
419 -------------------------------------------------------------------
420 -- Name: DuplicateLines
421 -- Desc: duplicates Expense Report Lines
422 -- Input: p_source_report_header_id - source expense report header id
423 -- Returns: p_target_report_header_id - target expense report header id
424 -------------------------------------------------------------------
425 PROCEDURE DuplicateLines(
426 p_user_id IN NUMBER,
427 p_source_report_header_id IN expLines_headerID,
428 p_target_report_header_id IN OUT NOCOPY expLines_headerID);
429
430 -------------------------------------------------------------------
431 PROCEDURE ResetAPValidationErrors(
432 p_report_header_id IN expLines_headerID);
433 -------------------------------------------------------------------
434
435 -------------------------------------------------------------------
436 PROCEDURE UpdateAPValidationError(
437 p_report_header_id IN expLines_headerID,
438 p_dist_line_number IN expLines_distLineNum,
439 p_ap_validation_error IN expLines_APValidationError);
440 -------------------------------------------------------------------
441 PROCEDURE resetAPflags(
442 p_report_header_id IN expLines_headerID);
443 -------------------------------------------------------------------
444
445 --------------------------------------------------------------------------------
446 FUNCTION GetNumCashLinesWOMerch(p_report_header_id IN expLines_headerID,
447 p_count OUT NOCOPY NUMBER)
448 RETURN BOOLEAN;
449 --------------------------------------------------------------------------------
450
451 /**
452 * jrautiai ADJ Fix start
453 */
454
455 /**
456 * jrautiai ADJ Fix
457 * Modified GetAdjustmentsCursor to fetch the cursor for both adjustments and
458 * shortpays, this was done to group the logic together and to simplify it.
459 * To do this new cursors and record introduced to store the adjustment
460 * information.
461 */
462 TYPE AdjustmentCursor IS REF CURSOR;
463 TYPE AdjustmentRecordType IS RECORD (
464 report_header_id AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
465 start_expense_date AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE,
466 amount AP_EXPENSE_REPORT_LINES.amount%TYPE,
467 submitted_amount AP_EXPENSE_REPORT_LINES.submitted_amount%TYPE,
468 adjusted_amount NUMBER,
469 web_parameter_id AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE,
470 expense_type_disp VARCHAR2(80),
471 justification AP_EXPENSE_REPORT_LINES.justification%TYPE,
472 adjustment_reason_code AP_EXPENSE_REPORT_LINES.adjustment_reason_code%TYPE,
473 adjustment_reason_code_disp VARCHAR2(80),
474 adjustment_reason_description AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
475 adjustment_reason AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
476 credit_card_expense_disp VARCHAR2(80),
477 itemized_expense_disp VARCHAR2(80)
478 ); /* end TYPE AdjustmentRecordType */
479
480 TYPE AdjustmentCursorType IS REF CURSOR RETURN AdjustmentRecordType;
481
482 /**
483 * jrautiai ADJ Fix
484 * Need the ability to insert a single row, this procedure inserts a row in the
485 * database, using the data provided in the record given as parameter.
486 */
487 PROCEDURE InsertLine(expense_line_rec in AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE);
488
489 /**
490 * rlangi AUDIT
491 * Check to see if there are any line level audit issue
492 */
493 FUNCTION AnyAuditIssue(p_report_header_id IN expLines_headerID)
494 RETURN BOOLEAN;
495
496 /**
497 * jrautiai ADJ Fix
498 * Modified GetAdjustmentsCursor to fetch the cursor for both adjustments and
499 * shortpays, this was done to group the logic together and to simplify it.
500 */
501 FUNCTION GetAdjustmentsCursor(p_report_header_id IN expLines_headerID,
502 p_adjustment_type IN VARCHAR2,
503 p_cursor OUT NOCOPY AdjustmentCursorType)
504 RETURN BOOLEAN;
505
506 /**
507 * jrautiai ADJ Fix
508 * Modified the amount calculating routine to centralize the different payment scenario
509 * calcualations in one place.
510 */
511 FUNCTION CalculateAmtsDue(p_report_header_id IN expLines_headerID,
512 p_payment_due_from IN VARCHAR2,
513 p_emp_amt OUT NOCOPY NUMBER,
514 p_ccard_amt OUT NOCOPY NUMBER,
515 p_total_amt OUT NOCOPY NUMBER
516 ) RETURN BOOLEAN;
517
518 /**
519 * jrautiai ADJ Fix
520 * Check whether a report has been shortpaid, used in the workflow logic to display messages.
521 */
522 FUNCTION GetShortpaidFlag( p_report_header_id IN expLines_headerID,
523 p_shortpaid_flag OUT NOCOPY VARCHAR2 )
524 RETURN BOOLEAN;
525
526 FUNCTION GetNumPolicyShortpaidLines(p_report_header_id IN expLines_headerID,
527 p_count OUT NOCOPY NUMBER)
528 RETURN BOOLEAN;
529
530 FUNCTION GetAdjustedLineExists(p_report_header_id IN expLines_headerID)
531 RETURN BOOLEAN;
532
533 PROCEDURE ResetShortpayAdjustmentInfo(p_report_header_id IN expLines_headerID);
534
535 /**
536 * jrautiai ADJ Fix end
537 */
538
539 --------------------------------------------------------------------------------
540 FUNCTION GetCountyProvince(p_addressstyle IN per_addresses.style%TYPE,
541 p_region IN per_addresses.region_1%TYPE)
542 RETURN VARCHAR2;
543 --------------------------------------------------------------------------------
544
545 --Bug 2944363:Defined two new functions for Personal CC trxn in Both Pay.
546 --AMMISHRA - Both Pay Personal Only Lines project.
547 -------------------------------------------------------------------
548 FUNCTION GetBothPayPersonalLinesCursor(
549 p_report_header_id IN expLines_headerID,
550 p_personal_lines_cursor OUT NOCOPY DisplayXpenseLinesCursor)
551 RETURN BOOLEAN;
552 -------------------------------------------------------------------
553
554 -------------------------------------------------------------------
555 FUNCTION GetNoOfBothPayPersonalLines(p_report_header_id IN expLines_headerID,
556 p_personal_count OUT NOCOPY NUMBER)
557 RETURN BOOLEAN;
558 -------------------------------------------------------------------
559
560 PROCEDURE clearAuditReturnReasonInstr(
561 p_report_header_id IN expLines_headerID);
562 -------------------------------------------------------------------
563 /**
564 * aling
565 * Check to see if there are any policy violation
566 */
567 FUNCTION AnyPolicyViolation(p_report_header_id IN expLines_headerID)
568 RETURN BOOLEAN;
569 ------------------------------------------------------------------------------
570 FUNCTION GetLineCCIDCursor(p_reportId IN expLines_headerID,
571 p_line_cursor OUT NOCOPY ExpLineCCIDCursor)
572 RETURN BOOLEAN;
573
574 -------------------------------------------------------------------
575 PROCEDURE resetApplyAdvances(
576 p_report_header_id IN expLines_headerID);
577 -------------------------------------------------------------------
578
579 FUNCTION ReportInclsCCardLines(p_report_header_id IN NUMBER) RETURN VARCHAR2; -- 5666256: fp of 5464957 when accessing confirmation page from e-mail or comming from DBI
580
581 END AP_WEB_DB_EXPLINE_PKG;