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.PA_REP_UTIL_GLOB dependencies on PA_ORG_HIERARCHY_DENORM

Line 262: * The checking of the last_update_date of pa_org_hierarchy_denorm is

258: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
259: END IF;
260: /*
261: * Bug 1810528
262: * The checking of the last_update_date of pa_org_hierarchy_denorm is
263: * to find if the the organization hierarchy changed during the run.
264: */
265: SELECT max(LAST_UPDATE_DATE)
266: INTO l_orghier_date_before

Line 267: FROM pa_org_hierarchy_denorm

263: * to find if the the organization hierarchy changed during the run.
264: */
265: SELECT max(LAST_UPDATE_DATE)
266: INTO l_orghier_date_before
267: FROM pa_org_hierarchy_denorm
268: WHERE pa_org_use_type = 'REPORTING'
269: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
270: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
271: ;

Line 274: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';

270: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
271: ;
272:
273: IF l_debug ='Y'THEN -- bug 2674619
274: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';
275: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
276:
277: PA_DEBUG.g_err_stage := '350 : Before calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 381: FROM pa_org_hierarchy_denorm

377: * Continuation of the check for Bug 1810528
378: */
379: SELECT max(LAST_UPDATE_DATE)
380: INTO l_orghier_date_after
381: FROM pa_org_hierarchy_denorm
382: WHERE pa_org_use_type = 'REPORTING'
383: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
384: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
385: ;

Line 405: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm after the run is <'||l_orghier_date_after||'>';

401: , p_write_file => 'OUT'
402: );
403: END IF;
404: IF l_debug ='Y'THEN -- bug 2674619
405: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm after the run is <'||l_orghier_date_after||'>';
406: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
407:
408: PA_DEBUG.g_err_stage := '750 : Exiting PA_REP_UTIL_GLOB.get_util_ac_parm';
409: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 604: * The checking of the last_update_date of pa_org_hierarchy_denorm is

600: END IF;
601:
602: /*
603: * Bug 1810528
604: * The checking of the last_update_date of pa_org_hierarchy_denorm is
605: * to find if the the organization hierarchy changed during the run.
606: */
607: SELECT max(LAST_UPDATE_DATE)
608: INTO l_orghier_date_before

Line 609: FROM pa_org_hierarchy_denorm

605: * to find if the the organization hierarchy changed during the run.
606: */
607: SELECT max(LAST_UPDATE_DATE)
608: INTO l_orghier_date_before
609: FROM pa_org_hierarchy_denorm
610: WHERE pa_org_use_type = 'REPORTING'
611: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
612: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.
613: G_org_structure_version_id

Line 616: PA_DEBUG.g_err_stage := '300 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';

612: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.
613: G_org_structure_version_id
614: ;
615: IF l_debug ='Y'THEN -- bug 2674619
616: PA_DEBUG.g_err_stage := '300 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';
617: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
618: PA_DEBUG.g_err_stage := '330 : Before calling PA_REP_UTIL_GLOB.Get_Effective_Start_Period_Num';
619: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
620: END IF;

Line 724: FROM pa_org_hierarchy_denorm

720: * Continuation of the check for Bug 1810528
721: */
722: SELECT max(LAST_UPDATE_DATE)
723: INTO l_orghier_date_after
724: FROM pa_org_hierarchy_denorm
725: WHERE pa_org_use_type = 'REPORTING'
726: AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
727: AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
728: ;

Line 748: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm after the run is <'||l_orghier_date_after||'>';

744: , p_write_file => 'OUT'
745: );
746: END IF;
747: IF l_debug ='Y'THEN -- bug 2674619
748: PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm after the run is <'||l_orghier_date_after||'>';
749: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
750:
751: PA_DEBUG.g_err_stage := '650 : Exiting PA_REP_UTIL_GLOB.get_util_fc_parm';
752: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);