APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_PROJECTS_ALL

Line 30: ,x_org_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895

26:
27: PROCEDURE get_org_project_info
28: ( p_organization_id IN hr_organization_units.organization_id%TYPE
29: := NULL
30: ,x_org_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
33:
34: PROCEDURE get_org_task_info

Line 35: ( p_project_id IN pa_projects_all.project_id%TYPE

31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
33:
34: PROCEDURE get_org_task_info
35: ( p_project_id IN pa_projects_all.project_id%TYPE
36: := NULL
37: ,x_org_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
38: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
39: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 69: ( p_project_id IN pa_projects_all.project_id%TYPE

65: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
67:
68: PROCEDURE get_probability_percent
69: ( p_project_id IN pa_projects_all.project_id%TYPE
70: := NULL
71: ,x_prob_percent OUT NOCOPY pa_probability_members.probability_percentage%TYPE --File.Sql.39 bug 4440895
72: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 75: ( p_project_id IN pa_projects_all.project_id%TYPE

71: ,x_prob_percent OUT NOCOPY pa_probability_members.probability_percentage%TYPE --File.Sql.39 bug 4440895
72: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
74: PROCEDURE get_period_profile
75: ( p_project_id IN pa_projects_all.project_id%TYPE
76: := NULL
77: ,p_period_profile_type IN pa_proj_period_profiles.period_profile_type%TYPE
78: := NULL
79: ,p_plan_period_type IN pa_forecasting_options.org_fcst_period_type%TYPE

Line 93: ( p_project_id IN pa_projects_all.project_id%TYPE

89: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
91:
92: FUNCTION check_org_proj_template
93: ( p_project_id IN pa_projects_all.project_id%TYPE
94: := NULL
95: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
97: RETURN VARCHAR2;

Line 107: ( p_project_id IN pa_projects_all.project_id%TYPE

103: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
104: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
105:
106: FUNCTION check_org_project
107: ( p_project_id IN pa_projects_all.project_id%TYPE
108: := NULL
109: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
110: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
111: RETURN VARCHAR2;

Line 125: ( p_project_id IN pa_projects_all.project_id%TYPE,

121: RETURN NUMBER;
122:
123: /* Dlai 04/21/02 -- added procedure detect_org_project */
124: PROCEDURE detect_org_project
125: ( p_project_id IN pa_projects_all.project_id%TYPE,
126: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
127: x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128:
129: /* Dlai 04/25/02 -- added function same_org_id and procedure check_same_org_id */

Line 134: (p_project_id IN pa_projects_all.project_id%TYPE)

130: /* 07/13/05 -- commented out same_org_id and check_same_org_id, because */
131: /* in R12, CLIENT_INFO should no longer be used */
132: /*
133: FUNCTION same_org_id
134: (p_project_id IN pa_projects_all.project_id%TYPE)
135: RETURN VARCHAR2;
136:
137: PROCEDURE check_same_org_id
138: (p_project_id IN pa_projects_all.project_id%TYPE,

Line 138: (p_project_id IN pa_projects_all.project_id%TYPE,

134: (p_project_id IN pa_projects_all.project_id%TYPE)
135: RETURN VARCHAR2;
136:
137: PROCEDURE check_same_org_id
138: (p_project_id IN pa_projects_all.project_id%TYPE,
139: x_return_status OUT VARCHAR2,
140: x_msg_count OUT NUMBER,
141: x_msg_data OUT VARCHAR2);
142: */

Line 150: ( p_project_id IN pa_projects_all.project_id%TYPE

146: * returns 'N' if project is not an org project
147: * returns 'E' if there is an exception error
148: */
149: FUNCTION is_org_project
150: ( p_project_id IN pa_projects_all.project_id%TYPE
151: := NULL)
152: RETURN VARCHAR2;
153:
154: END pa_fp_org_fcst_utils;