[Home] [Help]
1332: p_xpense_lines.line_type_lookup_code,
1333: p_xpense_lines.reimbursement_currency_code,
1334: p_expLines.receipt_missing_flag,
1335: p_xpense_lines.require_receipt_flag,
1336: AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(p_expLines.justification),
1337: p_expLines.group_value,
1338: p_xpense_lines.date1_temp,
1339: p_xpense_lines.date2_temp,
1340: p_expLines.currency_code,
1460: p_xpense_lines.line_type_lookup_code,
1461: p_xpense_lines.reimbursement_currency_code,
1462: p_expLines.receipt_missing_flag,
1463: p_xpense_lines.require_receipt_flag,
1464: AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(p_expLines.justification),
1465: p_expLines.group_value,
1466: p_xpense_lines.date1_temp,
1467: p_xpense_lines.date2_temp,
1468: p_expLines.currency_code,
2054: DL.ITEMIZATION_PARENT_ID <> -1);
2055:
2056: BEGIN
2057:
2058: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'Start InsertCCLine');
2059:
2060: SELECT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(credit_card_trx_id)
2061: INTO l_clearning_ccid
2062: FROM ap_expense_report_lines erl
2303: AP_WEB_DB_EXPRPT_PKG.CopyAttachments(p_report_line_id,
2304: p_new_report_line_id,
2305: 'OIE_LINE_ATTACHMENTS');
2306:
2307: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end InsertCCLine');
2308:
2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: AP_WEB_DB_UTIL_PKG.RaiseException('InsertCCLine');
2337: AND ITEMIZATION_PARENT_ID = p_source_parent_report_line_id;
2338:
2339: BEGIN
2340:
2341: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
2342: 'start CopyCCItemizationChildLines');
2343:
2344: FOR i in ReportLines LOOP
2345:
2355: p_distribution_line_number => l_NewReportLineID);
2356:
2357: END LOOP;
2358:
2359: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
2360: 'end CopyCCItemizationChildLines');
2361:
2362: EXCEPTION
2363: WHEN OTHERS THEN
3694: l_parent_line_rec update_new_parent_line_amt_c%ROWTYPE;
3695:
3696: BEGIN
3697:
3698: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
3699: 'start CopyItemizationChildLines');
3700: l_lines_total:=0;
3701: -- Find all lines associated with this report
3702: OPEN ReportLines;
4055: WHERE CURRENT OF update_new_parent_line_amt_c;
4056:
4057: CLOSE update_new_parent_line_amt_c;
4058:
4059: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
4060: 'end CopyItemizationChildLines');
4061:
4062: END CopyItemizationChildLines;
4063:
4103: ITEMIZATION_PARENT_ID = -1);
4104:
4105: BEGIN
4106:
4107: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
4108: 'start DuplicateLines');
4109:
4110: -- Find all lines associated with this report
4111: OPEN ReportLines;
4463: END LOOP;
4464:
4465: CLOSE ReportLines;
4466:
4467: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
4468: 'end DuplicateLines');
4469:
4470: END DuplicateLines;
4471:
4474: p_report_header_id IN expLines_headerID) IS
4475: -------------------------------------------------------------------
4476: BEGIN
4477:
4478: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start ResetAPValidationErrors');
4479:
4480: UPDATE ap_expense_report_lines
4481: SET ap_validation_error = ''
4482: WHERE report_header_id = p_report_header_id;
4480: UPDATE ap_expense_report_lines
4481: SET ap_validation_error = ''
4482: WHERE report_header_id = p_report_header_id;
4483:
4484: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end ResetAPValidationErrors');
4485:
4486: EXCEPTION
4487: WHEN NO_DATA_FOUND THEN
4488: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4500: p_ap_validation_error IN expLines_APValidationError) IS
4501: -------------------------------------------------------------------
4502: BEGIN
4503:
4504: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start UpdateAPValidationError');
4505:
4506: /* Bug 3637166 : Doing a substrb before updation */
4507:
4508: UPDATE ap_expense_report_lines
4509: SET ap_validation_error = substrb(ap_validation_error||p_ap_validation_error,1,240)
4510: WHERE report_header_id = p_report_header_id
4511: AND distribution_line_number = p_dist_line_number;
4512:
4513: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end UpdateAPValidationError');
4514:
4515: EXCEPTION
4516: WHEN NO_DATA_FOUND THEN
4517: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4527: p_report_header_id IN expLines_headerID) IS
4528: -------------------------------------------------------------------
4529: BEGIN
4530:
4531: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetAPflags');
4532:
4533: UPDATE ap_expense_report_lines
4534: SET receipt_verified_flag = null,
4535: policy_shortpay_flag = null,
4540: SET audit_code = null, -- Bug 4019412
4541: report_submitted_date = null
4542: WHERE report_header_id = p_report_header_id;
4543:
4544: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetAPflags');
4545:
4546: EXCEPTION
4547: WHEN NO_DATA_FOUND THEN
4548: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
5302: p_report_header_id IN expLines_headerID)
5303: IS
5304:
5305: BEGIN
5306: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start clearAuditReturnReasonInstr');
5307:
5308: UPDATE ap_expense_report_lines aerl
5309: SET aerl.adjustment_reason_copy = aerl.adjustment_reason_code,
5310: aerl.adjustment_reason_code = '',
5378: p_report_header_id IN expLines_headerID) IS
5379: -------------------------------------------------------------------
5380: BEGIN
5381:
5382: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetApplyAdvances');
5383:
5384: -- bug : 4001778/3654956
5385: UPDATE ap_expense_report_headers_all
5386: SET maximum_amount_to_apply = null,
5393: prepay_gl_date = null,
5394: advances_justification = null
5395: WHERE report_header_id = p_report_header_id;
5396:
5397: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetApplyAdvances');
5398:
5399: EXCEPTION
5400: WHEN NO_DATA_FOUND THEN
5401: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');