638: DECODE(aerl.itemization_parent_id,
639: null,AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUDIT_YES_NO','N'),
640: AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUDIT_YES_NO','Y')) itemized_expense_disp
641: FROM ap_expense_report_lines aerl
642: WHERE aerl.report_header_id in (select p_report_header_id from dual
643: union
644: select aerh1.report_header_id
645: from ap_expense_report_headers_all aerh1
646: where aerh1.SHORTPAY_PARENT_ID = p_report_header_id)
2345:
2346: -- Get new ID from sequence
2347: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
2348: INTO l_NewReportLineID
2349: FROM DUAL;
2350:
2351: InsertCCLine(p_new_report_header_id => p_target_report_header_id,
2352: p_report_line_id => i.report_line_id,
2353: p_itemization_parent_id => p_target_parent_report_line_id,
2388:
2389: -- Get new ID from sequence
2390: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
2391: INTO l_NewReportLineID
2392: FROM DUAL;
2393:
2394: InsertCCLine(p_new_report_header_id => p_new_report_id,
2395: p_report_line_id => i.report_line_id,
2396: p_itemization_parent_id => i.itemization_parent_id,
3155: l_debug_info := 'start of AddMileageExpLine';
3156:
3157: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
3158: INTO l_report_line_id
3159: FROM DUAL;
3160:
3161:
3162: INSERT INTO ap_expense_report_lines
3163: (REPORT_HEADER_ID,
3707:
3708: -- Get new ID from sequence
3709: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
3710: INTO l_NewReportLineID
3711: FROM DUAL;
3712:
3713: -- Bug# 9182883: Get the default exchange rates and the allowance rate
3714: AP_WEB_DB_AP_INT_PKG.GetDefaultExchangeRates(l_default_exchange_rates, l_exchange_rate_allowance);
3715:
4116:
4117: -- Get new ID from sequence
4118: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
4119: INTO l_NewReportLineID
4120: FROM DUAL;
4121:
4122: -- Bug# 9182883: Get the default exchange rates and the allowance rate
4123: AP_WEB_DB_AP_INT_PKG.GetDefaultExchangeRates(l_default_exchange_rates, l_exchange_rate_allowance);
4124:
4980: */
4981: p_ccard_amt := l_ccard_amt;
4982: p_total_amt := l_total_amt;
4983:
4984: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_IndividualPay) THEN
4985:
4986: /**
4987: * For individual pay the employee is paying for all the expenses and receiving the reimbursement in cash.
4988: * So the amount due to the employee is the total of the expense report, amount due cc issuer is 0.
4983:
4984: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_IndividualPay) THEN
4985:
4986: /**
4987: * For individual pay the employee is paying for all the expenses and receiving the reimbursement in cash.
4988: * So the amount due to the employee is the total of the expense report, amount due cc issuer is 0.
4989: */
4990: p_emp_amt := l_total_amt;
4991: p_ccard_amt := 0;