APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on FND_GLOBAL

Line 432: l_conc_request_id := fnd_global.conc_request_id();

428: l_batch_id_loc := 0;
429:
430: -- Get the Concurrent Request ID of the current export of UCAS application to
431: -- OSS admission applications run
432: l_conc_request_id := fnd_global.conc_request_id();
433:
434: FOR c_ch_system_rec IN c_ch_system LOOP
435:
436: -- Insert a record into the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL

Line 1676: l_conc_request_id := fnd_global.conc_request_id() ;

1672: BEGIN /* begin of export_reply */
1673:
1674: -- Get the Concurrent Request ID of the current export of UCAS application to
1675: -- OSS admission applications run
1676: l_conc_request_id := fnd_global.conc_request_id() ;
1677: l_exp_reply_flag := FALSE ;
1678:
1679: -- Populate the Offer Response Import Interface Batch table,IGS_AD_OFFRESP_BATCH
1680: -- Get the Batch ID using the sequence, IGS_AD_OFFRESP_BATCH_S

Line 1687: l_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1) ;

1683: FETCH cur_offresp_batc_s INTO l_batch_id ;
1684: CLOSE cur_offresp_batc_s ;
1685:
1686: -- Find the WHO columns to insert a record into IGS_AD_OFFRESP_BATCH table
1687: l_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1) ;
1688: l_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1) ;
1689:
1690: -- Get the Description value from the Message,IGS_UC_OFF_BATCH
1691: fnd_message.set_name('IGS','IGS_UC_OFF_BATCH');

Line 1688: l_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1) ;

1684: CLOSE cur_offresp_batc_s ;
1685:
1686: -- Find the WHO columns to insert a record into IGS_AD_OFFRESP_BATCH table
1687: l_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1) ;
1688: l_last_update_login := NVL(FND_GLOBAL.LOGIN_ID,-1) ;
1689:
1690: -- Get the Description value from the Message,IGS_UC_OFF_BATCH
1691: fnd_message.set_name('IGS','IGS_UC_OFF_BATCH');
1692: l_description := fnd_message.get;

Line 1714: fnd_global.conc_request_id,

1710: SYSDATE,
1711: l_last_updated_by,
1712: SYSDATE,
1713: l_last_update_login,
1714: fnd_global.conc_request_id,
1715: fnd_global.prog_appl_id,
1716: SYSDATE,
1717: fnd_global.conc_program_id );
1718:

Line 1715: fnd_global.prog_appl_id,

1711: l_last_updated_by,
1712: SYSDATE,
1713: l_last_update_login,
1714: fnd_global.conc_request_id,
1715: fnd_global.prog_appl_id,
1716: SYSDATE,
1717: fnd_global.conc_program_id );
1718:
1719: /* Process all the Application Choice records of the passed p_app_no, p_choice_number

Line 1717: fnd_global.conc_program_id );

1713: l_last_update_login,
1714: fnd_global.conc_request_id,
1715: fnd_global.prog_appl_id,
1716: SYSDATE,
1717: fnd_global.conc_program_id );
1718:
1719: /* Process all the Application Choice records of the passed p_app_no, p_choice_number
1720: and of the current institution with Export_to_oss Status = 'DC' */
1721:

Line 1901: fnd_global.conc_request_id,

1897: SYSDATE,
1898: l_last_updated_by,
1899: SYSDATE,
1900: l_last_update_login,
1901: fnd_global.conc_request_id,
1902: fnd_global.prog_appl_id,
1903: SYSDATE,
1904: fnd_global.conc_program_id,
1905: l_decline_ofr_reason);

Line 1902: fnd_global.prog_appl_id,

1898: l_last_updated_by,
1899: SYSDATE,
1900: l_last_update_login,
1901: fnd_global.conc_request_id,
1902: fnd_global.prog_appl_id,
1903: SYSDATE,
1904: fnd_global.conc_program_id,
1905: l_decline_ofr_reason);
1906:

Line 1904: fnd_global.conc_program_id,

1900: l_last_update_login,
1901: fnd_global.conc_request_id,
1902: fnd_global.prog_appl_id,
1903: SYSDATE,
1904: fnd_global.conc_program_id,
1905: l_decline_ofr_reason);
1906:
1907: -- Update the Application Choice record with the export_to_OSS_Status="RP"
1908: l_export_to_oss := 'RP' ;