eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AV_STND_UNIT_ALL

Line 16: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,

12: END mydebug;
13:
14:
15: FUNCTION validate_ref_code (
16: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
17: p_reference_code_id IN igs_ge_ref_cd.reference_code_id%TYPE
18: )
19: RETURN BOOLEAN
20: IS

Line 293: p_s_adv_stnd_type OUT NOCOPY igs_av_stnd_unit_all. s_adv_stnd_type%TYPE,

289:
290: FUNCTION derive_unit_data(
291: p_lgcy_adstunt_rec IN OUT NOCOPY lgcy_adstunt_rec_type,
292: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
293: p_s_adv_stnd_type OUT NOCOPY igs_av_stnd_unit_all. s_adv_stnd_type%TYPE,
294: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
295: p_seq_number OUT NOCOPY igs_ca_inst. sequence_number%TYPE,
296: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%TYPE,
297: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE,

Line 755: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,

751:
752: FUNCTION validate_std_unt_db_cons(
753: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
754: p_person_id IN igs_pe_person.person_id%TYPE,
755: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
756: p_cal_type IN igs_ca_inst.cal_type%TYPE,
757: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
758: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
759: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,

Line 762: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_stnd_unit_all.av_stnd_unit_id%TYPE

758: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
759: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
760: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
761: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
762: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_stnd_unit_all.av_stnd_unit_id%TYPE
763: )RETURN BOOLEAN IS
764: /*===========================================================================+
765: | FUNCTION |
766: | validate_std_unt_db_cons |

Line 798: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;

794: | jhanda 11-11-2002 Created |
795: +===========================================================================*/
796: x_return_status BOOLEAN := TRUE;
797: l_c_tmp_msg VARCHAR2(30);
798: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
799: CURSOR c_igs_av_stnd_unit_seq IS
800: select igs_av_stnd_unit_s.nextval from dual ;
801:
802: BEGIN

Line 937: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,

933:
934: FUNCTION validate_unit(
935: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
936: p_person_id IN igs_pe_person.person_id%TYPE,
937: p_s_adv_stnd_type IN igs_av_stnd_unit_all. s_adv_stnd_type %TYPE,
938: p_cal_type IN igs_ca_inst.cal_type%TYPE,
939: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
940: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
941: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,

Line 951: | inserting a record into the table IGS_AV_STND_UNIT_ALL and|

947: | validate_unit |
948: | |
949: | DESCRIPTION |
950: | This function performs all the business validations before |
951: | inserting a record into the table IGS_AV_STND_UNIT_ALL and|
952: | keeps adding error message to stack as an when it encounters.|
953: | |
954: | SCOPE - PRIVATE |
955: | |

Line 1248: p_av_stnd_unit_id IN IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID%TYPE ,

1244:
1245:
1246: FUNCTION validate_alt_unt_db_cons(
1247: p_lgcy_adstunt_rec IN LGCY_ADSTUNT_REC_TYPE,
1248: p_av_stnd_unit_id IN IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID%TYPE ,
1249: p_s_adv_stnd_type IN IGS_AV_STND_UNIT_ALL.S_ADV_STND_TYPE%TYPE ,
1250: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1251: p_unit_details_id IN IGS_AD_TERM_UNITDTLS.UNIT_DETAILS_ID%TYPE ,
1252: p_tst_rslt_dtls_id IN IGS_AD_TST_RSLT_DTLS.TST_RSLT_DTLS_ID%TYPE ,

Line 1249: p_s_adv_stnd_type IN IGS_AV_STND_UNIT_ALL.S_ADV_STND_TYPE%TYPE ,

1245:
1246: FUNCTION validate_alt_unt_db_cons(
1247: p_lgcy_adstunt_rec IN LGCY_ADSTUNT_REC_TYPE,
1248: p_av_stnd_unit_id IN IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID%TYPE ,
1249: p_s_adv_stnd_type IN IGS_AV_STND_UNIT_ALL.S_ADV_STND_TYPE%TYPE ,
1250: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1251: p_unit_details_id IN IGS_AD_TERM_UNITDTLS.UNIT_DETAILS_ID%TYPE ,
1252: p_tst_rslt_dtls_id IN IGS_AD_TST_RSLT_DTLS.TST_RSLT_DTLS_ID%TYPE ,
1253: p_as_version_number IN IGS_AV_STND_UNIT_ALL.AS_VERSION_NUMBER%TYPE ,

Line 1253: p_as_version_number IN IGS_AV_STND_UNIT_ALL.AS_VERSION_NUMBER%TYPE ,

1249: p_s_adv_stnd_type IN IGS_AV_STND_UNIT_ALL.S_ADV_STND_TYPE%TYPE ,
1250: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1251: p_unit_details_id IN IGS_AD_TERM_UNITDTLS.UNIT_DETAILS_ID%TYPE ,
1252: p_tst_rslt_dtls_id IN IGS_AD_TST_RSLT_DTLS.TST_RSLT_DTLS_ID%TYPE ,
1253: p_as_version_number IN IGS_AV_STND_UNIT_ALL.AS_VERSION_NUMBER%TYPE ,
1254: p_av_stnd_unit_lvl_id OUT NOCOPY IGS_AV_STND_ALT_UNIT.AV_STND_UNIT_ID%TYPE ,
1255: x_return_status OUT NOCOPY VARCHAR2
1256: )
1257: RETURN BOOLEAN

Line 1296: igs_av_stnd_unit_all

1292: )IS
1293: SELECT
1294: av_stnd_unit_id
1295: FROM
1296: igs_av_stnd_unit_all
1297: WHERE
1298: person_id = cp_person_id AND
1299: NVL(institution_cd,0) = NVL(cp_institution_cd,0) AND
1300: NVL(tst_rslt_dtls_id,0) = NVL(cp_tst_rslt_dtls_id,0) AND

Line 1306: l_av_stnd_unit_lvl_id IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID%TYPE;

1302: unit_cd = cp_unit_cd AND
1303: as_course_cd = cp_as_course_cd AND
1304: as_version_number = cp_as_version_number ;
1305:
1306: l_av_stnd_unit_lvl_id IGS_AV_STND_UNIT_ALL.AV_STND_UNIT_ID%TYPE;
1307: l_return_status BOOLEAN DEFAULT TRUE;
1308: BEGIN
1309: -- Initialise x_return_status to 'S'
1310: x_return_status := 'S';

Line 1324: -- foreign key with table igs_av_stnd_unit_all does not exist.

1320: cp_as_version_number => p_as_version_number
1321: );
1322: FETCH cur_get_adv_stnd_id INTO l_av_stnd_unit_lvl_id;
1323: IF cur_get_adv_stnd_id%NOTFOUND THEN
1324: -- foreign key with table igs_av_stnd_unit_all does not exist.
1325: FND_MESSAGE.SET_NAME('IGS','IGS_AV_UNT_ALT_ID_FK_EXISTS');
1326: FND_MSG_PUB.ADD;
1327: x_return_status := 'E';
1328: l_return_status := FALSE;

Line 1330: -- av_stnd_unit_lvl_id found in table igs_av_stnd_unit_all

1326: FND_MSG_PUB.ADD;
1327: x_return_status := 'E';
1328: l_return_status := FALSE;
1329: ELSE
1330: -- av_stnd_unit_lvl_id found in table igs_av_stnd_unit_all
1331: -- check primary in table igs_av_std_alt_unit
1332: IF igs_av_stnd_alt_unit_pkg.get_pk_for_validation(
1333: x_av_stnd_unit_id => l_av_stnd_unit_lvl_id,
1334: x_alt_unit_cd => p_lgcy_adstunt_rec.alt_unit_cd,

Line 1374: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,

1370:
1371:
1372: FUNCTION validate_alt_unit(
1373: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
1374: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
1375: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE
1376: )RETURN BOOLEAN IS
1377: /*===========================================================================+
1378: | FUNCTION |

Line 1375: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE

1371:
1372: FUNCTION validate_alt_unit(
1373: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
1374: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
1375: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE
1376: )RETURN BOOLEAN IS
1377: /*===========================================================================+
1378: | FUNCTION |
1379: | validate_alt_unit |

Line 1420: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,

1416:
1417:
1418: FUNCTION validate_unt_bss_db_cons(
1419: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
1420: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
1421: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE
1422: )RETURN BOOLEAN IS
1423: /*===========================================================================+
1424: | FUNCTION |

Line 1421: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE

1417:
1418: FUNCTION validate_unt_bss_db_cons(
1419: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
1420: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
1421: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE
1422: )RETURN BOOLEAN IS
1423: /*===========================================================================+
1424: | FUNCTION |
1425: | validate_unt_bss_db_cons |

Line 1460: -- Check Foreign key Validation with the table IGS_AV_STND_UNIT_ALL

1456: x_return_status := FALSE;
1457: mydebug('validate_unt_bss_db_cons IGS_AV_UNT_BAS_PK_EXISTS ');
1458: END IF;
1459:
1460: -- Check Foreign key Validation with the table IGS_AV_STND_UNIT_ALL
1461: IF NOT IGS_AV_STND_UNIT_PKG.GET_PK_FOR_VALIDATION( x_av_stnd_unit_id => p_av_stnd_unit_id) THEN
1462: FND_MESSAGE.SET_NAME('IGS','IGS_AV_UNT_ALT_ID_FK_EXISTS');
1463: FND_MSG_PUB.ADD;
1464: x_return_status := FALSE;

Line 1498: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,

1494:
1495:
1496: FUNCTION validate_un1t_basis(
1497: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
1498: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
1499: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE
1500: )RETURN BOOLEAN IS
1501: /*===========================================================================+
1502: | FUNCTION |

Line 1499: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE

1495:
1496: FUNCTION validate_un1t_basis(
1497: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type,
1498: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
1499: p_s_adv_stnd_type IN igs_av_stnd_unit_all.s_adv_stnd_type %TYPE
1500: )RETURN BOOLEAN IS
1501: /*===========================================================================+
1502: | FUNCTION |
1503: | validate_un1t_basis |

Line 1593: l_s_adv_stnd_type igs_av_stnd_unit_all. s_adv_stnd_type%TYPE;

1589: l_api_version CONSTANT NUMBER := 1.0;
1590: l_ret_status BOOLEAN;
1591: l_b_av_stnd_alt_unit_pk_exist BOOLEAN := TRUE;
1592: l_person_id igs_pe_person.person_id%TYPE;
1593: l_s_adv_stnd_type igs_av_stnd_unit_all. s_adv_stnd_type%TYPE;
1594: l_cal_type igs_ca_inst.cal_type%TYPE;
1595: l_seq_number igs_ca_inst. sequence_number%TYPE;
1596: l_auth_pers_id igs_pe_person.person_id%TYPE;
1597: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;

Line 1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;

1596: l_auth_pers_id igs_pe_person.person_id%TYPE;
1597: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
1598: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE;
1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;
1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;
1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;
1604: L_PROGRAM_UPDATE_DATE igs_av_stnd_unit_all.program_update_date%TYPE;

Line 1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;

1597: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
1598: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE;
1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;
1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;
1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;
1604: L_PROGRAM_UPDATE_DATE igs_av_stnd_unit_all.program_update_date%TYPE;
1605: duplicate_record_exists EXCEPTION;

Line 1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;

1598: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE;
1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;
1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;
1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;
1604: L_PROGRAM_UPDATE_DATE igs_av_stnd_unit_all.program_update_date%TYPE;
1605: duplicate_record_exists EXCEPTION;
1606: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE;

Line 1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;

1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;
1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;
1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;
1604: L_PROGRAM_UPDATE_DATE igs_av_stnd_unit_all.program_update_date%TYPE;
1605: duplicate_record_exists EXCEPTION;
1606: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE;
1607: l_AVU_REFERENCE_CD_ID IGS_AV_UNT_REF_CDS.AVU_REFERENCE_CD_ID%TYPE;

Line 1604: L_PROGRAM_UPDATE_DATE igs_av_stnd_unit_all.program_update_date%TYPE;

1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;
1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;
1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;
1604: L_PROGRAM_UPDATE_DATE igs_av_stnd_unit_all.program_update_date%TYPE;
1605: duplicate_record_exists EXCEPTION;
1606: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE;
1607: l_AVU_REFERENCE_CD_ID IGS_AV_UNT_REF_CDS.AVU_REFERENCE_CD_ID%TYPE;
1608:

Line 1677: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL

1673: p_version_number => l_as_version_number,
1674: p_lgcy_adstunt_rec => p_lgcy_adstunt_rec
1675: ) THEN
1676: mydebug('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION');
1677: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL
1678: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation(
1679: x_person_id => l_person_id,
1680: x_course_cd => p_lgcy_adstunt_rec.program_cd ,
1681: x_version_number => l_as_version_number,

Line 1753: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL N');

1749: p_tst_rslt_dtls_id => l_tst_rslt_dtls_id,
1750: p_as_version_number => l_as_version_number
1751: ) THEN
1752: IF p_lgcy_adstunt_rec.prog_group_ind is null THEN
1753: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL N');
1754: p_lgcy_adstunt_rec.prog_group_ind :='N';
1755: END IF;
1756:
1757: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL lgcy_adstunt_rec.prog_group_ind ');

Line 1757: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL lgcy_adstunt_rec.prog_group_ind ');

1753: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL N');
1754: p_lgcy_adstunt_rec.prog_group_ind :='N';
1755: END IF;
1756:
1757: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL lgcy_adstunt_rec.prog_group_ind ');
1758:
1759: L_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1760: L_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1761: L_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;

Line 1772: INSERT INTO igs_av_stnd_unit_all(

1768: else
1769: L_PROGRAM_UPDATE_DATE := SYSDATE ;
1770: end if ;
1771: mydebug('***** l_av_stnd_unit_lvl_id=' || l_av_stnd_unit_lvl_id);
1772: INSERT INTO igs_av_stnd_unit_all(
1773: person_id,
1774: as_course_cd,
1775: as_version_number,
1776: s_adv_stnd_type,

Line 1853: mydebug(' Inserted into IGS_AV_STND_UNIT_ALL val AV_STND_UNIT_ID =' ||l_av_stnd_unit_lvl_id);

1849: NULL ,
1850: l_unit_details_id,
1851: l_tst_rslt_dtls_id
1852: );
1853: mydebug(' Inserted into IGS_AV_STND_UNIT_ALL val AV_STND_UNIT_ID =' ||l_av_stnd_unit_lvl_id);
1854: IF NOT create_post_unit(
1855: p_person_id => l_person_id,
1856: p_course_version => l_as_version_number,
1857: p_unit_details_id => l_unit_details_id,