DBA Data[Home] [Help]

APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AV_STD_UNT_BASIS_ALL

Line 1429: | before entering into the table IGS_AV_STD_UNT_BASIS_ALL and |

1425: | validate_unt_bss_db_cons |
1426: | |
1427: | DESCRIPTION |
1428: | This function performs all the data integrity validation |
1429: | before entering into the table IGS_AV_STD_UNT_BASIS_ALL and |
1430: | keeps adding error message to stack as an when it encounters.| |
1431: | SCOPE - PRIVATE |
1432: | |
1433: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1507: | before entering into the table IGS_AV_STD_UNT_BASIS_ALL and |

1503: | validate_un1t_basis |
1504: | |
1505: | DESCRIPTION |
1506: | This function performs all the data integrity validation |
1507: | before entering into the table IGS_AV_STD_UNT_BASIS_ALL and |
1508: | keeps adding error message to stack as an when it encounters.| |
1509: | |
1510: | SCOPE - PRIVATE |
1511: | |

Line 1869: mydebug('INSERT INTO IGS_AV_STD_UNT_BASIS_ALL AV_STND_UNIT_ID= '|| l_av_stnd_unit_lvl_id);

1865: IF validate_ref_code(
1866: p_av_stnd_unit_id => l_av_stnd_unit_lvl_id,
1867: p_reference_code_id => l_reference_code_id
1868: ) THEN
1869: mydebug('INSERT INTO IGS_AV_STD_UNT_BASIS_ALL AV_STND_UNIT_ID= '|| l_av_stnd_unit_lvl_id);
1870: OPEN c_unit_ref_id;
1871: FETCH c_unit_ref_id INTO l_AVU_REFERENCE_CD_ID;
1872: CLOSE c_unit_ref_id;
1873: INSERT INTO IGS_AV_UNT_REF_CDS(

Line 1916: mydebug('INSERT INTO IGS_AV_STD_UNT_BASIS_ALL AV_STND_UNIT_ID= '|| l_av_stnd_unit_lvl_id);

1912: p_person_id => l_person_id,
1913: p_version_number => l_as_version_number,
1914: p_lgcy_adstunt_rec => p_lgcy_adstunt_rec
1915: ) THEN
1916: mydebug('INSERT INTO IGS_AV_STD_UNT_BASIS_ALL AV_STND_UNIT_ID= '|| l_av_stnd_unit_lvl_id);
1917: INSERT INTO igs_av_std_unt_basis_all(
1918: last_update_login,
1919: created_by,
1920: creation_date,

Line 1917: INSERT INTO igs_av_std_unt_basis_all(

1913: p_version_number => l_as_version_number,
1914: p_lgcy_adstunt_rec => p_lgcy_adstunt_rec
1915: ) THEN
1916: mydebug('INSERT INTO IGS_AV_STD_UNT_BASIS_ALL AV_STND_UNIT_ID= '|| l_av_stnd_unit_lvl_id);
1917: INSERT INTO igs_av_std_unt_basis_all(
1918: last_update_login,
1919: created_by,
1920: creation_date,
1921: last_updated_by,