153: new_references.sequence_number,
154: new_references.acad_intent_code,
155: 'Y',
156: SYSDATE,
157: fnd_global.user_id,
158: SYSDATE,
159: fnd_global.user_id,
160: fnd_global.login_id ) RETURNING acad_intent_id INTO ln_acad_intent_id;
161:
155: 'Y',
156: SYSDATE,
157: fnd_global.user_id,
158: SYSDATE,
159: fnd_global.user_id,
160: fnd_global.login_id ) RETURNING acad_intent_id INTO ln_acad_intent_id;
161:
162: IGS_PE_WF_GEN.raise_acad_intent_event(P_ACAD_INTENT_ID => ln_acad_intent_id,
163: P_PERSON_ID=> new_references.person_id,
156: SYSDATE,
157: fnd_global.user_id,
158: SYSDATE,
159: fnd_global.user_id,
160: fnd_global.login_id ) RETURNING acad_intent_id INTO ln_acad_intent_id;
161:
162: IGS_PE_WF_GEN.raise_acad_intent_event(P_ACAD_INTENT_ID => ln_acad_intent_id,
163: P_PERSON_ID=> new_references.person_id,
164: P_CAL_TYPE=>new_references.cal_type,
340: IF (x_mode = 'I') THEN
341: x_last_updated_by := 1;
342: x_last_update_login := 0;
343: ELSIF (x_mode IN ('R','S')) THEN
344: x_last_updated_by := fnd_global.user_id;
345: IF (x_last_updated_by IS NULL) THEN
346: x_last_updated_by := -1;
347: END IF;
348: x_last_update_login := fnd_global.login_id;
344: x_last_updated_by := fnd_global.user_id;
345: IF (x_last_updated_by IS NULL) THEN
346: x_last_updated_by := -1;
347: END IF;
348: x_last_update_login := fnd_global.login_id;
349: IF (x_last_update_login IS NULL) THEN
350: x_last_update_login := -1;
351: END IF;
352: ELSE
522: IF (X_MODE = 'I') THEN
523: x_last_updated_by := 1;
524: x_last_update_login := 0;
525: ELSIF (x_mode IN ('R','S')) THEN
526: x_last_updated_by := fnd_global.user_id;
527: IF x_last_updated_by IS NULL THEN
528: x_last_updated_by := -1;
529: END IF;
530: x_last_update_login := fnd_global.login_id;
526: x_last_updated_by := fnd_global.user_id;
527: IF x_last_updated_by IS NULL THEN
528: x_last_updated_by := -1;
529: END IF;
530: x_last_update_login := fnd_global.login_id;
531: IF (x_last_update_login IS NULL) THEN
532: x_last_update_login := -1;
533: END IF;
534: ELSE