APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_EXPENSE_REPORT_LINES_S

Line 1381: ap_expense_report_lines_s.nextval,

1377: P_AttributeCol(12),
1378: P_AttributeCol(13),
1379: P_AttributeCol(14),
1380: P_AttributeCol(15),
1381: ap_expense_report_lines_s.nextval,
1382: mo_global.get_current_org_id()
1383: FROM ap_expense_report_params
1384: WHERE parameter_id = p_expLines.parameter_id;
1385:

Line 1508: ap_expense_report_lines_s.nextval,

1504: P_AttributeCol(12),
1505: P_AttributeCol(13),
1506: P_AttributeCol(14),
1507: P_AttributeCol(15),
1508: ap_expense_report_lines_s.nextval,
1509: mo_global.get_current_org_id() );
1510: END IF;
1511:
1512: RETURN TRUE;

Line 2098: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

2094:
2095: FOR i in ReportLines LOOP
2096:
2097: -- Get new ID from sequence
2098: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
2099: INTO l_NewReportLineID
2100: FROM DUAL;
2101:
2102: InsertCCLine(p_new_report_header_id => p_target_report_header_id,

Line 2141: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

2137:
2138: for i in CCReportLines loop
2139:
2140: -- Get new ID from sequence
2141: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
2142: INTO l_NewReportLineID
2143: FROM DUAL;
2144:
2145: InsertCCLine(p_new_report_header_id => p_new_report_id,

Line 2872: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

2868: BEGIN
2869:
2870: l_debug_info := 'start of AddMileageExpLine';
2871:
2872: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
2873: INTO l_report_line_id
2874: FROM DUAL;
2875:
2876:

Line 3422: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

3418: FETCH ReportLines into l_TempReportLineID, l_from_currency_code, l_to_currency_code, l_exchange_date, l_amount;
3419: EXIT WHEN ReportLines%NOTFOUND;
3420:
3421: -- Get new ID from sequence
3422: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
3423: INTO l_NewReportLineID
3424: FROM DUAL;
3425:
3426: -- Bug 6689280 (sodash)

Line 3818: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

3814: FETCH ReportLines into l_TempReportLineID,l_itemization_parent_id,l_from_currency_code, l_to_currency_code, l_exchange_date, l_amount;
3815: EXIT WHEN ReportLines%NOTFOUND;
3816:
3817: -- Get new ID from sequence
3818: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
3819: INTO l_NewReportLineID
3820: FROM DUAL;
3821:
3822: -- Bug 6689280 (sodash)

Line 4577: ap_expense_report_lines_s.nextval);

4573: expense_line_rec.CATEGORY_CODE,
4574: expense_line_rec.ADJUSTMENT_REASON_CODE,
4575: expense_line_rec.AP_VALIDATION_ERROR,
4576: expense_line_rec.SUBMITTED_AMOUNT,
4577: ap_expense_report_lines_s.nextval);
4578:
4579: EXCEPTION
4580: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
4581: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine','',