APPS.IGS_AS_SUAO_LGCY_PUB dependencies on IGS_AS_SU_STMPTOUT_PKG

Line 1482: IF Igs_as_su_stmptout_pkg.get_pk_for_validation (

1478: /*
1479: Validate that the primary key does not already exist.
1480: if exists then give warning and return
1481: */
1482: IF Igs_as_su_stmptout_pkg.get_pk_for_validation (
1483: X_PERSON_ID => p_person_id ,
1484: X_COURSE_CD => p_lgcy_suo_rec.program_cd ,
1485: X_UOO_ID => p_uoo_id ,
1486: X_OUTCOME_DT => p_lgcy_suo_rec.outcome_dt ,

Line 1589: Call the function igs_as_su_stmptout_pkg.check_constraint to check for the version number between 0 and 999

1585: l_msg_count NUMBER ;
1586:
1587: BEGIN
1588: /*
1589: Call the function igs_as_su_stmptout_pkg.check_constraint to check for the version number between 0 and 999
1590: this function raises an exception if it finds an invalid value.
1591: trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1592: and add the customised message.
1593: */

Line 1595: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'VERSION_NUMBER' ,

1591: trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1592: and add the customised message.
1593: */
1594:
1595: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'VERSION_NUMBER' ,
1596: column_value => p_lgcy_suo_rec.version_number
1597: );
1598:
1599: EXCEPTION

Line 1622: Call the function igs_as_su_stmptout_pkg.check_constraint to check for the mark is between 0 and 999.

1618: l_msg_count NUMBER ;
1619:
1620: BEGIN
1621: /*
1622: Call the function igs_as_su_stmptout_pkg.check_constraint to check for the mark is between 0 and 999.
1623: This function raises an exception if it finds an invalid value.
1624: Trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1625: and add the customised message.
1626: */

Line 1628: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'MARK' ,

1624: Trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1625: and add the customised message.
1626: */
1627:
1628: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'MARK' ,
1629: column_value => p_lgcy_suo_rec.mark
1630: );
1631:
1632: EXCEPTION

Line 1657: Call the function igs_as_su_stmptout_pkg.check_constraint to check that the FINALISED_OUTCOME_IND can have values only as

1653: l_msg_count NUMBER ;
1654:
1655: BEGIN
1656: /*
1657: Call the function igs_as_su_stmptout_pkg.check_constraint to check that the FINALISED_OUTCOME_IND can have values only as
1658: 'Y' or 'N'.
1659: This function raises an exception if it finds an invalid value.
1660: Trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1661: and add the customised message.

Line 1664: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'FINALISED_OUTCOME_IND' ,

1660: Trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1661: and add the customised message.
1662: */
1663:
1664: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'FINALISED_OUTCOME_IND' ,
1665: column_value => p_lgcy_suo_rec.finalised_outcome_ind
1666: );
1667:
1668: EXCEPTION

Line 1692: Call the function igs_as_su_stmptout_pkg.check_constraint to check that ci_sequence_number

1688: l_msg_count NUMBER ;
1689:
1690: BEGIN
1691: /*
1692: Call the function igs_as_su_stmptout_pkg.check_constraint to check that ci_sequence_number
1693: can have values only between 0 and 999999.
1694: This function raises an exception if it finds an invalid value.
1695: Trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1696: and add the customised message.

Line 1699: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'CI_SEQUENCE_NUMBER' ,

1695: Trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1696: and add the customised message.
1697: */
1698:
1699: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'CI_SEQUENCE_NUMBER' ,
1700: column_value => p_sequence_number
1701: );
1702:
1703: EXCEPTION

Line 1727: Call the function igs_as_su_stmptout_pkg.check_constraint to check that the translated_version_number can

1723: l_msg_count NUMBER ;
1724:
1725: BEGIN
1726: /*
1727: Call the function igs_as_su_stmptout_pkg.check_constraint to check that the translated_version_number can
1728: have values only between 0 and 999.
1729: This function raises an exception if it finds an invalid value.
1730: Trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1731: and add the customised message.

Line 1734: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'TRANSLATED_VERSION_NUMBER' ,

1730: Trap this exception in the when others block of the exception handler , remove the invalid_value message added by this function
1731: and add the customised message.
1732: */
1733:
1734: igs_as_su_stmptout_pkg.check_constraints ( column_name => 'TRANSLATED_VERSION_NUMBER' ,
1735: column_value => p_translated_version_number
1736: );
1737:
1738: EXCEPTION