APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_AD_SEC_STAT

Line 1371: tray 16-APR-02 added DML delete for deleting data from igs_ss_ad_sec_stat

1367:
1368: Known limitations,enhancements,remarks:
1369: Change History
1370: Who When What
1371: tray 16-APR-02 added DML delete for deleting data from igs_ss_ad_sec_stat
1372: after the application is transferred.
1373: *****************************************************************************************/
1374:
1375: l_message_name VARCHAR2(2000);

Line 1386: DELETE FROM igs_ss_ad_sec_stat

1382: BEGIN
1383: l_msg_index := IGS_GE_MSG_STACK.count_msg;
1384:
1385: BEGIN
1386: DELETE FROM igs_ss_ad_sec_stat
1387: WHERE person_id = p_person_id
1388: AND ss_adm_appl_id = p_adm_appl_number;
1389:
1390: DELETE FROM igs_ss_app_req_stg

Line 3188: FROM igs_ss_ad_sec_stat

3184: FROM igs_ss_adm_appl_stg
3185: WHERE ss_adm_appl_id = cp_ApplNum)
3186: AND pgs.include_ind = 'Y'
3187: AND NOT EXISTS ( SELECT 'x'
3188: FROM igs_ss_ad_sec_stat
3189: WHERE person_id = cp_person_id
3190: AND ss_adm_appl_id = cp_ApplNum
3191: AND section = pgs.page_name);
3192:

Line 3195: INSERT INTO IGS_SS_AD_SEC_STAT

3191: AND section = pgs.page_name);
3192:
3193: BEGIN
3194: FOR c_chklist_values_rec IN c_chklist(p_adm_appl_number, p_person_id) LOOP
3195: INSERT INTO IGS_SS_AD_SEC_STAT
3196: (SS_ADM_APPL_ID,
3197: PERSON_ID,
3198: SECTION,
3199: COMPLETION_STATUS,

Line 4549: UPDATE IGS_SS_AD_SEC_STAT

4545: l_comp_status:='COMPLETE';
4546: END IF;
4547: END IF;
4548:
4549: UPDATE IGS_SS_AD_SEC_STAT
4550: SET COMPLETION_STATUS = l_comp_status
4551: WHERE SS_ADM_APPL_ID = p_adm_appl_number
4552: AND PERSON_ID = p_person_id
4553: AND SECTION = p_page_Name;

Line 4614: UPDATE IGS_SS_AD_SEC_STAT

4610: p_adm_appl_number,
4611: p_login_id);
4612:
4613: -- Update the COMPLETION_STATUS with COMPLETE if COMPLETION_STATUS = ERROR for person in Context.
4614: UPDATE IGS_SS_AD_SEC_STAT
4615: SET COMPLETION_STATUS = 'COMPLETE'
4616: WHERE SS_ADM_APPL_ID = p_adm_appl_number
4617: AND PERSON_ID = p_person_id
4618: AND COMPLETION_STATUS = 'ERROR';