[Home] [Help]
1327: p_xpense_lines.line_type_lookup_code,
1328: p_xpense_lines.reimbursement_currency_code,
1329: p_expLines.receipt_missing_flag,
1330: p_xpense_lines.require_receipt_flag,
1331: AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(p_expLines.justification),
1332: p_expLines.group_value,
1333: p_xpense_lines.date1_temp,
1334: p_xpense_lines.date2_temp,
1335: p_expLines.currency_code,
1455: p_xpense_lines.line_type_lookup_code,
1456: p_xpense_lines.reimbursement_currency_code,
1457: p_expLines.receipt_missing_flag,
1458: p_xpense_lines.require_receipt_flag,
1459: AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(p_expLines.justification),
1460: p_expLines.group_value,
1461: p_xpense_lines.date1_temp,
1462: p_xpense_lines.date2_temp,
1463: p_expLines.currency_code,
1810: DL.ITEMIZATION_PARENT_ID <> -1);
1811:
1812: BEGIN
1813:
1814: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'Start InsertCCLine');
1815:
1816: SELECT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(credit_card_trx_id)
1817: INTO l_clearning_ccid
1818: FROM ap_expense_report_lines erl
2054: END LOOP;
2055: CLOSE copy_dist;
2056:
2057:
2058: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end InsertCCLine');
2059:
2060: EXCEPTION
2061: WHEN OTHERS THEN
2062: AP_WEB_DB_UTIL_PKG.RaiseException('InsertCCLine');
2088: AND ITEMIZATION_PARENT_ID = p_source_parent_report_line_id;
2089:
2090: BEGIN
2091:
2092: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
2093: 'start CopyCCItemizationChildLines');
2094:
2095: FOR i in ReportLines LOOP
2096:
2106: p_distribution_line_number => l_NewReportLineID);
2107:
2108: END LOOP;
2109:
2110: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
2111: 'end CopyCCItemizationChildLines');
2112:
2113: EXCEPTION
2114: WHEN OTHERS THEN
3407: l_parent_line_rec update_new_parent_line_amt_c%ROWTYPE;
3408:
3409: BEGIN
3410:
3411: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
3412: 'start CopyItemizationChildLines');
3413: l_lines_total:=0;
3414: -- Find all lines associated with this report
3415: OPEN ReportLines;
3757: WHERE CURRENT OF update_new_parent_line_amt_c;
3758:
3759: CLOSE update_new_parent_line_amt_c;
3760:
3761: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
3762: 'end CopyItemizationChildLines');
3763:
3764: END CopyItemizationChildLines;
3765:
3803: ITEMIZATION_PARENT_ID = -1);
3804:
3805: BEGIN
3806:
3807: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
3808: 'start DuplicateLines');
3809:
3810: -- Find all lines associated with this report
3811: OPEN ReportLines;
4149: END LOOP;
4150:
4151: CLOSE ReportLines;
4152:
4153: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG',
4154: 'end DuplicateLines');
4155:
4156: END DuplicateLines;
4157:
4160: p_report_header_id IN expLines_headerID) IS
4161: -------------------------------------------------------------------
4162: BEGIN
4163:
4164: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start ResetAPValidationErrors');
4165:
4166: UPDATE ap_expense_report_lines
4167: SET ap_validation_error = ''
4168: WHERE report_header_id = p_report_header_id;
4166: UPDATE ap_expense_report_lines
4167: SET ap_validation_error = ''
4168: WHERE report_header_id = p_report_header_id;
4169:
4170: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end ResetAPValidationErrors');
4171:
4172: EXCEPTION
4173: WHEN NO_DATA_FOUND THEN
4174: AP_WEB_DB_UTIL_PKG.RaiseException('ResetAPValidationErrors');
4186: p_ap_validation_error IN expLines_APValidationError) IS
4187: -------------------------------------------------------------------
4188: BEGIN
4189:
4190: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start UpdateAPValidationError');
4191:
4192: /* Bug 3637166 : Doing a substrb before updation */
4193:
4194: UPDATE ap_expense_report_lines
4195: SET ap_validation_error = substrb(ap_validation_error||p_ap_validation_error,1,240)
4196: WHERE report_header_id = p_report_header_id
4197: AND distribution_line_number = p_dist_line_number;
4198:
4199: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end UpdateAPValidationError');
4200:
4201: EXCEPTION
4202: WHEN NO_DATA_FOUND THEN
4203: AP_WEB_DB_UTIL_PKG.RaiseException('UpdateAPValidationError');
4213: p_report_header_id IN expLines_headerID) IS
4214: -------------------------------------------------------------------
4215: BEGIN
4216:
4217: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetAPflags');
4218:
4219: UPDATE ap_expense_report_lines
4220: SET receipt_verified_flag = null,
4221: policy_shortpay_flag = null,
4226: SET audit_code = null, -- Bug 4019412
4227: report_submitted_date = null
4228: WHERE report_header_id = p_report_header_id;
4229:
4230: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetAPflags');
4231:
4232: EXCEPTION
4233: WHEN NO_DATA_FOUND THEN
4234: AP_WEB_DB_UTIL_PKG.RaiseException('resetAPflags');
4987: p_report_header_id IN expLines_headerID)
4988: IS
4989:
4990: BEGIN
4991: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start clearAuditReturnReasonInstr');
4992:
4993: UPDATE ap_expense_report_lines aerl
4994: SET aerl.adjustment_reason_code = '',
4995: aerl.adjustment_reason = '',
5062: p_report_header_id IN expLines_headerID) IS
5063: -------------------------------------------------------------------
5064: BEGIN
5065:
5066: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'start resetApplyAdvances');
5067:
5068: -- bug : 4001778/3654956
5069: UPDATE ap_expense_report_headers_all
5070: SET maximum_amount_to_apply = null,
5077: prepay_gl_date = null,
5078: advances_justification = null
5079: WHERE report_header_id = p_report_header_id;
5080:
5081: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPLINE_PKG', 'end resetApplyAdvances');
5082:
5083: EXCEPTION
5084: WHEN NO_DATA_FOUND THEN
5085: AP_WEB_DB_UTIL_PKG.RaiseException('resetApplyAdvances');