APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_EXPENSE_REPORT_LINES_S

Line 1386: ap_expense_report_lines_s.nextval,

1382: P_AttributeCol(12),
1383: P_AttributeCol(13),
1384: P_AttributeCol(14),
1385: P_AttributeCol(15),
1386: ap_expense_report_lines_s.nextval,
1387: mo_global.get_current_org_id()
1388: FROM ap_expense_report_params
1389: WHERE parameter_id = p_expLines.parameter_id;
1390:

Line 1513: ap_expense_report_lines_s.nextval,

1509: P_AttributeCol(12),
1510: P_AttributeCol(13),
1511: P_AttributeCol(14),
1512: P_AttributeCol(15),
1513: ap_expense_report_lines_s.nextval,
1514: mo_global.get_current_org_id() );
1515: END IF;
1516:
1517: RETURN TRUE;

Line 2347: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

2343:
2344: FOR i in ReportLines LOOP
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,

Line 2390: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

2386:
2387: for i in CCReportLines loop
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,

Line 3157: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

3153: BEGIN
3154:
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:

Line 3709: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

3705: FETCH ReportLines into l_TempReportLineID, l_from_currency_code, l_to_currency_code, l_exchange_date, l_amount;
3706: EXIT WHEN ReportLines%NOTFOUND;
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

Line 4118: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL

4114: FETCH ReportLines into l_TempReportLineID,l_itemization_parent_id,l_from_currency_code, l_to_currency_code, l_exchange_date, l_amount;
4115: EXIT WHEN ReportLines%NOTFOUND;
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

Line 4891: ap_expense_report_lines_s.nextval);

4887: expense_line_rec.CATEGORY_CODE,
4888: expense_line_rec.ADJUSTMENT_REASON_CODE,
4889: expense_line_rec.AP_VALIDATION_ERROR,
4890: expense_line_rec.SUBMITTED_AMOUNT,
4891: ap_expense_report_lines_s.nextval);
4892:
4893: EXCEPTION
4894: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
4895: AP_WEB_DB_UTIL_PKG.RaiseException('InsertLine','',