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.AMW_FINSTMT_CERT_PVT dependencies on AMW_FINSTMT_CERT_BES_PKG

Line 27: anther package AMW_FINSTMT_CERT_BES_PKG, which is new pl/slq package from amw.d

23: after AMW.D
24: this package is composed of 2 procedures. one is main procedure, which is the similar as the one
25: before amw.d. but this new main procedure only calls one procedure which is Populate_All_Fin_Proc_Eval_Sum.
26: within in this one sub_procedure, we populate all of summary tables. note: all of logic are embeded in
27: anther package AMW_FINSTMT_CERT_BES_PKG, which is new pl/slq package from amw.d
28:
29: Major feature in AMW.D is 1) bussiness event 2) combine previous independent 4 procedures into 1 proceudre.
30: so the execution order is critical.
31:

Line 1898: -- AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_cert_eval_sum(p_certification_id => l_certification_id) ;

1894: l_certification_id := p_certification_id;
1895:
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);

Line 1899: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_proc_eval_sum(p_certification_id => l_certification_id);

1895:
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);

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 1901: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_cert_dashboard_sum(p_certification_id => l_certification_id);

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:
1905: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum

Line 1902: --AMW_FINSTMT_CERT_BES_PKG.reset_fin_all(p_certification_id => l_certification_id);

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:
1905: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum
1906: (p_certification_id => l_certification_id,

Line 1905: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum

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:
1905: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum
1906: (p_certification_id => l_certification_id,
1907: x_return_status => l_return_status,
1908: x_msg_count => l_msg_count,
1909: x_msg_data => l_msg_data);

Line 1915: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_cert_eval_sum(p_certification_id => cert_rec.certification_id) ;

1911:
1912: ELSE
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);

Line 1916: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_fin_proc_eval_sum(p_certification_id => cert_rec.certification_id);

1912: ELSE
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);

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 1918: --AMW_FINSTMT_CERT_BES_PKG.reset_amw_cert_dashboard_sum(p_certification_id => cert_rec.certification_id);

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:
1922: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum

Line 1919: --AMW_FINSTMT_CERT_BES_PKG.reset_fin_all(p_certification_id => cert_rec.certification_id);

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:
1922: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum
1923: (p_certification_id => cert_rec.certification_id,

Line 1922: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum

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:
1922: AMW_FINSTMT_CERT_BES_PKG.Master_Fin_Proc_Eval_Sum
1923: (p_certification_id => cert_rec.certification_id,
1924: x_return_status => l_return_status,
1925: x_msg_count => l_msg_count,
1926: x_msg_data => l_msg_data);

Line 1934: if(AMW_FINSTMT_CERT_BES_PKG.G_ORG_ERROR = 'Y')then

1930: END IF;
1931:
1932:
1933: /***05.25.2006 npanandi: bug 5250100 test***/
1934: if(AMW_FINSTMT_CERT_BES_PKG.G_ORG_ERROR = 'Y')then
1935: retcode := '1'; /**2 = EXCEPTION, 1 = WARNING, 0 = SUCCESS**/
1936: errbuf := 'Check out the Organizations';
1937: end if;
1938: /***05.25.2006 npanandi: bug 5250100 test ends***/