DBA Data[Home] [Help]

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 972: FROM pa_implementations_all imp

968: SELECT nvl(imp.cc_process_io_code,'N'),
969: nvl(imp.cc_process_iu_code,'N')
970: INTO l_cc_process_io_code,
971: l_cc_process_iu_code
972: FROM pa_implementations_all imp
973: WHERE imp.org_id = nvl(P_ExpOrgidTab(j), l_current_org_id) ;
974:
975: END IF;
976: IF P_DEBUG_MODE THEN

Line 1752: pa_implementations_all i

1748: SELECT h.default_legal_context_id
1749: INTO l_legal_entity_id
1750: FROM hr_operating_units h,
1751: xle_entity_profiles xep,
1752: pa_implementations_all i
1753: WHERE i.org_id = p_org_id
1754: AND i.org_id = h.organization_id
1755: AND h.default_legal_context_id = xep.legal_entity_id;
1756: