APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_ORG_CERT_AGGR_PKG

Line 204: amw_org_cert_aggr_pkg.populate_full_hierarchies(l_errbuf,l_retcode,l_cert_id);

200: FETCH c_fch_vs_id into l_fch_vs_id;
201: CLOSE c_fch_vs_id;
202:
203: IF fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT') = to_char(l_fch_vs_id) THEN
204: amw_org_cert_aggr_pkg.populate_full_hierarchies(l_errbuf,l_retcode,l_cert_id);
205: END IF;
206:
207: commit;
208: Return 'SUCCESS';

Line 1199: amw_org_cert_aggr_pkg.update_org_cert_aggr_rows(FCH_Get_cert_info_rec.certification_id, l_fch_org_id);

1195:
1196: IF fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT') = to_char(l_fch_vs_id) THEN
1197:
1198: FOR FCH_Get_cert_info_rec IN FCH_Get_cert_info(l_fch_org_id) LOOP
1199: amw_org_cert_aggr_pkg.update_org_cert_aggr_rows(FCH_Get_cert_info_rec.certification_id, l_fch_org_id);
1200: END LOOP;
1201:
1202:
1203: END IF;

Line 1978: amw_org_cert_aggr_pkg.update_org_cert_aggr_rows(l_fch_cert_id, l_fch_org_id);

1974: FETCH c_fch_vs_id into l_fch_vs_id;
1975: CLOSE c_fch_vs_id;
1976:
1977: IF fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT') = to_char(l_fch_vs_id) THEN
1978: amw_org_cert_aggr_pkg.update_org_cert_aggr_rows(l_fch_cert_id, l_fch_org_id);
1979: END IF;
1980:
1981: -- somehow the change was not being committed to db without
1982: -- the following commit. so we temporarily put commit here, and we