APPS.IGS_HE_ST_SPA_ALL_PKG dependencies on IGS_SC_GEN_001

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

834: x_exclude_flag => x_exclude_flag
835: );
836:
837: IF (x_mode = 'S') THEN
838: igs_sc_gen_001.set_ctx('R');
839: END IF;
840: INSERT INTO igs_he_st_spa_all (
841: hesa_st_spa_id,
842: org_id,

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

968: new_references.enh_fund_elig_cd,
969: new_references.exclude_flag
970: );
971: IF (x_mode = 'S') THEN
972: igs_sc_gen_001.unset_ctx('R');
973: END IF;
974:
975:
976: OPEN c;

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

987: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
988: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
989: fnd_message.set_token ('ERR_CD', SQLCODE);
990: igs_ge_msg_stack.add;
991: igs_sc_gen_001.unset_ctx('R');
992: app_exception.raise_exception;
993: ELSE
994: igs_sc_gen_001.unset_ctx('R');
995: RAISE;

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

990: igs_ge_msg_stack.add;
991: igs_sc_gen_001.unset_ctx('R');
992: app_exception.raise_exception;
993: ELSE
994: igs_sc_gen_001.unset_ctx('R');
995: RAISE;
996: END IF;
997:
998: END insert_row;

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

1393: x_exclude_flag => x_exclude_flag
1394: );
1395:
1396: IF (x_mode = 'S') THEN
1397: igs_sc_gen_001.set_ctx('R');
1398: END IF;
1399: UPDATE igs_he_st_spa_all
1400: SET
1401: org_id = new_references.org_id,

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

1463:
1464: IF (SQL%NOTFOUND) THEN
1465: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1466: igs_ge_msg_stack.add;
1467: igs_sc_gen_001.unset_ctx('R');
1468: app_exception.raise_exception;
1469: END IF;
1470: IF (x_mode = 'S') THEN
1471: igs_sc_gen_001.unset_ctx('R');

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

1467: igs_sc_gen_001.unset_ctx('R');
1468: app_exception.raise_exception;
1469: END IF;
1470: IF (x_mode = 'S') THEN
1471: igs_sc_gen_001.unset_ctx('R');
1472: END IF;
1473:
1474: EXCEPTION
1475: WHEN OTHERS THEN

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

1476: IF (SQLCODE = (-28115)) THEN
1477: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1478: fnd_message.set_token ('ERR_CD', SQLCODE);
1479: igs_ge_msg_stack.add;
1480: igs_sc_gen_001.unset_ctx('R');
1481: app_exception.raise_exception;
1482: ELSE
1483: igs_sc_gen_001.unset_ctx('R');
1484: RAISE;

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

1479: igs_ge_msg_stack.add;
1480: igs_sc_gen_001.unset_ctx('R');
1481: app_exception.raise_exception;
1482: ELSE
1483: igs_sc_gen_001.unset_ctx('R');
1484: RAISE;
1485: END IF;
1486:
1487: END update_row;

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

1729: x_rowid => x_rowid
1730: );
1731:
1732: IF (x_mode = 'S') THEN
1733: igs_sc_gen_001.set_ctx('R');
1734: END IF;
1735: DELETE FROM igs_he_st_spa_all
1736: WHERE rowid = x_rowid;
1737:

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

1737:
1738: IF (SQL%NOTFOUND) THEN
1739: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1740: igs_ge_msg_stack.add;
1741: igs_sc_gen_001.unset_ctx('R');
1742: app_exception.raise_exception;
1743: END IF;
1744: IF (x_mode = 'S') THEN
1745: igs_sc_gen_001.unset_ctx('R');

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

1741: igs_sc_gen_001.unset_ctx('R');
1742: app_exception.raise_exception;
1743: END IF;
1744: IF (x_mode = 'S') THEN
1745: igs_sc_gen_001.unset_ctx('R');
1746: END IF;
1747:
1748:
1749: END delete_row;