DBA Data[Home] [Help]

APPS.GCS_XML_GEN_PKG dependencies on GCS_WF_NTF_PKG

Line 2197: gcs_wf_ntf_pkg.raise_status_notification(

2193: 'generate_entry_xml Entry_id ='|| l_stat_entry_id || ' category= ' ||p_category_code);
2194: END IF;
2195: END IF; */
2196: IF (l_request_error_code NOT IN ('COMPLETED', 'N/A')) THEN
2197: gcs_wf_ntf_pkg.raise_status_notification(
2198: p_cons_detail_id => p_run_detail_id);
2199: END IF;
2200: /*ELSIF (p_category_code = 'AGGREGATION') THEN
2201: IF l_entry_id IS NOT NULL THEN

Line 2223: gcs_wf_ntf_pkg.raise_status_notification(

2219: 'generate_entry_xml Entry_id ='|| l_entry_id || ' category= ' ||p_category_code);
2220: END IF;
2221: END IF;*/
2222: IF (l_request_error_code NOT IN ('COMPLETED', 'N/A')) THEN
2223: gcs_wf_ntf_pkg.raise_status_notification(
2224: p_cons_detail_id => p_run_detail_id);
2225: END IF;
2226: ELSE
2227: IF (l_entry_list.FIRST IS NOT NULL AND l_entry_list.LAST IS NOT NULL) THEN

Line 2244: gcs_wf_ntf_pkg.raise_status_notification(

2240: END IF;
2241: END LOOP;*/
2242: FOR l_index IN l_entry_list.FIRST..l_entry_list.LAST LOOP
2243: IF (l_request_error_list(l_index) NOT IN ('COMPLETED', 'N/A')) THEN
2244: gcs_wf_ntf_pkg.raise_status_notification(
2245: p_cons_detail_id => l_run_detail_list(l_index));
2246: END IF;
2247: END LOOP;
2248: END IF;