APPS.PSB_WS_ACCT1 dependencies on PSB_WS_ACCOUNT_LINE_NOTES

Line 7230: -- PSB_WS_ACCOUNT_LINE_NOTES fails.

7226:
7227: -- Bug#4571412
7228: -- Added parameters p_char_of_accounts_id, p_budget_year, p_cc_id
7229: -- to explain newly created message if update statment for
7230: -- PSB_WS_ACCOUNT_LINE_NOTES fails.
7231:
7232: -- API created for Bug#1584464
7233: PROCEDURE Create_Note
7234: ( p_return_status OUT NOCOPY VARCHAR2,

Line 7272: Insert into PSB_WS_ACCOUNT_LINE_NOTES

7268:
7269: if l_note_id is null then
7270: begin
7271:
7272: Insert into PSB_WS_ACCOUNT_LINE_NOTES
7273: (note_id, note, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
7274: values (psb_ws_account_line_notes_s.nextval, p_note, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
7275: returning note_id into l_note_id;
7276:

Line 7274: values (psb_ws_account_line_notes_s.nextval, p_note, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)

7270: begin
7271:
7272: Insert into PSB_WS_ACCOUNT_LINE_NOTES
7273: (note_id, note, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
7274: values (psb_ws_account_line_notes_s.nextval, p_note, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
7275: returning note_id into l_note_id;
7276:
7277: update PSB_WS_ACCOUNT_LINES
7278: set note_id = l_note_id

Line 7284: UPDATE PSB_WS_ACCOUNT_LINE_NOTES

7280:
7281: end;
7282: else
7283: BEGIN
7284: UPDATE PSB_WS_ACCOUNT_LINE_NOTES
7285: SET note = note || FND_GLOBAL.NewLine || p_note,
7286: last_update_date = sysdate,
7287: last_updated_by = FND_GLOBAL.USER_ID,
7288: last_update_login = FND_GLOBAL.LOGIN_ID,