[Home] [Help]
136: AND lookup_code = p_object_type;
137:
138: v_lup lup%ROWTYPE;
139:
140: -- 2564086: Modified to select from pa_projects_all.
141: CURSOR prj IS
142: SELECT p.name, p.segment1, p.project_type, s.project_status_name, p.description
143: FROM pa_projects_all p, pa_project_statuses s
144: WHERE p.project_status_code = s.project_status_code
139:
140: -- 2564086: Modified to select from pa_projects_all.
141: CURSOR prj IS
142: SELECT p.name, p.segment1, p.project_type, s.project_status_name, p.description
143: FROM pa_projects_all p, pa_project_statuses s
144: WHERE p.project_status_code = s.project_status_code
145: AND p.project_id = p_object_id1;
146:
147: v_prj prj%ROWTYPE;
538:
539: -- Cursor to get the probability list id for a project template
540: CURSOR cur_probability_list (p_template_id NUMBER ) IS
541: SELECT probability_list_id
542: FROM pa_project_types_all t, pa_projects_all p
543: --Added the org_id join for bug 5561036
544: WHERE t.org_id = p.org_id
545: AND p.project_id = p_template_id
546: AND t.project_type = p.project_type;
1655: p.project_value,
1656: p.record_version_number,
1657: p.org_id -- Added for Bug#3798344
1658: FROM
1659: pa_projects_all p,
1660: pa_project_statuses s ,
1661: pa_probability_members m ,
1662: pa_project_opp_attrs a
1663: WHERE p.project_status_code = s.project_status_code
1692: object_id1;
1693:
1694:
1695:
1696: l_project_name pa_projects_all.name%TYPE;
1697: l_project_number pa_projects_all.segment1%TYPE;
1698: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1699:
1700: -- Old pipeline project info.
1693:
1694:
1695:
1696: l_project_name pa_projects_all.name%TYPE;
1697: l_project_number pa_projects_all.segment1%TYPE;
1698: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1699:
1700: -- Old pipeline project info.
1701: l_project_value pa_projects_all.project_value%TYPE;
1697: l_project_number pa_projects_all.segment1%TYPE;
1698: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1699:
1700: -- Old pipeline project info.
1701: l_project_value pa_projects_all.project_value%TYPE;
1702: l_probability pa_probability_members.probability_percentage%TYPE;
1703: l_probability_list_id pa_probability_members.probability_list_id%TYPE;
1704: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
1705: l_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;
1703: l_probability_list_id pa_probability_members.probability_list_id%TYPE;
1704: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
1705: l_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;
1706: l_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1707: l_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1708:
1709: -- New pipeline project info.
1710: l_new_probability pa_probability_members.probability_percentage%TYPE;
1711: l_new_probability_member_id pa_probability_members.probability_member_id%TYPE;
1710: l_new_probability pa_probability_members.probability_percentage%TYPE;
1711: l_new_probability_member_id pa_probability_members.probability_member_id%TYPE;
1712: l_new_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;
1713: l_new_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1714: l_new_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1715:
1716: l_recipient_tab pa_plsql_datatypes.Char240TabTyp;
1717: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1718: l_lead_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2531: -- And close the project request after the project is created.
2532:
2533:
2534: PROCEDURE post_create_project(p_request_id IN pa_project_requests.request_id%TYPE,
2535: p_project_id IN pa_projects_all.project_id%TYPE,
2536: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2537: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2538: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2539: