APPS.IGS_PE_RES_DTLS_PKG dependencies on IGS_SC_GEN_001

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

788: x_last_update_login=>X_LAST_UPDATE_LOGIN,
789: x_org_id=>igs_ge_gen_003.get_org_id
790: );
791: IF (x_mode = 'S') THEN
792: igs_sc_gen_001.set_ctx('R');
793: END IF;
794: insert into igs_pe_res_dtls_all (
795: RESIDENT_DETAILS_ID
796: ,PERSON_ID

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

866: ,X_LAST_UPDATE_LOGIN
867: ,NEW_REFERENCES.ORG_ID
868: );
869: IF (x_mode = 'S') THEN
870: igs_sc_gen_001.unset_ctx('R');
871: END IF;
872:
873: open c;
874: fetch c into X_ROWID;

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

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

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

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

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

1181: x_last_update_date=>X_LAST_UPDATE_DATE,
1182: x_last_updated_by=>X_LAST_UPDATED_BY,
1183: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1184: IF (x_mode = 'S') THEN
1185: igs_sc_gen_001.set_ctx('R');
1186: END IF;
1187: update igs_pe_res_dtls_all set
1188: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1189: RESIDENCY_CLASS_CD = NEW_REFERENCES.RESIDENCY_CLASS_CD,

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

1220: where ROWID = X_ROWID;
1221: if (sql%notfound) then
1222: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1223: igs_ge_msg_stack.add;
1224: igs_sc_gen_001.unset_ctx('R');
1225: app_exception.raise_exception;
1226: END if;
1227: IF (x_mode = 'S') THEN
1228: igs_sc_gen_001.unset_ctx('R');

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

1224: igs_sc_gen_001.unset_ctx('R');
1225: app_exception.raise_exception;
1226: END if;
1227: IF (x_mode = 'S') THEN
1228: igs_sc_gen_001.unset_ctx('R');
1229: END IF;
1230:
1231: After_DML (
1232: p_action => 'UPDATE' ,

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

1237: IF (SQLCODE = (-28115)) THEN
1238: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1239: fnd_message.set_token ('ERR_CD', SQLCODE);
1240: igs_ge_msg_stack.add;
1241: igs_sc_gen_001.unset_ctx('R');
1242: app_exception.raise_exception;
1243: ELSE
1244: igs_sc_gen_001.unset_ctx('R');
1245: RAISE;

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

1240: igs_ge_msg_stack.add;
1241: igs_sc_gen_001.unset_ctx('R');
1242: app_exception.raise_exception;
1243: ELSE
1244: igs_sc_gen_001.unset_ctx('R');
1245: RAISE;
1246: END IF;
1247:
1248: END UPDATE_ROW;

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

1402: p_action => 'DELETE',
1403: x_rowid => X_ROWID
1404: );
1405: IF (x_mode = 'S') THEN
1406: igs_sc_gen_001.set_ctx('R');
1407: END IF;
1408: delete from igs_pe_res_dtls_all
1409: where ROWID = X_ROWID;
1410: if (sql%notfound) then

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

1409: where ROWID = X_ROWID;
1410: if (sql%notfound) then
1411: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1412: igs_ge_msg_stack.add;
1413: igs_sc_gen_001.unset_ctx('R');
1414: app_exception.raise_exception;
1415: END if;
1416: IF (x_mode = 'S') THEN
1417: igs_sc_gen_001.unset_ctx('R');

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

1413: igs_sc_gen_001.unset_ctx('R');
1414: app_exception.raise_exception;
1415: END if;
1416: IF (x_mode = 'S') THEN
1417: igs_sc_gen_001.unset_ctx('R');
1418: END IF;
1419:
1420: After_DML (
1421: p_action => 'DELETE',