[Home] [Help]
78: p_nominated_course_cd IN igs_ad_edugoal.nominated_course_cd%TYPE,
79: p_sequence_number IN igs_ad_edugoal.sequence_number%TYPE); --this procedure has been modified, nshee Bug 2622488
80: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
81: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,
82: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,
83: x_return_status OUT NOCOPY VARCHAR2);
84: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]
85: --** added by nshee
86: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,
1455:
1456: --Procedure for transferring Personal Statements/Attachments
1457: PROCEDURE transfer_attachment(p_person_id IN IGS_SS_APPL_PERSTAT.person_id%TYPE,
1458: p_ss_adm_appl_id IN IGS_SS_APPL_PERSTAT.ss_adm_appl_id%TYPE,
1459: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,
1460: x_return_status OUT NOCOPY VARCHAR2) IS
1461: /*****************************************************************************************
1462: Created By: [email protected]
1463: Date Created : 11-DEC-2001
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: *****************************************************************************************/
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: *****************************************************************************************/
1475: l_rowid VARCHAR2(25);
1476: l_appl_perstat_id IGS_AD_APPL_PERSTAT.appl_perstat_id%TYPE;
1477: l_from_pk1_value VARCHAR2(100);
1478: l_to_pk1_value VARCHAR2(100);
1479: lv_mode VARCHAR2(1) DEFAULT 'R';
1480:
1485: AND ps.person_id = p_person_id;
1486:
1487: CURSOR c_ad_appl_perstat IS
1488: SELECT APPL_PERSTAT_ID
1489: FROM igs_ad_appl_perstat
1490: WHERE person_id = p_person_id
1491: AND admission_appl_number = p_admission_appl_number;
1492:
1493: c_ss_appl_perstat_rec c_ss_appl_perstat%ROWTYPE;
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,
1515: x_date_received => NVL(c_ss_appl_perstat_rec.date_received,
1516: TRUNC(SYSDATE)), --If the date_received passed from Self Service is null then insert SYSDATE into OSS Table
1517: x_mode => lv_mode -- enable security for Admin
1518: );
1519: /* If insert is successful copy and delete the attachments to the IGS_AD_APPL_PERSTAT table */
1520: BEGIN
1521:
1522: -- bug 2407148 fix (transferring multiple personal statements)
1523:
1534: X_from_pk2_value => NULL,
1535: X_from_pk3_value => NULL,
1536: X_from_pk4_value => NULL,
1537: X_from_pk5_value => NULL,
1538: X_to_entity_name => 'IGS_AD_APPL_PERSTAT',
1539: X_to_pk1_value => l_appl_perstat_id, -- l_to_pk1_value is not used bug 2407148 fix
1540: X_to_pk2_value => NULL,
1541: X_to_pk3_value => NULL,
1542: X_to_pk4_value => NULL,
5553: text => NULL,
5554: file_name => p_file_name,
5555: url => NULL,
5556: function_name => NULL,
5557: entity_name => 'IGS_AD_APPL_PERSTAT',
5558: pk1_value => P_APPL_PERSTAT_ID,
5559: pk2_value => NULL,
5560: pk3_value => NULL,
5561: pk4_value => NULL,