APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_PROCESS_CERT_SUMMARY

Line 155: AMW_PROCESS_CERT_SUMMARY.update_summary_table (

151:
152: -- do not need to update the prcess denorm for the existing
153: -- org.
154: FOR proc_rec IN c_new_proc(l_cert_id) LOOP
155: AMW_PROCESS_CERT_SUMMARY.update_summary_table (
156: p_certification_id => l_cert_id,
157: p_org_id => proc_rec.organization_id,
158: p_process_id => proc_rec.process_id);
159: END LOOP;

Line 178: AMW_PROCESS_CERT_SUMMARY.update_summary_table (

174:
175: -- to support proc hierarchy, need to update the proc denorm
176: -- for all the processes in the certification-organization.
177: FOR proc_rec IN c_org_proc(l_cert_id, l_org_id) LOOP
178: AMW_PROCESS_CERT_SUMMARY.update_summary_table (
179: p_certification_id => l_cert_id,
180: p_org_id => l_org_id,
181: p_process_id => proc_rec.process_id);
182: END LOOP;

Line 196: AMW_PROCESS_CERT_SUMMARY.Populate_Cert_General_Sum(

192:
193: OPEN c_start_date(l_cert_id);
194: FETCH c_start_date INTO l_start_date;
195: CLOSE c_start_date;
196: AMW_PROCESS_CERT_SUMMARY.Populate_Cert_General_Sum(
197: l_cert_id, l_start_date);
198:
199: OPEN c_fch_vs_id;
200: FETCH c_fch_vs_id into l_fch_vs_id;

Line 1170: --AMW_PROCESS_CERT_SUMMARY.POPULATE_ALL_CERT_SUMMARY

1166: -- IF (G_REFRESH_FLAG = 'Y') THEN
1167: --l_index := m_certification_list.FIRST;
1168: --WHILE l_index <= m_certification_list.LAST LOOP
1169:
1170: --AMW_PROCESS_CERT_SUMMARY.POPULATE_ALL_CERT_SUMMARY
1171: --(x_errbuf => l_msg_data,
1172: -- x_retcode => l_msg_count,
1173: -- p_certification_id => m_certification_list(l_index)
1174: --);

Line 1176: --AMW_PROCESS_CERT_SUMMARY.Populate_All_Cert_General_Sum

1172: -- x_retcode => l_msg_count,
1173: -- p_certification_id => m_certification_list(l_index)
1174: --);
1175:
1176: --AMW_PROCESS_CERT_SUMMARY.Populate_All_Cert_General_Sum
1177: --(errbuf => l_msg_data,
1178: -- retcode => l_msg_count,
1179: -- p_certification_id => m_certification_list(l_index)
1180: --);

Line 1949: --AMW_PROCESS_CERT_SUMMARY.POPULATE_ALL_CERT_SUMMARY

1945: --IF ((G_REFRESH_FLAG = 'Y') or (G_REFRESH_FLAG = 'y') ) THEN
1946: --l_index := m_certification_list.FIRST;
1947: --WHILE l_index <= m_certification_list.LAST LOOP
1948:
1949: --AMW_PROCESS_CERT_SUMMARY.POPULATE_ALL_CERT_SUMMARY
1950: --(x_errbuf => l_msg_data,
1951: -- x_retcode => l_msg_count,
1952: -- p_certification_id => m_certification_list(l_index)
1953: --);

Line 1956: --AMW_PROCESS_CERT_SUMMARY.Populate_All_Cert_General_Sum

1952: -- p_certification_id => m_certification_list(l_index)
1953: --);
1954:
1955:
1956: --AMW_PROCESS_CERT_SUMMARY.Populate_All_Cert_General_Sum
1957: --(errbuf => l_msg_data,
1958: -- retcode => l_msg_count,
1959: -- p_certification_id => m_certification_list(l_index)
1960: --);