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_PROJECTS_ALL

Line 63: l_PrevProjectId pa_projects_all.project_id%type := Null;

59: X_PrvdrOrgIdTab IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
60: X_Error_Stage OUT NOCOPY VARCHAR2,
61: X_Error_Code OUT NOCOPY NUMBER) IS
62:
63: l_PrevProjectId pa_projects_all.project_id%type := Null;
64: l_project_org_id pa_projects_all.org_id%type := Null;
65: l_recvr_organization_id pa_projects_all.org_id%type := Null;
66: l_prev_recvr_organization_id pa_projects_all.org_id%type := Null;
67: l_prev_cc_prj_process_flag varchar2(10);

Line 64: l_project_org_id pa_projects_all.org_id%type := Null;

60: X_Error_Stage OUT NOCOPY VARCHAR2,
61: X_Error_Code OUT NOCOPY NUMBER) IS
62:
63: l_PrevProjectId pa_projects_all.project_id%type := Null;
64: l_project_org_id pa_projects_all.org_id%type := Null;
65: l_recvr_organization_id pa_projects_all.org_id%type := Null;
66: l_prev_recvr_organization_id pa_projects_all.org_id%type := Null;
67: l_prev_cc_prj_process_flag varchar2(10);
68: l_cc_prj_process_flag varchar2(10);

Line 65: l_recvr_organization_id pa_projects_all.org_id%type := Null;

61: X_Error_Code OUT NOCOPY NUMBER) IS
62:
63: l_PrevProjectId pa_projects_all.project_id%type := Null;
64: l_project_org_id pa_projects_all.org_id%type := Null;
65: l_recvr_organization_id pa_projects_all.org_id%type := Null;
66: l_prev_recvr_organization_id pa_projects_all.org_id%type := Null;
67: l_prev_cc_prj_process_flag varchar2(10);
68: l_cc_prj_process_flag varchar2(10);
69: l_PrevRecvrOrgId pa_projects_all.org_id%type := Null;

Line 66: l_prev_recvr_organization_id pa_projects_all.org_id%type := Null;

62:
63: l_PrevProjectId pa_projects_all.project_id%type := Null;
64: l_project_org_id pa_projects_all.org_id%type := Null;
65: l_recvr_organization_id pa_projects_all.org_id%type := Null;
66: l_prev_recvr_organization_id pa_projects_all.org_id%type := Null;
67: l_prev_cc_prj_process_flag varchar2(10);
68: l_cc_prj_process_flag varchar2(10);
69: l_PrevRecvrOrgId pa_projects_all.org_id%type := Null;
70: l_MinRecs PLS_INTEGER;

Line 69: l_PrevRecvrOrgId pa_projects_all.org_id%type := Null;

65: l_recvr_organization_id pa_projects_all.org_id%type := Null;
66: l_prev_recvr_organization_id pa_projects_all.org_id%type := Null;
67: l_prev_cc_prj_process_flag varchar2(10);
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;

Line 76: l_prevexporgid pa_projects_all.org_id%type := Null;

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;
80: l_current_org_id pa_projects_all.org_id%type := Null;

Line 80: l_current_org_id pa_projects_all.org_id%type := Null;

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;
80: l_current_org_id pa_projects_all.org_id%type := Null;
81: l_PrevPrvdrOrgId pa_projects_all.org_id%type := Null;
82:
83:
84: BEGIN

Line 81: l_PrevPrvdrOrgId 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;
80: l_current_org_id pa_projects_all.org_id%type := Null;
81: l_PrevPrvdrOrgId pa_projects_all.org_id%type := Null;
82:
83:
84: BEGIN
85: pa_cc_utils.set_curr_function('PA_CC_IDENTIFY_TXN_FI');

Line 165: pa_projects_all p

161: p.cc_process_nl_flag)
162: INTO l_recvr_organization_id,
163: l_cc_prj_process_flag
164: FROM pa_system_linkages sl,
165: pa_projects_all p
166: WHERE p.project_id = P_ProjectIdTab(j)
167: AND sl.function = P_SysLinkTab(j) ;
168:
169: l_PrevProjectId := P_ProjectIdTab(j);

Line 816: pa_projects_all p,

812: INTO l_recvr_organization_id,
813: l_project_org_id,
814: l_cc_prj_process_flag
815: FROM pa_system_linkages sl,
816: pa_projects_all p,
817: pa_tasks t
818: WHERE p.project_id = t.project_id
819: AND t.task_id = P_TaskIdTab(j)
820: AND sl.function = P_SysLinkTab(j) ;