APPS.PA_PERIOD_MASKS_PUB dependencies on FND_GLOBAL

Line 194: FND_GLOBAL.USER_ID,

190: p_effective_start_date,
191: p_effective_end_date,
192: p_time_phase_code,
193: sysdate,
194: FND_GLOBAL.USER_ID,
195: FND_GLOBAL.LOGIN_ID,
196: FND_GLOBAL.LOGIN_ID,
197: sysdate,
198: 1,

Line 195: FND_GLOBAL.LOGIN_ID,

191: p_effective_end_date,
192: p_time_phase_code,
193: sysdate,
194: FND_GLOBAL.USER_ID,
195: FND_GLOBAL.LOGIN_ID,
196: FND_GLOBAL.LOGIN_ID,
197: sysdate,
198: 1,
199: 'N');

Line 196: FND_GLOBAL.LOGIN_ID,

192: p_time_phase_code,
193: sysdate,
194: FND_GLOBAL.USER_ID,
195: FND_GLOBAL.LOGIN_ID,
196: FND_GLOBAL.LOGIN_ID,
197: sysdate,
198: 1,
199: 'N');
200: /*populating table pa_period_masks_tl*/

Line 218: FND_GLOBAL.LOGIN_ID,

214: p_description,
215: L.LANGUAGE_CODE, /* Bug 6275098*/
216: l_language,
217: sysdate,
218: FND_GLOBAL.LOGIN_ID,
219: sysdate,
220: FND_GLOBAL.USER_ID,
221: FND_GLOBAL.LOGIN_ID /*Changes for Bug 6275098 */
222: from FND_LANGUAGES L where L.INSTALLED_FLAG in ('I', 'B')

Line 220: FND_GLOBAL.USER_ID,

216: l_language,
217: sysdate,
218: FND_GLOBAL.LOGIN_ID,
219: sysdate,
220: FND_GLOBAL.USER_ID,
221: FND_GLOBAL.LOGIN_ID /*Changes for Bug 6275098 */
222: from FND_LANGUAGES L where L.INSTALLED_FLAG in ('I', 'B')
223: and not exists
224: (select null from PA_PERIOD_MASKS_TL T

Line 221: FND_GLOBAL.LOGIN_ID /*Changes for Bug 6275098 */

217: sysdate,
218: FND_GLOBAL.LOGIN_ID,
219: sysdate,
220: FND_GLOBAL.USER_ID,
221: FND_GLOBAL.LOGIN_ID /*Changes for Bug 6275098 */
222: from FND_LANGUAGES L where L.INSTALLED_FLAG in ('I', 'B')
223: and not exists
224: (select null from PA_PERIOD_MASKS_TL T
225: where T.PERIOD_MASK_ID = l_period_masks_s

Line 272: last_update_login = FND_GLOBAL.LOGIN_ID,

268: UPDATE pa_period_masks_b
269: SET effective_start_date = p_effective_start_date,
270: effective_end_date = p_effective_end_date,
271: time_phase_code = p_time_phase_code,
272: last_update_login = FND_GLOBAL.LOGIN_ID,
273: last_updated_by = FND_GLOBAL.LOGIN_ID,
274: last_update_date = sysdate,
275: record_version_number = record_version_number + 1
276: WHERE period_mask_id = p_period_mask_id

Line 273: last_updated_by = FND_GLOBAL.LOGIN_ID,

269: SET effective_start_date = p_effective_start_date,
270: effective_end_date = p_effective_end_date,
271: time_phase_code = p_time_phase_code,
272: last_update_login = FND_GLOBAL.LOGIN_ID,
273: last_updated_by = FND_GLOBAL.LOGIN_ID,
274: last_update_date = sysdate,
275: record_version_number = record_version_number + 1
276: WHERE period_mask_id = p_period_mask_id
277: and record_version_number = p_record_version_number;

Line 293: last_update_login = FND_GLOBAL.LOGIN_ID,

289:
290: UPDATE pa_period_masks_tl
291: SET name = p_name,
292: description = p_description,
293: last_update_login = FND_GLOBAL.LOGIN_ID,
294: last_updated_by = FND_GLOBAL.LOGIN_ID,
295: last_update_date = sysdate
296: WHERE period_mask_id = p_period_mask_id;
297:

Line 294: last_updated_by = FND_GLOBAL.LOGIN_ID,

290: UPDATE pa_period_masks_tl
291: SET name = p_name,
292: description = p_description,
293: last_update_login = FND_GLOBAL.LOGIN_ID,
294: last_updated_by = FND_GLOBAL.LOGIN_ID,
295: last_update_date = sysdate
296: WHERE period_mask_id = p_period_mask_id;
297:
298:

Line 560: FND_GLOBAL.USER_ID,

556: from_anchor_start,
557: from_anchor_end,
558: from_anchor_position,
559: sysdate,
560: FND_GLOBAL.USER_ID,
561: FND_GLOBAL.LOGIN_ID,
562: FND_GLOBAL.LOGIN_ID,
563: sysdate FROM pa_fp_period_mask_tmp );
564:

Line 561: FND_GLOBAL.LOGIN_ID,

557: from_anchor_end,
558: from_anchor_position,
559: sysdate,
560: FND_GLOBAL.USER_ID,
561: FND_GLOBAL.LOGIN_ID,
562: FND_GLOBAL.LOGIN_ID,
563: sysdate FROM pa_fp_period_mask_tmp );
564:
565:

Line 562: FND_GLOBAL.LOGIN_ID,

558: from_anchor_position,
559: sysdate,
560: FND_GLOBAL.USER_ID,
561: FND_GLOBAL.LOGIN_ID,
562: FND_GLOBAL.LOGIN_ID,
563: sysdate FROM pa_fp_period_mask_tmp );
564:
565:
566: IF (SQL%NOTFOUND) THEN