eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CO_SUBMIT dependencies on IGS_CO_PREV_REQS

Line 34: FROM igs_co_prev_reqs

30:
31: CURSOR c_preview_exists (cp_concurrent_req_id NUMBER)
32: IS
33: SELECT COUNT (1)
34: FROM igs_co_prev_reqs
35: WHERE concurrent_request_id = cp_concurrent_req_id;
36: BEGIN
37: -- look up the function id for the correspondence workbench
38:

Line 1847: FROM igs_co_prev_reqs

1843: org_unit_id, awd_cal_type, awd_ci_seq_number,
1844: original_version_id, current_version_id, email_subject,
1845: original_content_xml, current_content_xml, ff_request_hist_id,
1846: extended_header, distribution_id, award_prd_cd
1847: FROM igs_co_prev_reqs
1848: WHERE distribution_id = cp_distribution_id
1849: AND NOT ( request_status_code = 'CANCELLED'
1850: OR request_status_code = 'DISTRIBUTED'
1851: );

Line 1872: l_concurrent_request_id igs_co_prev_reqs.concurrent_request_id%TYPE;

1868: WHERE citem_id = cp_content_id
1869: AND citem_ver_id = cp_content_item_version_id;
1870:
1871: -- Preview request variables...
1872: l_concurrent_request_id igs_co_prev_reqs.concurrent_request_id%TYPE;
1873: l_letter_type igs_co_prev_reqs.letter_type_code%TYPE;
1874: l_person_id igs_co_prev_reqs.person_id%TYPE;
1875: l_email_address igs_co_prev_reqs.email_address%TYPE;
1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;

Line 1873: l_letter_type igs_co_prev_reqs.letter_type_code%TYPE;

1869: AND citem_ver_id = cp_content_item_version_id;
1870:
1871: -- Preview request variables...
1872: l_concurrent_request_id igs_co_prev_reqs.concurrent_request_id%TYPE;
1873: l_letter_type igs_co_prev_reqs.letter_type_code%TYPE;
1874: l_person_id igs_co_prev_reqs.person_id%TYPE;
1875: l_email_address igs_co_prev_reqs.email_address%TYPE;
1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;
1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;

Line 1874: l_person_id igs_co_prev_reqs.person_id%TYPE;

1870:
1871: -- Preview request variables...
1872: l_concurrent_request_id igs_co_prev_reqs.concurrent_request_id%TYPE;
1873: l_letter_type igs_co_prev_reqs.letter_type_code%TYPE;
1874: l_person_id igs_co_prev_reqs.person_id%TYPE;
1875: l_email_address igs_co_prev_reqs.email_address%TYPE;
1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;
1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;
1878: l_award_year igs_co_prev_reqs.award_year%TYPE;

Line 1875: l_email_address igs_co_prev_reqs.email_address%TYPE;

1871: -- Preview request variables...
1872: l_concurrent_request_id igs_co_prev_reqs.concurrent_request_id%TYPE;
1873: l_letter_type igs_co_prev_reqs.letter_type_code%TYPE;
1874: l_person_id igs_co_prev_reqs.person_id%TYPE;
1875: l_email_address igs_co_prev_reqs.email_address%TYPE;
1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;
1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;
1878: l_award_year igs_co_prev_reqs.award_year%TYPE;
1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;

Line 1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;

1872: l_concurrent_request_id igs_co_prev_reqs.concurrent_request_id%TYPE;
1873: l_letter_type igs_co_prev_reqs.letter_type_code%TYPE;
1874: l_person_id igs_co_prev_reqs.person_id%TYPE;
1875: l_email_address igs_co_prev_reqs.email_address%TYPE;
1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;
1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;
1878: l_award_year igs_co_prev_reqs.award_year%TYPE;
1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;
1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;

Line 1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;

1873: l_letter_type igs_co_prev_reqs.letter_type_code%TYPE;
1874: l_person_id igs_co_prev_reqs.person_id%TYPE;
1875: l_email_address igs_co_prev_reqs.email_address%TYPE;
1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;
1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;
1878: l_award_year igs_co_prev_reqs.award_year%TYPE;
1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;
1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;
1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;

Line 1878: l_award_year igs_co_prev_reqs.award_year%TYPE;

1874: l_person_id igs_co_prev_reqs.person_id%TYPE;
1875: l_email_address igs_co_prev_reqs.email_address%TYPE;
1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;
1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;
1878: l_award_year igs_co_prev_reqs.award_year%TYPE;
1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;
1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;
1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;
1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;

Line 1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;

1875: l_email_address igs_co_prev_reqs.email_address%TYPE;
1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;
1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;
1878: l_award_year igs_co_prev_reqs.award_year%TYPE;
1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;
1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;
1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;
1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;
1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;

Line 1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;

1876: l_original_content_id igs_co_prev_reqs.original_content_id%TYPE;
1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;
1878: l_award_year igs_co_prev_reqs.award_year%TYPE;
1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;
1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;
1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;
1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;
1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;
1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;

Line 1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;

1877: l_current_content_id igs_co_prev_reqs.current_content_id%TYPE;
1878: l_award_year igs_co_prev_reqs.award_year%TYPE;
1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;
1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;
1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;
1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;
1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;
1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;
1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;

Line 1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;

1878: l_award_year igs_co_prev_reqs.award_year%TYPE;
1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;
1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;
1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;
1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;
1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;
1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;
1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;
1886: l_destination igs_co_prev_reqs.destination%TYPE;

Line 1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;

1879: l_sys_ltr_code igs_co_prev_reqs.sys_ltr_code%TYPE;
1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;
1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;
1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;
1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;
1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;
1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;
1886: l_destination igs_co_prev_reqs.destination%TYPE;
1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;

Line 1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;

1880: l_adm_appl_number igs_co_prev_reqs.adm_appl_number%TYPE;
1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;
1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;
1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;
1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;
1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;
1886: l_destination igs_co_prev_reqs.destination%TYPE;
1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;
1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;

Line 1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;

1881: l_nominated_course_cd igs_co_prev_reqs.nominated_course_cd%TYPE;
1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;
1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;
1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;
1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;
1886: l_destination igs_co_prev_reqs.destination%TYPE;
1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;
1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;
1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;

Line 1886: l_destination igs_co_prev_reqs.destination%TYPE;

1882: l_appl_sequence_number igs_co_prev_reqs.appl_sequence_number%TYPE;
1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;
1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;
1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;
1886: l_destination igs_co_prev_reqs.destination%TYPE;
1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;
1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;
1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;
1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;

Line 1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;

1883: l_fulfillment_req igs_co_prev_reqs.fulfillment_req%TYPE;
1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;
1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;
1886: l_destination igs_co_prev_reqs.destination%TYPE;
1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;
1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;
1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;
1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;
1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;

Line 1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;

1884: l_crm_user_id igs_co_prev_reqs.crm_user_id%TYPE;
1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;
1886: l_destination igs_co_prev_reqs.destination%TYPE;
1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;
1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;
1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;
1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;
1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;
1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;

Line 1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;

1885: l_media_type igs_co_prev_reqs.media_type_code%TYPE;
1886: l_destination igs_co_prev_reqs.destination%TYPE;
1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;
1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;
1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;
1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;
1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;
1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;
1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;

Line 1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;

1886: l_destination igs_co_prev_reqs.destination%TYPE;
1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;
1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;
1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;
1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;
1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;
1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;
1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;
1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;

Line 1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;

1887: l_fax_number igs_co_prev_reqs.fax_number%TYPE;
1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;
1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;
1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;
1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;
1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;
1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;
1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;
1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;

Line 1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;

1888: l_reply_days igs_co_prev_reqs.reply_days%TYPE;
1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;
1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;
1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;
1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;
1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;
1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;
1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;
1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;

Line 1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;

1889: l_panel_code igs_co_prev_reqs.panel_code%TYPE;
1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;
1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;
1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;
1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;
1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;
1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;
1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;
1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;

Line 1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;

1890: l_org_unit_id igs_co_prev_reqs.org_unit_id%TYPE;
1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;
1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;
1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;
1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;
1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;
1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;
1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;
1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;

Line 1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;

1891: l_awd_cal_type igs_co_prev_reqs.awd_cal_type%TYPE;
1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;
1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;
1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;
1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;
1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;
1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;
1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;
1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;

Line 1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;

1892: l_awd_ci_seq_number igs_co_prev_reqs.awd_ci_seq_number%TYPE;
1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;
1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;
1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;
1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;
1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;
1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;
1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;
1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;

Line 1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;

1893: l_originalversion_id igs_co_prev_reqs.original_version_id%TYPE;
1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;
1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;
1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;
1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;
1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;
1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;
1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;

Line 1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;

1894: l_currentversion_id igs_co_prev_reqs.current_version_id%TYPE;
1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;
1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;
1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;
1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;
1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;
1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;
1902: -- Person details...

Line 1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;

1895: l_email_subject igs_co_prev_reqs.email_subject%TYPE;
1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;
1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;
1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;
1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;
1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;
1902: -- Person details...
1903: l_full_name igs_pe_person_base_v.full_name%TYPE;

Line 1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;

1896: l_original_content_xml igs_co_prev_reqs.original_content_xml%TYPE;
1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;
1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;
1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;
1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;
1902: -- Person details...
1903: l_full_name igs_pe_person_base_v.full_name%TYPE;
1904: l_person_number igs_pe_person_base_v.person_number%TYPE;

Line 1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;

1897: l_current_content_xml igs_co_prev_reqs.current_content_xml%TYPE;
1898: l_ff_request_hist_id igs_co_prev_reqs.ff_request_hist_id%TYPE;
1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;
1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;
1902: -- Person details...
1903: l_full_name igs_pe_person_base_v.full_name%TYPE;
1904: l_person_number igs_pe_person_base_v.person_number%TYPE;
1905: -- Version

Line 1986: -- Update the IGS_CO_PREV_REQS table to identify this request as fulfilled...

1982: l_currentversion_id
1983: );
1984: FETCH c_content_version INTO l_version;
1985: CLOSE c_content_version;
1986: -- Update the IGS_CO_PREV_REQS table to identify this request as fulfilled...
1987: UPDATE igs_co_prev_reqs
1988: SET request_status_code = 'DISTRIBUTED'
1989: WHERE distribution_id = p_distribution_id;
1990:

Line 1987: UPDATE igs_co_prev_reqs

1983: );
1984: FETCH c_content_version INTO l_version;
1985: CLOSE c_content_version;
1986: -- Update the IGS_CO_PREV_REQS table to identify this request as fulfilled...
1987: UPDATE igs_co_prev_reqs
1988: SET request_status_code = 'DISTRIBUTED'
1989: WHERE distribution_id = p_distribution_id;
1990:
1991: -- Call the post processing procedure (this will log the IGS Interaction History details)...