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_CC_IDENT dependencies on PA_IMPLEMENTATIONS_ALL

Line 72: l_current_process_io_code pa_implementations_all.cc_process_io_code%type;

68: l_cc_prj_process_flag varchar2(10);
69: l_PrevRecvrOrgId pa_projects_all.org_id%type := Null;
70: l_MinRecs PLS_INTEGER;
71: l_MaxRecs PLS_INTEGER;
72: l_current_process_io_code pa_implementations_all.cc_process_io_code%type;
73: l_current_process_iu_code pa_implementations_all.cc_process_iu_code%type;
74: l_PrevCCProcessIOCode pa_implementations_all.cc_process_io_code%type;
75: l_PrevCCProcessIUCode pa_implementations_all.cc_process_iu_code%type;
76: l_prevexporgid pa_projects_all.org_id%type := Null;

Line 73: l_current_process_iu_code pa_implementations_all.cc_process_iu_code%type;

69: l_PrevRecvrOrgId pa_projects_all.org_id%type := Null;
70: l_MinRecs PLS_INTEGER;
71: l_MaxRecs PLS_INTEGER;
72: l_current_process_io_code pa_implementations_all.cc_process_io_code%type;
73: l_current_process_iu_code pa_implementations_all.cc_process_iu_code%type;
74: l_PrevCCProcessIOCode pa_implementations_all.cc_process_io_code%type;
75: l_PrevCCProcessIUCode pa_implementations_all.cc_process_iu_code%type;
76: l_prevexporgid pa_projects_all.org_id%type := Null;
77: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 74: l_PrevCCProcessIOCode pa_implementations_all.cc_process_io_code%type;

70: l_MinRecs PLS_INTEGER;
71: l_MaxRecs PLS_INTEGER;
72: l_current_process_io_code pa_implementations_all.cc_process_io_code%type;
73: l_current_process_iu_code pa_implementations_all.cc_process_iu_code%type;
74: l_PrevCCProcessIOCode pa_implementations_all.cc_process_io_code%type;
75: l_PrevCCProcessIUCode pa_implementations_all.cc_process_iu_code%type;
76: l_prevexporgid pa_projects_all.org_id%type := Null;
77: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
78: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 75: l_PrevCCProcessIUCode pa_implementations_all.cc_process_iu_code%type;

71: l_MaxRecs PLS_INTEGER;
72: l_current_process_io_code pa_implementations_all.cc_process_io_code%type;
73: l_current_process_iu_code pa_implementations_all.cc_process_iu_code%type;
74: l_PrevCCProcessIOCode pa_implementations_all.cc_process_io_code%type;
75: l_PrevCCProcessIUCode pa_implementations_all.cc_process_iu_code%type;
76: l_prevexporgid pa_projects_all.org_id%type := Null;
77: l_CCProcessIOCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
78: l_CCProcessIUCodeTab PA_PLSQL_DATATYPES.Char1TabTyp;
79: l_CCPrjFlagTab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 121: FROM pa_implementations_all imp

117: nvl(imp.cc_process_iu_code,'N')
118: INTO l_current_org_id,
119: l_current_process_io_code,
120: l_current_process_iu_code
121: FROM pa_implementations_all imp
122: WHERE imp.org_id = P_ExpOrgidTab(j) ; -- bug 5365276
123: -- WHERE nvl(imp.org_id,-99) = nvl( P_ExpOrgidTab(j), -99) ; -- bug 5365276
124:
125:

Line 909: FROM pa_implementations_all imp

905: SELECT nvl(imp.cc_process_io_code,'N'),
906: nvl(imp.cc_process_iu_code,'N')
907: INTO l_cc_process_io_code,
908: l_cc_process_iu_code
909: FROM pa_implementations_all imp
910: WHERE imp.org_id = nvl(P_ExpOrgidTab(j), l_current_org_id) ;
911:
912: END IF;
913: IF P_DEBUG_MODE THEN