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

Line 142: l_project_type pa_projects_all.project_type%TYPE;

138:
139: l_organization_id hr_organization_units.organization_id%TYPE;
140: l_project_status_code pa_project_statuses.project_status_code%TYPE;
141: l_project_id pa_projects.project_id%TYPE;
142: l_project_type pa_projects_all.project_type%TYPE;
143: l_project_number_out pa_projects.segment1%TYPE;
144: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
145: l_team_template_id pa_team_templates.team_template_id%TYPE;
146: l_country_code pa_locations.country_code%TYPE;

Line 165: From pa_projects_all

161:
162: CURSOR l_project_csr (c_project_id NUMBER)
163: Is
164: Select project_type
165: From pa_projects_all
166: Where project_id = c_project_id;
167:
168: BEGIN
169:

Line 1612: l_project_type pa_projects_all.project_type%TYPE;

1608: l_data VARCHAR2(250);
1609: l_msg_index_out NUMBER;
1610: l_dummy VARCHAR2(1);
1611: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
1612: l_project_type pa_projects_all.project_type%TYPE;
1613: l_expected_approval_date DATE;
1614: l_opportunity_value NUMBER;
1615: l_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1616:

Line 1621: From pa_projects_all pr, pa_project_opp_attrs op

1617: CURSOR c1
1618: IS
1619: Select pr.project_type, pr.probability_member_id, pr.expected_approval_date,
1620: op.opportunity_value, op.opp_value_currency_code
1621: From pa_projects_all pr, pa_project_opp_attrs op
1622: Where pr.project_id = op.project_id
1623: AND pr.project_id = p_project_id;
1624:
1625: v_c1 c1%ROWTYPE;

Line 2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

2621: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
2622: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
2623: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
2624: -- p_project_id IN NUMBER Required
2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR

Line 2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

2622: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
2623: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
2624: -- p_project_id IN NUMBER Required
2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

2623: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
2624: -- p_project_id IN NUMBER Required
2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

Line 2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM

2624: -- p_project_id IN NUMBER Required
2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

Line 2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR

2625: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2626: -- p_avail_match_weighting IN pa_projects_all.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

Line 2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

2627: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2628: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM
2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2634: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

2629: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR
2630: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2634: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2636: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2637: -- p_record_version_number IN NUMBER Required

Line 2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

2631: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2634: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2636: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2637: -- p_record_version_number IN NUMBER Required
2638: -- x_return_status OUT VARCHAR2 Required
2639: -- x_msg_count OUT NUMBER Required

Line 2636: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

2632: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2633: -- p_search_exp_start_org_id IN pa_projects_all.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2634: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2635: -- p_search_min_candidate_score IN pa_projects_all.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2636: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2637: -- p_record_version_number IN NUMBER Required
2638: -- x_return_status OUT VARCHAR2 Required
2639: -- x_msg_count OUT NUMBER Required
2640: -- x_msg_data OUT VARCHAR2 Required

Line 2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,

2653: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
2654: p_debug_mode IN VARCHAR2 := 'N' ,
2655: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
2656: p_project_id IN NUMBER ,
2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,

Line 2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,

2654: p_debug_mode IN VARCHAR2 := 'N' ,
2655: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
2656: p_project_id IN NUMBER ,
2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,

Line 2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,

2655: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
2656: p_project_id IN NUMBER ,
2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,

Line 2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,

2656: p_project_id IN NUMBER ,
2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,

Line 2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,

2657: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
2658: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,

Line 2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,

2659: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
2660: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
2666: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

Line 2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,

2661: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
2662: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
2666: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
2668: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
2669: p_record_version_number IN NUMBER ,

Line 2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

2663: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
2666: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
2668: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
2669: p_record_version_number IN NUMBER ,
2670: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
2671: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 2668: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,

2664: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
2665: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
2666: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
2667: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
2668: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
2669: p_record_version_number IN NUMBER ,
2670: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
2671: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
2672: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2690: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;

2686: l_data VARCHAR2(250);
2687: l_msg_index_out NUMBER;
2688: l_dummy VARCHAR2(1);
2689:
2690: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2691: l_search_country_code pa_projects_all.search_country_code%TYPE;
2692: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2693:
2694: BEGIN

Line 2691: l_search_country_code pa_projects_all.search_country_code%TYPE;

2687: l_msg_index_out NUMBER;
2688: l_dummy VARCHAR2(1);
2689:
2690: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2691: l_search_country_code pa_projects_all.search_country_code%TYPE;
2692: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2693:
2694: BEGIN
2695:

Line 2692: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;

2688: l_dummy VARCHAR2(1);
2689:
2690: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2691: l_search_country_code pa_projects_all.search_country_code%TYPE;
2692: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2693:
2694: BEGIN
2695:
2696: IF p_commit = FND_API.G_TRUE THEN

Line 3379: FROM pa_projects_all

3375: ,attribute9
3376: ,attribute10
3377: ,pm_product_code
3378: ,segment1 -- 3671408 added column to retrieve project number value
3379: FROM pa_projects_all
3380: WHERE project_id = p_project_id;
3381:
3382: CURSOR cur_get_project_status_code( c_project_id IN NUMBER ) IS
3383: SELECT project_status_code

Line 3384: FROM pa_projects_all

3380: WHERE project_id = p_project_id;
3381:
3382: CURSOR cur_get_project_status_code( c_project_id IN NUMBER ) IS
3383: SELECT project_status_code
3384: FROM pa_projects_all
3385: WHERE project_id = c_project_id;
3386:
3387: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
3388: SELECT pps.project_system_status_code

Line 3592: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');

3588: X_LAST_UPDATE_DATE => sysdate,
3589: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3590:
3591: IF (l_debug_mode = 'Y') THEN
3592: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');
3593: END IF;
3594:
3595: /*Stubbed Out Auto Initiate Demand On Project Approval Functionality
3596: Bug 3819086 */

Line 3620: FROM PA_PROJECTS_ALL

3616:
3617: END;
3618:
3619: SELECT wf_status_code INTO l_wf_status_code
3620: FROM PA_PROJECTS_ALL
3621: WHERE project_id = p_project_id;
3622:
3623: IF (l_debug_mode = 'Y') THEN
3624: Pa_Debug.WRITE(G_PKG_NAME,'l_wf_status_code ='||l_wf_status_code,

Line 3634: UPDATE pa_projects_all

3630: -- 4364878 : if new system status corresponds to CLOSED
3631: -- Then Populate the closed date as sysdate
3632:
3633: IF l_new_sys_status = 'CLOSED' THEN
3634: UPDATE pa_projects_all
3635: SET wf_status_code = NULL
3636: ,project_status_code = p_new_status_code
3637: ,closed_date = sysdate
3638: ,last_update_date = sysdate

Line 3644: UPDATE pa_projects_all

3640: ,last_update_login = fnd_global.login_id
3641: WHERE project_id = p_project_id;
3642: ELSE
3643:
3644: UPDATE pa_projects_all
3645: SET wf_status_code = NULL
3646: ,project_status_code = p_new_status_code --Added for bug 3818322
3647: /*4364878 : Included update of who columns also*/
3648: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL

Line 3661: -- Update wf status in pa_projects_all

3657:
3658:
3659: ELSIF l_wf_status_code IS NULL THEN -- Made ELSEIF against the existing IF, for BUG# 6661144
3660: IF l_wf_enabled_flag = 'Y' THEN
3661: -- Update wf status in pa_projects_all
3662:
3663: -- 4364878 : if new system status corresponds to CLOSED
3664: -- Then Populate the closed date as sysdate
3665:

Line 3667: UPDATE pa_projects_all

3663: -- 4364878 : if new system status corresponds to CLOSED
3664: -- Then Populate the closed date as sysdate
3665:
3666: If l_new_sys_status = 'CLOSED' THEN
3667: UPDATE pa_projects_all
3668: SET wf_status_code = 'IN_ROUTE'
3669: ,project_status_code = p_new_status_code
3670: ,closed_date = sysdate
3671: ,last_update_date = sysdate

Line 3677: UPDATE pa_projects_all

3673: ,last_update_login = fnd_global.login_id
3674: WHERE project_id = p_project_id;
3675: ELSE
3676:
3677: UPDATE pa_projects_all
3678: SET wf_status_code = 'IN_ROUTE'
3679: ,project_status_code = p_new_status_code --Added for bug 3818322
3680: /*4364878 : Included update of who columns also*/
3681: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL

Line 3716: UPDATE pa_projects_all

3712: -- 4364878 : if new system status corresponds to CLOSED
3713: -- Then Populate the closed date as sysdate
3714: If l_new_sys_status = 'CLOSED' THEN
3715:
3716: UPDATE pa_projects_all
3717: SET project_status_code = p_new_status_code
3718: ,closed_date = sysdate
3719: ,last_update_date = sysdate
3720: ,last_updated_by = fnd_global.user_id

Line 3726: UPDATE pa_projects_all

3722: WHERE project_id = p_project_id ;
3723:
3724: Else
3725:
3726: UPDATE pa_projects_all
3727: SET project_status_code = p_new_status_code
3728: /*4364878 : Included update of who columns also*/
3729: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3730: ,last_update_date = sysdate