APPS.IGS_PE_ALT_PERS_ID_PKG dependencies on IGS_SC_GEN_001

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

784: x_attribute20 => X_ATTRIBUTE20,
785: x_region_cd => X_region_cd
786: );
787: IF (x_mode = 'S') THEN
788: igs_sc_gen_001.set_ctx('R');
789: END IF;
790: insert into IGS_PE_ALT_PERS_ID (
791: PE_PERSON_ID,
792: API_PERSON_ID,

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

864: NEW_REFERENCES.ATTRIBUTE20 ,
865: NEW_REFERENCES.REGION_CD
866: )RETURNING ROWID INTO X_ROWID;
867: IF (x_mode = 'S') THEN
868: igs_sc_gen_001.unset_ctx('R');
869: END IF;
870: -- Adding the returning clause for bug 4188189
871: -- Commenting out the following cursor fetch lines for bug 4188189
872: --open c;

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

885: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
886: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
887: fnd_message.set_token ('ERR_CD', SQLCODE);
888: igs_ge_msg_stack.add;
889: igs_sc_gen_001.unset_ctx('R');
890: app_exception.raise_exception;
891: ELSE
892: igs_sc_gen_001.unset_ctx('R');
893: RAISE;

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

888: igs_ge_msg_stack.add;
889: igs_sc_gen_001.unset_ctx('R');
890: app_exception.raise_exception;
891: ELSE
892: igs_sc_gen_001.unset_ctx('R');
893: RAISE;
894: END IF;
895:
896: end INSERT_ROW;

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

1116: X_PROGRAM_UPDATE_DATE := SYSDATE;
1117: end if;
1118: end if;
1119: IF (x_mode = 'S') THEN
1120: igs_sc_gen_001.set_ctx('R');
1121: END IF;
1122: update IGS_PE_ALT_PERS_ID set
1123: API_PERSON_ID_UF = NEW_REFERENCES.API_PERSON_ID_UF,
1124: START_DT = NEW_REFERENCES.START_DT,

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

1157: ;
1158: if (sql%notfound) then
1159: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1160: igs_ge_msg_stack.add;
1161: igs_sc_gen_001.unset_ctx('R');
1162: app_exception.raise_exception;
1163: end if;
1164: IF (x_mode = 'S') THEN
1165: igs_sc_gen_001.unset_ctx('R');

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

1161: igs_sc_gen_001.unset_ctx('R');
1162: app_exception.raise_exception;
1163: end if;
1164: IF (x_mode = 'S') THEN
1165: igs_sc_gen_001.unset_ctx('R');
1166: END IF;
1167:
1168: After_DML(
1169: p_action => 'UPDATE',

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

1174: IF (SQLCODE = (-28115)) THEN
1175: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1176: fnd_message.set_token ('ERR_CD', SQLCODE);
1177: igs_ge_msg_stack.add;
1178: igs_sc_gen_001.unset_ctx('R');
1179: app_exception.raise_exception;
1180: ELSE
1181: igs_sc_gen_001.unset_ctx('R');
1182: RAISE;

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

1177: igs_ge_msg_stack.add;
1178: igs_sc_gen_001.unset_ctx('R');
1179: app_exception.raise_exception;
1180: ELSE
1181: igs_sc_gen_001.unset_ctx('R');
1182: RAISE;
1183: END IF;
1184:
1185: end UPDATE_ROW;

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

1301: p_action => 'DELETE',
1302: x_rowid => X_ROWID
1303: );
1304: IF (x_mode = 'S') THEN
1305: igs_sc_gen_001.set_ctx('R');
1306: END IF;
1307: delete from IGS_PE_ALT_PERS_ID
1308: where ROWID = X_ROWID;
1309: if (sql%notfound) then

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

1308: where ROWID = X_ROWID;
1309: if (sql%notfound) then
1310: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1311: igs_ge_msg_stack.add;
1312: igs_sc_gen_001.unset_ctx('R');
1313: app_exception.raise_exception;
1314: end if;
1315: IF (x_mode = 'S') THEN
1316: igs_sc_gen_001.unset_ctx('R');

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

1312: igs_sc_gen_001.unset_ctx('R');
1313: app_exception.raise_exception;
1314: end if;
1315: IF (x_mode = 'S') THEN
1316: igs_sc_gen_001.unset_ctx('R');
1317: END IF;
1318:
1319: After_DML(
1320: p_action => 'DELETE',