DBA Data[Home] [Help]

APPS.IGS_PE_PERS_RELATION_PKG dependencies on IGS_SC_GEN_001

Line 355: igs_sc_gen_001.set_ctx('R');

351: x_last_update_login=>X_LAST_UPDATE_LOGIN
352: );
353:
354: IF (x_mode = 'S') THEN
355: igs_sc_gen_001.set_ctx('R');
356: END IF;
357: insert into IGS_PE_PERS_RELATION (
358: PERSON_ID,
359: PERSON_ID_ALSO_RELATED_TO,

Line 377: igs_sc_gen_001.unset_ctx('R');

373: X_LAST_UPDATED_BY,
374: X_LAST_UPDATE_LOGIN
375: );
376: IF (x_mode = 'S') THEN
377: igs_sc_gen_001.unset_ctx('R');
378: END IF;
379:
380:
381: open c;

Line 399: igs_sc_gen_001.unset_ctx('R');

395: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
396: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
397: fnd_message.set_token ('ERR_CD', SQLCODE);
398: igs_ge_msg_stack.add;
399: igs_sc_gen_001.unset_ctx('R');
400: app_exception.raise_exception;
401: ELSE
402: igs_sc_gen_001.unset_ctx('R');
403: RAISE;

Line 402: igs_sc_gen_001.unset_ctx('R');

398: igs_ge_msg_stack.add;
399: igs_sc_gen_001.unset_ctx('R');
400: app_exception.raise_exception;
401: ELSE
402: igs_sc_gen_001.unset_ctx('R');
403: RAISE;
404: END IF;
405:
406: end INSERT_ROW;

Line 446: igs_sc_gen_001.set_ctx('R');

442: p_action => 'DELETE',
443: x_rowid => X_ROWID
444: );
445: IF (x_mode = 'S') THEN
446: igs_sc_gen_001.set_ctx('R');
447: END IF;
448: delete from IGS_PE_PERS_RELATION
449: where ROWID = X_ROWID;
450: if (sql%notfound) then

Line 453: igs_sc_gen_001.unset_ctx('R');

449: where ROWID = X_ROWID;
450: if (sql%notfound) then
451: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
452: igs_ge_msg_stack.add;
453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;
455: end if;
456: IF (x_mode = 'S') THEN
457: igs_sc_gen_001.unset_ctx('R');

Line 457: igs_sc_gen_001.unset_ctx('R');

453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;
455: end if;
456: IF (x_mode = 'S') THEN
457: igs_sc_gen_001.unset_ctx('R');
458: END IF;
459:
460: After_DML(
461: p_action => 'DELETE',