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_FP_ORG_FCST_UTILS dependencies on PA_PROJECTS_ALL

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

214:
215: PROCEDURE get_org_project_info
216: ( p_organization_id IN hr_organization_units.organization_id%TYPE
217: := NULL
218: ,x_org_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
219: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
220: ,x_err_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
221: ) is
222: l_stage NUMBER := 0;

Line 286: ( p_project_id IN pa_projects_all.project_id%TYPE

282: pa_debug.reset_err_stack;
283: END get_org_project_info;
284:
285: PROCEDURE get_org_task_info
286: ( p_project_id IN pa_projects_all.project_id%TYPE
287: := NULL
288: ,x_org_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
289: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
290: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 569: ( p_project_id IN pa_projects_all.project_id%TYPE

565: pa_debug.reset_err_stack;
566: END get_headcount;
567:
568: PROCEDURE get_probability_percent
569: ( p_project_id IN pa_projects_all.project_id%TYPE
570: := NULL
571: ,x_prob_percent OUT NOCOPY pa_probability_members.probability_percentage%TYPE --File.Sql.39 bug 4440895
572: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
573: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 576: l_probability_member_id pa_projects_all.probability_member_id%TYPE;

572: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
573: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
574: IS
575: l_debug_mode VARCHAR2(30);
576: l_probability_member_id pa_projects_all.probability_member_id%TYPE;
577: BEGIN
578: IF P_PA_DEBUG_MODE = 'Y' THEN
579: pa_debug.init_err_stack('PA_FP_ORG_FCST_UTILS.get_probability_percent');
580: END IF;

Line 591: FROM pa_projects_all

587: END IF;
588:
589: SELECT nvl(probability_member_id,-99)
590: INTO l_probability_member_id
591: FROM pa_projects_all
592: WHERE project_id = p_project_id;
593:
594: IF l_probability_member_id < 0 THEN
595: x_prob_percent := 100;

Line 626: ( p_project_id IN pa_projects_all.project_id%TYPE

622: pa_debug.reset_err_stack;
623: END get_probability_percent;
624:
625: PROCEDURE get_period_profile
626: ( p_project_id IN pa_projects_all.project_id%TYPE
627: := NULL
628: ,p_period_profile_type IN pa_proj_period_profiles.period_profile_type%TYPE
629: := NULL
630: ,p_plan_period_type IN pa_forecasting_options.org_fcst_period_type%TYPE

Line 701: ( p_project_id IN pa_projects_all.project_id%TYPE

697: pa_debug.reset_err_stack;
698: END get_period_profile;
699:
700: FUNCTION check_org_proj_template
701: ( p_project_id IN pa_projects_all.project_id%TYPE
702: := NULL
703: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
704: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
705: RETURN VARCHAR2 IS

Line 775: FROM Pa_Projects_All

771: IF p_project_id IS NOT NULL THEN
772: BEGIN
773: SELECT NVL(Org_Id,-99)
774: INTO l_org_id
775: FROM Pa_Projects_All
776: WHERE Project_Id = p_project_id;
777:
778: SELECT Default_Tp_Amount_Type
779: INTO x_tp_amount_type

Line 805: ( p_project_id IN pa_projects_all.project_id%TYPE

801: RAISE;
802: END Get_Tp_Amount_Type;
803:
804: FUNCTION check_org_project
805: ( p_project_id IN pa_projects_all.project_id%TYPE
806: := NULL
807: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
808: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
809: RETURN VARCHAR2 IS

Line 1513: ( p_project_id IN pa_projects_all.project_id%TYPE

1509: END calculate_pa_amount;
1510:
1511: /* dlai - added detect_org_project for use with project assignments 04/21/02 */
1512: procedure detect_org_project
1513: ( p_project_id IN pa_projects_all.project_id%TYPE
1514: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1515: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1516: is
1517:

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

1564: * in R12, CLIENT_INFO should no longer be used
1565: */
1566: /*
1567: FUNCTION same_org_id
1568: (p_project_id IN pa_projects_all.project_id%TYPE)
1569: return VARCHAR2 is
1570: l_login_org_id pa_projects_all.org_id%TYPE;
1571: l_project_org_id pa_projects_all.org_id%TYPE;
1572: l_login_org_id_data VARCHAR2(1000);

Line 1570: l_login_org_id pa_projects_all.org_id%TYPE;

1566: /*
1567: FUNCTION same_org_id
1568: (p_project_id IN pa_projects_all.project_id%TYPE)
1569: return VARCHAR2 is
1570: l_login_org_id pa_projects_all.org_id%TYPE;
1571: l_project_org_id pa_projects_all.org_id%TYPE;
1572: l_login_org_id_data VARCHAR2(1000);
1573: l_same_org_id VARCHAR2(1);
1574: org_id_endpoint NUMBER(15);

Line 1571: l_project_org_id pa_projects_all.org_id%TYPE;

1567: FUNCTION same_org_id
1568: (p_project_id IN pa_projects_all.project_id%TYPE)
1569: return VARCHAR2 is
1570: l_login_org_id pa_projects_all.org_id%TYPE;
1571: l_project_org_id pa_projects_all.org_id%TYPE;
1572: l_login_org_id_data VARCHAR2(1000);
1573: l_same_org_id VARCHAR2(1);
1574: org_id_endpoint NUMBER(15);
1575: BEGIN

Line 1585: from pa_projects_all

1581: l_same_org_id := 'N';
1582:
1583: select org_id, USERENV('CLIENT_INFO')
1584: into l_project_org_id, l_login_org_id_data
1585: from pa_projects_all
1586: where
1587: project_id=p_project_id;
1588:
1589: org_id_endpoint := INSTR(l_login_org_id_data, ' ');

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

1608: return('U');
1609: END same_org_id;
1610:
1611: PROCEDURE check_same_org_id
1612: (p_project_id IN pa_projects_all.project_id%TYPE,
1613: x_return_status OUT VARCHAR2,
1614: x_msg_count OUT NUMBER,
1615: x_msg_data OUT VARCHAR2)
1616: is

Line 1663: ( p_project_id IN pa_projects_all.project_id%TYPE

1659: * returns 'N' if project is not an org project
1660: * returns 'E' if there is an exception error
1661: */
1662: FUNCTION is_org_project
1663: ( p_project_id IN pa_projects_all.project_id%TYPE
1664: := NULL)
1665: RETURN VARCHAR2
1666: is
1667: l_org_project_exists varchar2(1);

Line 1673: FROM pa_projects_all pp,

1669:
1670: l_org_project_exists := 'N';
1671: SELECT 'Y'
1672: INTO l_org_project_exists
1673: FROM pa_projects_all pp,
1674: pa_project_types_all pt
1675: WHERE pp.project_id = p_project_id
1676: AND pt.project_type = pp.project_type
1677: AND pp.org_id = pt.org_id