APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_APPL_PERSTAT_PKG

Line 1470: rboddu 17-FEB-2002 in IGS_AD_APPL_PERSTAT_PKG.Insert_Row, date_received is passed

1466:
1467: Known limitations,enhancements,remarks:
1468: Change History
1469: Who When What
1470: rboddu 17-FEB-2002 in IGS_AD_APPL_PERSTAT_PKG.Insert_Row, date_received is passed
1471: NVL(c_ss_appl_perstat_rec.date_received,SYSDATE). Earlier it was just SYSDATE
1472: Bug : 2224624
1473: rboddu 05-MAR-2003 Passing Received_Date as TRUNC(SYSDATE) if it's null in the SS Table. Bug: 2731445
1474: *****************************************************************************************/

Line 1510: IGS_AD_APPL_PERSTAT_PKG.Insert_Row(x_rowid => l_rowid,

1506: and error will be caused , as per back office functionality application can be created without personal statement. So procedure should return status 'S' when there are no personal statement staging records */
1507: EXIT WHEN c_ss_appl_perstat%NOTFOUND;
1508: IF c_ss_appl_perstat_rec.ATTACH_EXISTS = 'Y' THEN
1509: BEGIN
1510: IGS_AD_APPL_PERSTAT_PKG.Insert_Row(x_rowid => l_rowid,
1511: x_appl_perstat_id => l_appl_perstat_id,
1512: x_person_id => c_ss_appl_perstat_rec.person_id,
1513: x_admission_appl_number => p_admission_appl_number,
1514: x_persl_stat_type => c_ss_appl_perstat_rec.persl_stat_type,