APPS.IGS_PE_STAT_DETAILS_PKG dependencies on IGS_SC_GEN_001

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

659: X_BIRTH_CNTRY_RESN_CODE =>X_BIRTH_CNTRY_RESN_CODE
660: );
661:
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.set_ctx('R');
664: END IF;
665: INSERT INTO igs_pe_stat_details (
666: -- person_profile_id,
667: person_id,

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

778: new_references.ATTRIBUTE20,
779: new_references.birth_cntry_resn_code
780: );
781: IF (x_mode = 'S') THEN
782: igs_sc_gen_001.unset_ctx('R');
783: END IF;
784:
785:
786: OPEN c;

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

797: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
798: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
799: fnd_message.set_token ('ERR_CD', SQLCODE);
800: igs_ge_msg_stack.add;
801: igs_sc_gen_001.unset_ctx('R');
802: app_exception.raise_exception;
803: ELSE
804: igs_sc_gen_001.unset_ctx('R');
805: RAISE;

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

800: igs_ge_msg_stack.add;
801: igs_sc_gen_001.unset_ctx('R');
802: app_exception.raise_exception;
803: ELSE
804: igs_sc_gen_001.unset_ctx('R');
805: RAISE;
806: END IF;
807: END insert_row;
808:

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

1196: END IF;
1197: END IF;
1198:
1199: IF (x_mode = 'S') THEN
1200: igs_sc_gen_001.set_ctx('R');
1201: END IF;
1202: UPDATE igs_pe_stat_details
1203: SET
1204: effective_start_date = new_references.effective_start_date,

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

1257:
1258: IF (SQL%NOTFOUND) THEN
1259: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1260: igs_ge_msg_stack.add;
1261: igs_sc_gen_001.unset_ctx('R');
1262: app_exception.raise_exception;
1263: END IF;
1264: IF (x_mode = 'S') THEN
1265: igs_sc_gen_001.unset_ctx('R');

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

1261: igs_sc_gen_001.unset_ctx('R');
1262: app_exception.raise_exception;
1263: END IF;
1264: IF (x_mode = 'S') THEN
1265: igs_sc_gen_001.unset_ctx('R');
1266: END IF;
1267:
1268:
1269:

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

1272: IF (SQLCODE = (-28115)) THEN
1273: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1274: fnd_message.set_token ('ERR_CD', SQLCODE);
1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;
1278: ELSE
1279: igs_sc_gen_001.unset_ctx('R');
1280: RAISE;

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

1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;
1278: ELSE
1279: igs_sc_gen_001.unset_ctx('R');
1280: RAISE;
1281: END IF;
1282: END update_row;
1283:

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

1486: x_rowid => x_rowid
1487: );
1488:
1489: IF (x_mode = 'S') THEN
1490: igs_sc_gen_001.set_ctx('R');
1491: END IF;
1492: DELETE FROM igs_pe_stat_details
1493: WHERE ROWID = x_rowid;
1494:

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

1494:
1495: IF (SQL%NOTFOUND) THEN
1496: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1497: igs_ge_msg_stack.add;
1498: igs_sc_gen_001.unset_ctx('R');
1499: app_exception.raise_exception;
1500: END IF;
1501: IF (x_mode = 'S') THEN
1502: igs_sc_gen_001.unset_ctx('R');

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

1498: igs_sc_gen_001.unset_ctx('R');
1499: app_exception.raise_exception;
1500: END IF;
1501: IF (x_mode = 'S') THEN
1502: igs_sc_gen_001.unset_ctx('R');
1503: END IF;
1504:
1505:
1506: END delete_row;