APPS.IGS_PR_MILESTONE_PKG dependencies on IGS_SC_GEN_001

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

705: x_last_update_login =>x_last_update_login,
706: x_org_id=>igs_ge_gen_003.get_org_id
707: ) ;
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.set_ctx('R');
710: END IF;
711: insert into IGS_PR_MILESTONE_ALL (
712: PERSON_ID,
713: CA_SEQUENCE_NUMBER,

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

749: X_LAST_UPDATE_LOGIN,
750: NEW_REFERENCES.ORG_ID
751: );
752: IF (x_mode = 'S') THEN
753: igs_sc_gen_001.unset_ctx('R');
754: END IF;
755:
756:
757: open c;

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

770: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
771: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
772: fnd_message.set_token ('ERR_CD', SQLCODE);
773: igs_ge_msg_stack.add;
774: igs_sc_gen_001.unset_ctx('R');
775: app_exception.raise_exception;
776: ELSE
777: igs_sc_gen_001.unset_ctx('R');
778: RAISE;

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

773: igs_ge_msg_stack.add;
774: igs_sc_gen_001.unset_ctx('R');
775: app_exception.raise_exception;
776: ELSE
777: igs_sc_gen_001.unset_ctx('R');
778: RAISE;
779: END IF;
780:
781: end INSERT_ROW;

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

920: ) ;
921:
922:
923: IF (x_mode = 'S') THEN
924: igs_sc_gen_001.set_ctx('R');
925: END IF;
926: update IGS_PR_MILESTONE_ALL set
927: MILESTONE_TYPE = NEW_REFERENCES.MILESTONE_TYPE,
928: MILESTONE_STATUS = NEW_REFERENCES.MILESTONE_STATUS,

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

941:
942: if (sql%notfound) then
943: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
944: igs_ge_msg_stack.add;
945: igs_sc_gen_001.unset_ctx('R');
946: app_exception.raise_exception;
947: end if;
948: IF (x_mode = 'S') THEN
949: igs_sc_gen_001.unset_ctx('R');

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

945: igs_sc_gen_001.unset_ctx('R');
946: app_exception.raise_exception;
947: end if;
948: IF (x_mode = 'S') THEN
949: igs_sc_gen_001.unset_ctx('R');
950: END IF;
951:
952:
953: After_DML (

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

959: IF (SQLCODE = (-28115)) THEN
960: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
961: fnd_message.set_token ('ERR_CD', SQLCODE);
962: igs_ge_msg_stack.add;
963: igs_sc_gen_001.unset_ctx('R');
964: app_exception.raise_exception;
965: ELSE
966: igs_sc_gen_001.unset_ctx('R');
967: RAISE;

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

962: igs_ge_msg_stack.add;
963: igs_sc_gen_001.unset_ctx('R');
964: app_exception.raise_exception;
965: ELSE
966: igs_sc_gen_001.unset_ctx('R');
967: RAISE;
968: END IF;
969:
970: end UPDATE_ROW;

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

1045: p_action=>'DELETE',
1046: x_rowid=>X_ROWID
1047: );
1048: IF (x_mode = 'S') THEN
1049: igs_sc_gen_001.set_ctx('R');
1050: END IF;
1051: delete from IGS_PR_MILESTONE_ALL
1052: where ROWID = X_ROWID;
1053: if (sql%notfound) then

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

1052: where ROWID = X_ROWID;
1053: if (sql%notfound) then
1054: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1055: igs_ge_msg_stack.add;
1056: igs_sc_gen_001.unset_ctx('R');
1057: app_exception.raise_exception;
1058: end if;
1059: IF (x_mode = 'S') THEN
1060: igs_sc_gen_001.unset_ctx('R');

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

1056: igs_sc_gen_001.unset_ctx('R');
1057: app_exception.raise_exception;
1058: end if;
1059: IF (x_mode = 'S') THEN
1060: igs_sc_gen_001.unset_ctx('R');
1061: END IF;
1062:
1063: After_DML (
1064: p_action => 'DELETE',