APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_WS_ACCOUNT_LINE_NOTES

Line 3491: ---- Creates or Updates a Note Id in PSB_WS_ACCOUNT_LINE_NOTES table

3487: raise FND_API.G_EXC_ERROR;
3488: end if;
3489:
3490: /* Bug No 1808330 Start */
3491: ---- Creates or Updates a Note Id in PSB_WS_ACCOUNT_LINE_NOTES table
3492:
3493: FND_MESSAGE.SET_NAME('PSB', 'PSB_PARAMETER_NOTE_CREATION');
3494: FND_MESSAGE.SET_TOKEN('NAME', c_AccParam_Rec.name);
3495: FND_MESSAGE.SET_TOKEN('DATE', sysdate);

Line 11765: Insert into PSB_WS_ACCOUNT_LINE_NOTES

11761:
11762: if l_note_id is null then
11763: begin
11764:
11765: Insert into PSB_WS_ACCOUNT_LINE_NOTES
11766: (note_id, note, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
11767: values (psb_ws_account_line_notes_s.nextval, p_note, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
11768: returning note_id into l_note_id;
11769:

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

11763: begin
11764:
11765: Insert into PSB_WS_ACCOUNT_LINE_NOTES
11766: (note_id, note, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
11767: values (psb_ws_account_line_notes_s.nextval, p_note, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
11768: returning note_id into l_note_id;
11769:
11770: if p_account_line_id is not null then
11771: update PSB_BUDGET_REVISION_ACCOUNTS

Line 11784: Update PSB_WS_ACCOUNT_LINE_NOTES

11780: end;
11781: else
11782: -- Bug#4571412
11783: BEGIN
11784: Update PSB_WS_ACCOUNT_LINE_NOTES
11785: SET note = note || FND_GLOBAL.NewLine || p_note,
11786: last_update_date = sysdate,
11787: last_updated_by = FND_GLOBAL.USER_ID,
11788: last_update_login = FND_GLOBAL.LOGIN_ID,