1310: DECODE(p_duration,
1311: null, null,
1312: SYSDATE+p_duration),
1313: SYSDATE,
1314: nvl(fnd_global.user_id, -1),
1315: fnd_global.conc_login_id,
1316: SYSDATE,
1317: nvl(fnd_global.user_id, -1));
1318: END IF; --create_record = true
1311: null, null,
1312: SYSDATE+p_duration),
1313: SYSDATE,
1314: nvl(fnd_global.user_id, -1),
1315: fnd_global.conc_login_id,
1316: SYSDATE,
1317: nvl(fnd_global.user_id, -1));
1318: END IF; --create_record = true
1319:
1313: SYSDATE,
1314: nvl(fnd_global.user_id, -1),
1315: fnd_global.conc_login_id,
1316: SYSDATE,
1317: nvl(fnd_global.user_id, -1));
1318: END IF; --create_record = true
1319:
1320: commit;
1321: END IF;
1365: AP_AUD_AUDIT_REASONS_S.nextval,
1366: p_report_header_id,
1367: p_audit_reason_code,
1368: SYSDATE,
1369: nvl(fnd_global.user_id, -1),
1370: fnd_global.conc_login_id,
1371: SYSDATE,
1372: nvl(fnd_global.user_id, -1));
1373: commit;
1366: p_report_header_id,
1367: p_audit_reason_code,
1368: SYSDATE,
1369: nvl(fnd_global.user_id, -1),
1370: fnd_global.conc_login_id,
1371: SYSDATE,
1372: nvl(fnd_global.user_id, -1));
1373: commit;
1374: END IF;
1368: SYSDATE,
1369: nvl(fnd_global.user_id, -1),
1370: fnd_global.conc_login_id,
1371: SYSDATE,
1372: nvl(fnd_global.user_id, -1));
1373: commit;
1374: END IF;
1375:
1376: END insert_audit_reason;
1406: BEGIN
1407:
1408: IF (p_report_header_id IS NOT NULL AND p_audit_reason_code IS NOT NULL) THEN
1409: UPDATE AP_AUD_AUDIT_REASONS
1410: SET LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
1411: LAST_UPDATE_DATE = SYSDATE,
1412: LAST_UPDATED_BY = nvl(fnd_global.user_id, -1)
1413: WHERE report_header_id = p_report_header_id
1414: AND AUDIT_REASON_CODE = p_audit_reason_code ;
1408: IF (p_report_header_id IS NOT NULL AND p_audit_reason_code IS NOT NULL) THEN
1409: UPDATE AP_AUD_AUDIT_REASONS
1410: SET LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
1411: LAST_UPDATE_DATE = SYSDATE,
1412: LAST_UPDATED_BY = nvl(fnd_global.user_id, -1)
1413: WHERE report_header_id = p_report_header_id
1414: AND AUDIT_REASON_CODE = p_audit_reason_code ;
1415: commit;
1416: END IF;
1994: new_report_line_rec.currency_code := lines_rec.currency_code;
1995: new_report_line_rec.receipt_currency_code := lines_rec.receipt_currency_code;
1996: new_report_line_rec.set_of_books_id := lines_rec.set_of_books_id;
1997: new_report_line_rec.org_id := lines_rec.org_id;
1998: new_report_line_rec.last_update_login := FND_GLOBAL.login_id;
1999: new_report_line_rec.last_updated_by := FND_GLOBAL.user_id;
2000: new_report_line_rec.last_update_date := SYSDATE;
2001: new_report_line_rec.created_by := FND_GLOBAL.user_id;
2002: new_report_line_rec.creation_date := SYSDATE;
1995: new_report_line_rec.receipt_currency_code := lines_rec.receipt_currency_code;
1996: new_report_line_rec.set_of_books_id := lines_rec.set_of_books_id;
1997: new_report_line_rec.org_id := lines_rec.org_id;
1998: new_report_line_rec.last_update_login := FND_GLOBAL.login_id;
1999: new_report_line_rec.last_updated_by := FND_GLOBAL.user_id;
2000: new_report_line_rec.last_update_date := SYSDATE;
2001: new_report_line_rec.created_by := FND_GLOBAL.user_id;
2002: new_report_line_rec.creation_date := SYSDATE;
2003: new_report_line_rec.category_code := 'ROUNDING';
1997: new_report_line_rec.org_id := lines_rec.org_id;
1998: new_report_line_rec.last_update_login := FND_GLOBAL.login_id;
1999: new_report_line_rec.last_updated_by := FND_GLOBAL.user_id;
2000: new_report_line_rec.last_update_date := SYSDATE;
2001: new_report_line_rec.created_by := FND_GLOBAL.user_id;
2002: new_report_line_rec.creation_date := SYSDATE;
2003: new_report_line_rec.category_code := 'ROUNDING';
2004: new_report_line_rec.justification_required_flag := 'N';
2005: