DBA Data[Home] [Help]

APPS.PSB_WS_ACCT1 dependencies on FND_GLOBAL

Line 948: l_userid := FND_GLOBAL.USER_ID;

944: then
945: raise FND_API.G_EXC_UNEXPECTED_ERROR;
946: end if;
947:
948: l_userid := FND_GLOBAL.USER_ID;
949: l_loginid := FND_GLOBAL.LOGIN_ID;
950: l_requestid := FND_GLOBAL.CONC_REQUEST_ID;
951:
952: -- Substitute default values for parameters that were not passed in

Line 949: l_loginid := FND_GLOBAL.LOGIN_ID;

945: raise FND_API.G_EXC_UNEXPECTED_ERROR;
946: end if;
947:
948: l_userid := FND_GLOBAL.USER_ID;
949: l_loginid := FND_GLOBAL.LOGIN_ID;
950: l_requestid := FND_GLOBAL.CONC_REQUEST_ID;
951:
952: -- Substitute default values for parameters that were not passed in
953:

Line 950: l_requestid := FND_GLOBAL.CONC_REQUEST_ID;

946: end if;
947:
948: l_userid := FND_GLOBAL.USER_ID;
949: l_loginid := FND_GLOBAL.LOGIN_ID;
950: l_requestid := FND_GLOBAL.CONC_REQUEST_ID;
951:
952: -- Substitute default values for parameters that were not passed in
953:
954: if ((nvl(p_gl_cutoff_period, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) or

Line 2878: l_userid := FND_GLOBAL.USER_ID;

2874: (l_start_stage_seq = l_current_stage_seq)) then
2875: l_new_stage := FALSE;
2876: end if;
2877:
2878: l_userid := FND_GLOBAL.USER_ID;
2879: l_loginid := FND_GLOBAL.LOGIN_ID;
2880:
2881: if ((FND_API.to_Boolean(p_check_stages)) and
2882: (l_new_stage) and

Line 2879: l_loginid := FND_GLOBAL.LOGIN_ID;

2875: l_new_stage := FALSE;
2876: end if;
2877:
2878: l_userid := FND_GLOBAL.USER_ID;
2879: l_loginid := FND_GLOBAL.LOGIN_ID;
2880:
2881: if ((FND_API.to_Boolean(p_check_stages)) and
2882: (l_new_stage) and
2883: (l_start_stage_seq < l_current_stage_seq)) then

Line 6709: l_userid := FND_GLOBAL.USER_ID;

6705: else
6706: p_constraint_validation_status := 'E';
6707: end if;
6708:
6709: l_userid := FND_GLOBAL.USER_ID;
6710: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
6711:
6712: message_token('CONSTRAINT_SET', p_constraint_set_name);
6713: message_token('THRESHOLD', p_constraint_threshold);

Line 6710: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;

6706: p_constraint_validation_status := 'E';
6707: end if;
6708:
6709: l_userid := FND_GLOBAL.USER_ID;
6710: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
6711:
6712: message_token('CONSTRAINT_SET', p_constraint_set_name);
6713: message_token('THRESHOLD', p_constraint_threshold);
6714: message_token('CONSTRAINT', p_constraint_name);

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 7285: SET note = note || FND_GLOBAL.NewLine || p_note,

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,
7289: created_by = FND_GLOBAL.USER_ID,

Line 7287: last_updated_by = FND_GLOBAL.USER_ID,

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,
7289: created_by = FND_GLOBAL.USER_ID,
7290: creation_date = sysdate
7291: WHERE note_id = l_note_id;

Line 7288: last_update_login = FND_GLOBAL.LOGIN_ID,

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,
7289: created_by = FND_GLOBAL.USER_ID,
7290: creation_date = sysdate
7291: WHERE note_id = l_note_id;
7292:

Line 7289: created_by = FND_GLOBAL.USER_ID,

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,
7289: created_by = FND_GLOBAL.USER_ID,
7290: creation_date = sysdate
7291: WHERE note_id = l_note_id;
7292:
7293: -- Bug#4571412