APPS.IGS_PE_VOTE_INFO_PKG dependencies on IGS_SC_GEN_001

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

493: x_last_update_login=>X_LAST_UPDATE_LOGIN,
494: x_org_id=>igs_ge_gen_003.get_org_id
495: );
496: IF (x_mode = 'S') THEN
497: igs_sc_gen_001.set_ctx('R');
498: END IF;
499: insert into igs_pe_vote_info_all (
500: VOTER_ID
501: ,PERSON_ID

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

525: ,X_LAST_UPDATE_LOGIN
526: ,NEW_REFERENCES.ORG_ID
527: );
528: IF (x_mode = 'S') THEN
529: igs_sc_gen_001.unset_ctx('R');
530: END IF;
531:
532: open c;
533: fetch c into X_ROWID;

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

544: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
545: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
546: fnd_message.set_token ('ERR_CD', SQLCODE);
547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: ELSE
551: igs_sc_gen_001.unset_ctx('R');
552: RAISE;

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

547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: ELSE
551: igs_sc_gen_001.unset_ctx('R');
552: RAISE;
553: END IF;
554:
555: end INSERT_ROW;

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

702: x_last_update_date=>X_LAST_UPDATE_DATE,
703: x_last_updated_by=>X_LAST_UPDATED_BY,
704: x_last_update_login=>X_LAST_UPDATE_LOGIN);
705: IF (x_mode = 'S') THEN
706: igs_sc_gen_001.set_ctx('R');
707: END IF;
708: update igs_pe_vote_info_all set
709: PERSON_ID = NEW_REFERENCES.PERSON_ID,
710: VOTER_INFO = NEW_REFERENCES.VOTER_INFO,

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

718: where ROWID = X_ROWID;
719: if (sql%notfound) then
720: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
721: igs_ge_msg_stack.add;
722: igs_sc_gen_001.unset_ctx('R');
723: app_exception.raise_exception;
724: end if;
725: IF (x_mode = 'S') THEN
726: igs_sc_gen_001.unset_ctx('R');

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

722: igs_sc_gen_001.unset_ctx('R');
723: app_exception.raise_exception;
724: end if;
725: IF (x_mode = 'S') THEN
726: igs_sc_gen_001.unset_ctx('R');
727: END IF;
728:
729:
730: After_DML (

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

736: IF (SQLCODE = (-28115)) THEN
737: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
738: fnd_message.set_token ('ERR_CD', SQLCODE);
739: igs_ge_msg_stack.add;
740: igs_sc_gen_001.unset_ctx('R');
741: app_exception.raise_exception;
742: ELSE
743: igs_sc_gen_001.unset_ctx('R');
744: RAISE;

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

739: igs_ge_msg_stack.add;
740: igs_sc_gen_001.unset_ctx('R');
741: app_exception.raise_exception;
742: ELSE
743: igs_sc_gen_001.unset_ctx('R');
744: RAISE;
745: END IF;
746:
747: end UPDATE_ROW;

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

820: p_action => 'DELETE',
821: x_rowid => X_ROWID
822: );
823: IF (x_mode = 'S') THEN
824: igs_sc_gen_001.set_ctx('R');
825: END IF;
826: delete from igs_pe_vote_info_all
827: where ROWID = X_ROWID;
828: if (sql%notfound) then

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

827: where ROWID = X_ROWID;
828: if (sql%notfound) then
829: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
830: igs_ge_msg_stack.add;
831: igs_sc_gen_001.unset_ctx('R');
832: app_exception.raise_exception;
833: end if;
834: IF (x_mode = 'S') THEN
835: igs_sc_gen_001.unset_ctx('R');

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

831: igs_sc_gen_001.unset_ctx('R');
832: app_exception.raise_exception;
833: end if;
834: IF (x_mode = 'S') THEN
835: igs_sc_gen_001.unset_ctx('R');
836: END IF;
837:
838: After_DML (
839: p_action => 'DELETE',