DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_PROCESS dependencies on FND_GLOBAL

Line 1431: nvl(fnd_global.user_id, -1),

1427: DECODE(p_duration,
1428: null, null,
1429: SYSDATE+p_duration),
1430: SYSDATE,
1431: nvl(fnd_global.user_id, -1),
1432: fnd_global.conc_login_id,
1433: SYSDATE,
1434: nvl(fnd_global.user_id, -1));
1435: END IF; --create_record = true

Line 1432: fnd_global.conc_login_id,

1428: null, null,
1429: SYSDATE+p_duration),
1430: SYSDATE,
1431: nvl(fnd_global.user_id, -1),
1432: fnd_global.conc_login_id,
1433: SYSDATE,
1434: nvl(fnd_global.user_id, -1));
1435: END IF; --create_record = true
1436:

Line 1434: nvl(fnd_global.user_id, -1));

1430: SYSDATE,
1431: nvl(fnd_global.user_id, -1),
1432: fnd_global.conc_login_id,
1433: SYSDATE,
1434: nvl(fnd_global.user_id, -1));
1435: END IF; --create_record = true
1436:
1437: commit;
1438: END IF;

Line 1486: nvl(fnd_global.user_id, -1),

1482: AP_AUD_AUDIT_REASONS_S.nextval,
1483: p_report_header_id,
1484: p_audit_reason_code,
1485: SYSDATE,
1486: nvl(fnd_global.user_id, -1),
1487: fnd_global.conc_login_id,
1488: SYSDATE,
1489: nvl(fnd_global.user_id, -1));
1490: commit;

Line 1487: fnd_global.conc_login_id,

1483: p_report_header_id,
1484: p_audit_reason_code,
1485: SYSDATE,
1486: nvl(fnd_global.user_id, -1),
1487: fnd_global.conc_login_id,
1488: SYSDATE,
1489: nvl(fnd_global.user_id, -1));
1490: commit;
1491: END IF;

Line 1489: nvl(fnd_global.user_id, -1));

1485: SYSDATE,
1486: nvl(fnd_global.user_id, -1),
1487: fnd_global.conc_login_id,
1488: SYSDATE,
1489: nvl(fnd_global.user_id, -1));
1490: commit;
1491: END IF;
1492:
1493: END insert_audit_reason;

Line 1527: SET LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

1523: BEGIN
1524:
1525: IF (p_report_header_id IS NOT NULL AND p_audit_reason_code IS NOT NULL) THEN
1526: UPDATE AP_AUD_AUDIT_REASONS
1527: SET LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
1528: LAST_UPDATE_DATE = SYSDATE,
1529: LAST_UPDATED_BY = nvl(fnd_global.user_id, -1)
1530: WHERE report_header_id = p_report_header_id
1531: AND AUDIT_REASON_CODE = p_audit_reason_code ;

Line 1529: LAST_UPDATED_BY = nvl(fnd_global.user_id, -1)

1525: IF (p_report_header_id IS NOT NULL AND p_audit_reason_code IS NOT NULL) THEN
1526: UPDATE AP_AUD_AUDIT_REASONS
1527: SET LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
1528: LAST_UPDATE_DATE = SYSDATE,
1529: LAST_UPDATED_BY = nvl(fnd_global.user_id, -1)
1530: WHERE report_header_id = p_report_header_id
1531: AND AUDIT_REASON_CODE = p_audit_reason_code ;
1532: commit;
1533: END IF;

Line 2115: new_report_line_rec.last_update_login := FND_GLOBAL.login_id;

2111: new_report_line_rec.currency_code := lines_rec.currency_code;
2112: new_report_line_rec.receipt_currency_code := lines_rec.receipt_currency_code;
2113: new_report_line_rec.set_of_books_id := lines_rec.set_of_books_id;
2114: new_report_line_rec.org_id := lines_rec.org_id;
2115: new_report_line_rec.last_update_login := FND_GLOBAL.login_id;
2116: new_report_line_rec.last_updated_by := FND_GLOBAL.user_id;
2117: new_report_line_rec.last_update_date := SYSDATE;
2118: new_report_line_rec.created_by := FND_GLOBAL.user_id;
2119: new_report_line_rec.creation_date := SYSDATE;

Line 2116: new_report_line_rec.last_updated_by := FND_GLOBAL.user_id;

2112: new_report_line_rec.receipt_currency_code := lines_rec.receipt_currency_code;
2113: new_report_line_rec.set_of_books_id := lines_rec.set_of_books_id;
2114: new_report_line_rec.org_id := lines_rec.org_id;
2115: new_report_line_rec.last_update_login := FND_GLOBAL.login_id;
2116: new_report_line_rec.last_updated_by := FND_GLOBAL.user_id;
2117: new_report_line_rec.last_update_date := SYSDATE;
2118: new_report_line_rec.created_by := FND_GLOBAL.user_id;
2119: new_report_line_rec.creation_date := SYSDATE;
2120: new_report_line_rec.category_code := 'ROUNDING';

Line 2118: new_report_line_rec.created_by := FND_GLOBAL.user_id;

2114: new_report_line_rec.org_id := lines_rec.org_id;
2115: new_report_line_rec.last_update_login := FND_GLOBAL.login_id;
2116: new_report_line_rec.last_updated_by := FND_GLOBAL.user_id;
2117: new_report_line_rec.last_update_date := SYSDATE;
2118: new_report_line_rec.created_by := FND_GLOBAL.user_id;
2119: new_report_line_rec.creation_date := SYSDATE;
2120: new_report_line_rec.category_code := 'ROUNDING';
2121: new_report_line_rec.justification_required_flag := 'N';
2122: