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.

[Home] [Help]

APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_FIN_ORG_EVAL_SUM

Line 1900: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_org_eval_sum(p_certification_id => l_certification_id);

1896: IF p_certification_id IS NOT NULL THEN
1897:
1898: -- AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_cert_eval_sum(p_certification_id => l_certification_id) ;
1899: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_proc_eval_sum(p_certification_id => l_certification_id);
1900: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_org_eval_sum(p_certification_id => l_certification_id);
1901: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_cert_dashboard_sum(p_certification_id => l_certification_id);
1902: --AMW_FINSTMT_CERT_BES_PKG.reset_fin_all(p_certification_id => l_certification_id);
1903: amw_fin_coso_views_pvt.DELETE_ROWS(x_fin_certification_id => l_certification_id);
1904:

Line 1917: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_org_eval_sum(p_certification_id => cert_rec.certification_id);

1913: FOR cert_rec IN c_cert LOOP
1914: exit when c_cert%notfound;
1915: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_cert_eval_sum(p_certification_id => cert_rec.certification_id) ;
1916: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_proc_eval_sum(p_certification_id => cert_rec.certification_id);
1917: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_org_eval_sum(p_certification_id => cert_rec.certification_id);
1918: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_cert_dashboard_sum(p_certification_id => cert_rec.certification_id);
1919: --AMW_FINSTMT_CERT_BES_PKG.reset_fin_all(p_certification_id => cert_rec.certification_id);
1920: amw_fin_coso_views_pvt.DELETE_ROWS(x_fin_certification_id => cert_rec.certification_id);
1921:

Line 2897: UPDATE AMW_FIN_ORG_EVAL_SUM

2893: null;
2894: END;
2895: fnd_file.put_line(fnd_file.LOG, 'after open_findings:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2896:
2897: UPDATE AMW_FIN_ORG_EVAL_SUM
2898: SET EVAL_OPINION_ID = l_eval_opinion_id,
2899: PROC_PENDING_CERTIFICATION = l_proc_pending_cert,
2900: TOTAL_NUMBER_OF_PROCS = l_total_num_of_procs,
2901: PROC_CERTIFIED_WITH_ISSUES = l_proc_with_issue,

Line 2931: INSERT INTO AMW_FIN_ORG_EVAL_SUM(

2927:
2928:
2929:
2930: IF (SQL%NOTFOUND) THEN
2931: INSERT INTO AMW_FIN_ORG_EVAL_SUM(
2932: FIN_CERTIFICATION_ID,
2933: ORGANIZATION_ID,
2934: EVAL_OPINION_ID,
2935: PROC_PENDING_CERTIFICATION,

Line 3069: DELETE from AMW_FIN_ORG_EVAL_SUM orgevalsum

3065: OPEN c_period_date;
3066: FETCH c_period_date INTO l_start_date, l_end_date;
3067: CLOSE c_period_date;
3068:
3069: DELETE from AMW_FIN_ORG_EVAL_SUM orgevalsum
3070: where FIN_CERTIFICATION_ID = p_certification_id
3071: and not exists
3072: (SELECT 'Y'
3073: FROM AMW_ACCT_ASSOCIATIONS aa,

Line 3108: DELETE from AMW_FIN_ORG_EVAL_SUM orgevalsum

3104: Populate_Fin_Org_Eval_Sum(p_certification_id, l_start_date,
3105: l_end_date, org_rec.organization_id);
3106: END LOOP;
3107: ELSE
3108: DELETE from AMW_FIN_ORG_EVAL_SUM orgevalsum
3109: where not exists
3110: (SELECT 'Y'
3111: FROM AMW_ACCT_ASSOCIATIONS aa,
3112: AMW_FIN_ITEMS_KEY_ACC fika,