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 2629: -- p_comp_match_weighting IN pa_projects_all.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2694: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;

2690: l_data VARCHAR2(250);
2691: l_msg_index_out NUMBER;
2692: l_dummy VARCHAR2(1);
2693:
2694: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2695: l_search_country_code pa_projects_all.search_country_code%TYPE;
2696: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2697:
2698: BEGIN

Line 2695: l_search_country_code pa_projects_all.search_country_code%TYPE;

2691: l_msg_index_out NUMBER;
2692: l_dummy VARCHAR2(1);
2693:
2694: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2695: l_search_country_code pa_projects_all.search_country_code%TYPE;
2696: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2697:
2698: BEGIN
2699:

Line 2696: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;

2692: l_dummy VARCHAR2(1);
2693:
2694: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
2695: l_search_country_code pa_projects_all.search_country_code%TYPE;
2696: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
2697:
2698: BEGIN
2699:
2700: IF p_commit = FND_API.G_TRUE THEN

Line 3383: FROM pa_projects_all

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

Line 3388: FROM pa_projects_all

3384: WHERE project_id = p_project_id;
3385:
3386: CURSOR cur_get_project_status_code( c_project_id IN NUMBER ) IS
3387: SELECT project_status_code
3388: FROM pa_projects_all
3389: WHERE project_id = c_project_id;
3390:
3391: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
3392: SELECT pps.project_system_status_code

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

3615: X_LAST_UPDATE_DATE => sysdate,
3616: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
3617:
3618: IF (l_debug_mode = 'Y') THEN
3619: pa_debug.debug('Updated PA_PROJECTS_ALL for status history');
3620: END IF;
3621:
3622: /*Stubbed Out Auto Initiate Demand On Project Approval Functionality
3623: Bug 3819086 */

Line 3647: FROM PA_PROJECTS_ALL

3643:
3644: END;
3645:
3646: SELECT wf_status_code INTO l_wf_status_code
3647: FROM PA_PROJECTS_ALL
3648: WHERE project_id = p_project_id;
3649:
3650: IF (l_debug_mode = 'Y') THEN
3651: Pa_Debug.WRITE(G_PKG_NAME,'l_wf_status_code ='||l_wf_status_code,

Line 3661: UPDATE pa_projects_all

3657: -- 4364878 : if new system status corresponds to CLOSED
3658: -- Then Populate the closed date as sysdate
3659:
3660: IF l_new_sys_status = 'CLOSED' THEN
3661: UPDATE pa_projects_all
3662: SET wf_status_code = NULL
3663: ,project_status_code = p_new_status_code
3664: ,closed_date = sysdate
3665: ,last_update_date = sysdate

Line 3671: UPDATE pa_projects_all

3667: ,last_update_login = fnd_global.login_id
3668: WHERE project_id = p_project_id;
3669: ELSE
3670:
3671: UPDATE pa_projects_all
3672: SET wf_status_code = NULL
3673: ,project_status_code = p_new_status_code --Added for bug 3818322
3674: /*4364878 : Included update of who columns also*/
3675: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL

Line 3688: -- Update wf status in pa_projects_all

3684:
3685:
3686: ELSIF l_wf_status_code IS NULL THEN -- Made ELSEIF against the existing IF, for BUG# 6661144
3687: IF l_wf_enabled_flag = 'Y' THEN
3688: -- Update wf status in pa_projects_all
3689:
3690: -- 4364878 : if new system status corresponds to CLOSED
3691: -- Then Populate the closed date as sysdate
3692:

Line 3694: UPDATE pa_projects_all

3690: -- 4364878 : if new system status corresponds to CLOSED
3691: -- Then Populate the closed date as sysdate
3692:
3693: If l_new_sys_status = 'CLOSED' THEN
3694: UPDATE pa_projects_all
3695: SET wf_status_code = 'IN_ROUTE'
3696: ,project_status_code = p_new_status_code
3697: ,closed_date = sysdate
3698: ,last_update_date = sysdate

Line 3704: UPDATE pa_projects_all

3700: ,last_update_login = fnd_global.login_id
3701: WHERE project_id = p_project_id;
3702: ELSE
3703:
3704: UPDATE pa_projects_all
3705: SET wf_status_code = 'IN_ROUTE'
3706: ,project_status_code = p_new_status_code --Added for bug 3818322
3707: /*4364878 : Included update of who columns also*/
3708: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL

Line 3743: UPDATE pa_projects_all

3739: -- 4364878 : if new system status corresponds to CLOSED
3740: -- Then Populate the closed date as sysdate
3741: If l_new_sys_status = 'CLOSED' THEN
3742:
3743: UPDATE pa_projects_all
3744: SET project_status_code = p_new_status_code
3745: ,closed_date = sysdate
3746: ,last_update_date = sysdate
3747: ,last_updated_by = fnd_global.user_id

Line 3753: UPDATE pa_projects_all

3749: WHERE project_id = p_project_id ;
3750:
3751: Else
3752:
3753: UPDATE pa_projects_all
3754: SET project_status_code = p_new_status_code
3755: /*4364878 : Included update of who columns also*/
3756: ,closed_date = to_date(null) --For any status other than Closed,this field should be NULL
3757: ,last_update_date = sysdate