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_PVT dependencies on PA_PROJECTS

Line 1: PACKAGE BODY PA_PROJECTS_MAINT_PVT AS

1: PACKAGE BODY PA_PROJECTS_MAINT_PVT AS
2: /* $Header: PARMPRVB.pls 120.10.12010000.3 2008/09/22 12:58:00 kjai ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PVT';
4: -- API name : create_project
5: -- Type : Private

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PVT';

1: PACKAGE BODY PA_PROJECTS_MAINT_PVT AS
2: /* $Header: PARMPRVB.pls 120.10.12010000.3 2008/09/22 12:58:00 kjai ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PVT';
4: -- API name : create_project
5: -- Type : Private
6: -- Pre-reqs : None.
7: -- Parameters :

Line 108: l_project_id pa_projects.project_id%TYPE;

104: -- 4363092 end
105:
106: l_organization_id hr_organization_units.organization_id%TYPE;
107: l_project_status_code pa_project_statuses.project_status_code%TYPE;
108: l_project_id pa_projects.project_id%TYPE;
109: l_project_number_out pa_projects.segment1%TYPE;
110: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
111: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;

Line 109: l_project_number_out pa_projects.segment1%TYPE;

105:
106: l_organization_id hr_organization_units.organization_id%TYPE;
107: l_project_status_code pa_project_statuses.project_status_code%TYPE;
108: l_project_id pa_projects.project_id%TYPE;
109: l_project_number_out pa_projects.segment1%TYPE;
110: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
111: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

Line 111: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;

107: l_project_status_code pa_project_statuses.project_status_code%TYPE;
108: l_project_id pa_projects.project_id%TYPE;
109: l_project_number_out pa_projects.segment1%TYPE;
110: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
111: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
114: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;

Line 112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;

108: l_project_id pa_projects.project_id%TYPE;
109: l_project_number_out pa_projects.segment1%TYPE;
110: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
111: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
114: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;

Line 113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

109: l_project_number_out pa_projects.segment1%TYPE;
110: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
111: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
114: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;

Line 114: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;

110: l_probability_member_id pa_probability_members.probability_member_id%TYPE;
111: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
114: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
118: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;

Line 115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;

111: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
114: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
118: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;
119: l_country_code PA_LOCATIONS.COUNTRY_CODE%TYPE;

Line 116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;

112: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
114: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
118: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;
119: l_country_code PA_LOCATIONS.COUNTRY_CODE%TYPE;
120: l_region PA_LOCATIONS.REGION%TYPE;

Line 117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;

113: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
114: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
115: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
116: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
117: l_distribution_rule PA_PROJECTS_ALL.DISTRIBUTION_RULE%TYPE;
118: l_team_template_id PA_TEAM_TEMPLATES.TEAM_TEMPLATE_ID%TYPE;
119: l_country_code PA_LOCATIONS.COUNTRY_CODE%TYPE;
120: l_region PA_LOCATIONS.REGION%TYPE;
121: l_city PA_LOCATIONS.CITY%TYPE;

Line 143: AND EXISTS(SELECT 'x' from pa_projects_all PP

139: IS
140: SELECT TYPE
141: FROM pa_override_fields_v pof
142: WHERE pof.pa_field_name = 'CUSTOMER_NAME'
143: AND EXISTS(SELECT 'x' from pa_projects_all PP
144: -- replaced c_project_id with p_orig_project_id in where clause for Bug 5478390
145: WHERE PP.project_id = p_orig_project_id
146: AND nvl(PP.created_from_project_id,p_orig_project_id) =
147: POF.pa_source_template_id);

Line 155: FROM pa_projects_all

151: -- Modified below cursor for bug 5724556
152: CURSOR l_get_project_dates_csr (c_project_id NUMBER)
153: IS
154: SELECT start_date, completion_date, enable_top_task_customer_flag
155: FROM pa_projects_all
156: WHERE project_id = c_project_id;
157:
158: l_proj_start_date DATE;
159: l_proj_completion_date DATE;

Line 170: , pa_projects pp

166: IS
167: select meaning
168: from pa_project_types pt
169: , pa_lookups lps
170: , pa_projects pp
171: where pt.project_type = pp.project_type
172: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
173: and lps.lookup_code(+) = pt.project_type_class_code
174: and pp.project_id=p_orig_project_id;

Line 189: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');

185: if (p_debug_mode = 'Y') then
186: pa_debug.debug('Create_Project PVT: Checking the api version number.');
187: end if;
188:
189: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');
190:
191: IF p_commit = FND_API.G_TRUE THEN
192: SAVEPOINT prm_create_project;
193: END IF;

Line 317: --dbms_output.put_line('Before UPDATE PA_PROJECTS_ALL Status : ');

313: p_msg_name =>'PA_BU_NEED_POS_NUM');
314: RAISE FND_API.G_EXC_ERROR;
315: end if;
316:
317: --dbms_output.put_line('Before UPDATE PA_PROJECTS_ALL Status : ');
318:
319: pa_project_core1.copy_project (
320: x_orig_project_id => p_orig_project_id
321: ,x_project_name => RTRIM(p_project_name)

Line 472: PA_PROJECTS_MAINT_PVT.CREATE_CUSTOMER

468:
469: if (p_debug_mode = 'Y') then
470: pa_debug.debug('Create_Project PVT: Calling create customer private API');
471: end if;
472: PA_PROJECTS_MAINT_PVT.CREATE_CUSTOMER
473: ( p_commit => FND_API.G_FALSE ,
474: p_validate_only => p_validate_only ,
475: p_validation_level => p_validation_level ,
476: p_debug_mode => p_debug_mode ,

Line 545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

541: IF p_commit = FND_API.G_TRUE THEN
542: ROLLBACK TO prm_create_project;
543: END IF;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
546: p_procedure_name => 'CREATE_PROJECT',
547: p_error_text => SUBSTRB(SQLERRM,1,240));
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549:

Line 561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

557: IF p_commit = FND_API.G_TRUE THEN
558: ROLLBACK TO prm_create_project;
559: END IF;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
562: p_procedure_name => 'CREATE_PROJECT',
563: p_error_text => SUBSTRB(SQLERRM,1,240));
564: raise;
565:

Line 613: From pa_projects_all pa, pa_project_types_all pt

609:
610: CURSOR l_project_csr (c_project_id NUMBER) -- Bug 6166197: cursor modified to fetch project_type_class_code also
611: Is
612: Select project_currency_code, project_type_class_code
613: From pa_projects_all pa, pa_project_types_all pt
614: Where pa.project_id = c_project_id
615: And pa.project_type = pt.project_type
616: And nvl(pa.org_id,-99) = nvl(pt.org_id,-99);
617:

Line 624: AND EXISTS(SELECT 'x' from pa_projects_all PP

620: IS
621: SELECT TYPE
622: FROM pa_override_fields_v pof
623: WHERE pof.pa_field_name = 'CUSTOMER_NAME'
624: AND EXISTS(SELECT 'x' from pa_projects_all PP
625: WHERE PP.project_id = c_project_id
626: AND PP.created_from_project_id =
627: POF.pa_source_template_id);*/
628:

Line 698: pa_projects_all

694: IS
695: SELECT
696: nvl(DATE_EFF_FUNDS_CONSUMPTION,'N')
697: FROM
698: pa_projects_all
699: WHERE project_id = c_project_id ;
700: --sunkalya:federal Bug#5511353
701:
702: -- bug 5724556

Line 936: , p_OBJECT_TYPE => 'PA_PROJECTS'

932:
933: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
934: p_validate_only => FND_API.G_FALSE
935: , p_object_id => p_project_id
936: , p_OBJECT_TYPE => 'PA_PROJECTS'
937: , p_project_role_id => 100
938: , p_project_role_type => 'CUSTOMER_ORG'
939: , p_RESOURCE_TYPE_ID => 112
940: , p_resource_source_id => l_party_id

Line 984: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

980: IF p_commit = FND_API.G_TRUE THEN
981: ROLLBACK TO prm_create_customer;
982: END IF;
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
985: p_procedure_name => 'CREATE_CUSTOMER',
986: p_error_text => SUBSTRB(SQLERRM,1,240));
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988:

Line 1000: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

996: IF p_commit = FND_API.G_TRUE THEN
997: ROLLBACK TO prm_create_customer;
998: END IF;
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
1001: p_procedure_name => 'CREATE_CUSTOMER',
1002: p_error_text => SUBSTRB(SQLERRM,1,240));
1003: raise;
1004:

Line 1124: l_project_name PA_PROJECTS_ALL.NAME%TYPE;

1120: l_data VARCHAR2(250);
1121: l_msg_index_out NUMBER;
1122: l_calling_module VARCHAR2(100); -- bug7204572
1123:
1124: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1125: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1126: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;

Line 1125: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;

1121: l_msg_index_out NUMBER;
1122: l_calling_module VARCHAR2(100); -- bug7204572
1123:
1124: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1125: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1126: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;

Line 1126: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;

1122: l_calling_module VARCHAR2(100); -- bug7204572
1123:
1124: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1125: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1126: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;

Line 1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;

1123:
1124: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1125: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1126: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;

Line 1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;

1124: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1125: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1126: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;
1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

Line 1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;

1125: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1126: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;
1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;

Line 1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;

1126: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;
1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;
1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;

Line 1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;

1127: l_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;
1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;
1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;

Line 1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;

1128: l_project_status_code PA_PROJECTS_ALL.PROJECT_STATUS_CODE%TYPE;
1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;
1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;
1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;

Line 1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;

1129: l_public_sector_flag PA_PROJECTS_ALL.PUBLIC_SECTOR_FLAG%TYPE;
1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;
1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;
1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;

Line 1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;

1130: l_carrying_out_organization_id PA_PROJECTS_ALL.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;
1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;
1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;

Line 1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;

1131: l_start_date PA_PROJECTS_ALL.START_DATE%TYPE;
1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;
1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;

Line 1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;

1132: l_completion_date PA_PROJECTS_ALL.COMPLETION_DATE%TYPE;
1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;
1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;

Line 1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;

1133: l_record_version_number PA_PROJECTS_ALL.record_Version_number%TYPE;
1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;

Line 1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;

1134: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;

Line 1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;

1135: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1143: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;

Line 1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;

1136: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1143: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1144: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;

Line 1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;

1137: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1143: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1144: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1145: l_priority_code PA_PROJECTS_ALL.priority_code%TYPE;

Line 1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;

1138: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1143: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1144: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1145: l_priority_code PA_PROJECTS_ALL.priority_code%TYPE;
1146: -- anlee

Line 1143: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;

1139: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1143: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1144: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1145: l_priority_code PA_PROJECTS_ALL.priority_code%TYPE;
1146: -- anlee
1147: -- Dates changes

Line 1144: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;

1140: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1143: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1144: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1145: l_priority_code PA_PROJECTS_ALL.priority_code%TYPE;
1146: -- anlee
1147: -- Dates changes
1148: l_target_start_date PA_PROJECTS_ALL.TARGET_START_DATE%TYPE;

Line 1145: l_priority_code PA_PROJECTS_ALL.priority_code%TYPE;

1141: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1142: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1143: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1144: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1145: l_priority_code PA_PROJECTS_ALL.priority_code%TYPE;
1146: -- anlee
1147: -- Dates changes
1148: l_target_start_date PA_PROJECTS_ALL.TARGET_START_DATE%TYPE;
1149: l_target_finish_date PA_PROJECTS_ALL.TARGET_FINISH_DATE%TYPE;

Line 1148: l_target_start_date PA_PROJECTS_ALL.TARGET_START_DATE%TYPE;

1144: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1145: l_priority_code PA_PROJECTS_ALL.priority_code%TYPE;
1146: -- anlee
1147: -- Dates changes
1148: l_target_start_date PA_PROJECTS_ALL.TARGET_START_DATE%TYPE;
1149: l_target_finish_date PA_PROJECTS_ALL.TARGET_FINISH_DATE%TYPE;
1150: -- End of changes
1151:
1152: l_mass_adj_outcome VARCHAR2(100);

Line 1149: l_target_finish_date PA_PROJECTS_ALL.TARGET_FINISH_DATE%TYPE;

1145: l_priority_code PA_PROJECTS_ALL.priority_code%TYPE;
1146: -- anlee
1147: -- Dates changes
1148: l_target_start_date PA_PROJECTS_ALL.TARGET_START_DATE%TYPE;
1149: l_target_finish_date PA_PROJECTS_ALL.TARGET_FINISH_DATE%TYPE;
1150: -- End of changes
1151:
1152: l_mass_adj_outcome VARCHAR2(100);
1153: l_batch_id NUMBER(25);

Line 1160: l_project_rec pa_projects%ROWTYPE;

1156: l_dummy1 NUMBER;
1157: l_dummy2 NUMBER;
1158: l_batch_name VARCHAR2(100);
1159: l_batch_description VARCHAR2(100);
1160: l_project_rec pa_projects%ROWTYPE;
1161: l_old_organization_id NUMBER;
1162: cursor get_batch_name_csr
1163: IS
1164: SELECT meaning

Line 1179: FROM pa_projects p

1175:
1176: CURSOR l_project_details_csr
1177: IS
1178: SELECT *
1179: FROM pa_projects p
1180: WHERE p.project_id = p_project_id;
1181:
1182: CURSOR l_get_organization_csr
1183: IS

Line 1185: FROM pa_projects_all

1181:
1182: CURSOR l_get_organization_csr
1183: IS
1184: SELECT carrying_out_organization_id
1185: FROM pa_projects_all
1186: WHERE project_id = p_project_id;
1187:
1188: -- anlee
1189: -- Ext Attribute changes

Line 1194: FROM pa_projects_all ppa, pa_project_types ppt

1190: -- Bug 2904327
1191: CURSOR l_get_project_type_id
1192: IS
1193: SELECT ppt.project_type_id
1194: FROM pa_projects_all ppa, pa_project_types ppt
1195: WHERE ppa.project_id = p_project_id
1196: AND ppa.project_type = ppt.project_type;
1197:
1198: l_old_project_type_id NUMBER;

Line 1207: FROM pa_projects_all

1203: -- 4055319 Added for pjp api call
1204: CURSOR c_template_flag
1205: IS
1206: SELECT template_flag
1207: FROM pa_projects_all
1208: WHERE project_id = p_project_id;
1209:
1210: l_template_flag VARCHAR2(1);
1211: -- 4055319 end

Line 1238: FROM pa_projects

1234: end if;
1235: if p_validate_only <> FND_API.G_TRUE then
1236: BEGIN
1237: SELECT 'x' INTO l_dummy
1238: FROM pa_projects
1239: WHERE project_id = p_project_id
1240: AND record_version_number = p_record_version_number
1241: FOR UPDATE OF record_version_number NOWAIT;
1242: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN

Line 1271: FROM pa_projects

1267: END;
1268: else
1269: BEGIN
1270: SELECT 'x' INTO l_dummy
1271: FROM pa_projects
1272: WHERE project_id = p_project_id
1273: AND record_version_number = p_record_version_number;
1274: EXCEPTION WHEN NO_DATA_FOUND THEN
1275: if p_calling_module = 'FORM' then

Line 1317: PA_PROJECTS_MAINT_PVT.Validate_Project_Info

1313: l_calling_module := 'BASIC_INFO';
1314: end if;
1315: --Code ends for bug 7204572
1316:
1317: PA_PROJECTS_MAINT_PVT.Validate_Project_Info
1318: (
1319: p_validation_level => p_validation_level,
1320: p_calling_module => l_calling_module, -- bug 7204572 changed 'BASIC_INFO' to l_calling_module
1321: p_debug_mode => p_debug_mode,

Line 1408: --dbms_output.put_line('Before UPDATE PA_PROJECTS_ALL Status : ');

1404: l_public_sector_flag := null;
1405: else
1406: l_public_sector_flag := p_public_Sector_flag;
1407: end if;
1408: --dbms_output.put_line('Before UPDATE PA_PROJECTS_ALL Status : ');
1409:
1410: if p_carrying_out_organization_id = FND_API.G_MISS_NUM
1411: then
1412: l_carrying_out_organization_id := null;

Line 1546: pa_debug.debug('Update_project_basic_info PVT: upating pa_projects table');

1542: CLOSE l_get_project_type_id;
1543: -- anlee end of changes
1544:
1545: if (p_debug_mode = 'Y') then
1546: pa_debug.debug('Update_project_basic_info PVT: upating pa_projects table');
1547: end if;
1548:
1549: UPDATE PA_PROJECTS
1550: SET name = l_project_name,

Line 1549: UPDATE PA_PROJECTS

1545: if (p_debug_mode = 'Y') then
1546: pa_debug.debug('Update_project_basic_info PVT: upating pa_projects table');
1547: end if;
1548:
1549: UPDATE PA_PROJECTS
1550: SET name = l_project_name,
1551: segment1 = l_project_number,
1552: project_type = l_project_type,
1553: description = l_description,

Line 1615: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1611: END IF;
1612:
1613: EXCEPTION WHEN OTHERS THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1616: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1617: p_error_text => SUBSTRB(SQLERRM,1,240));
1618: rollback to copy_project;
1619: return;

Line 1794: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

1790: IF p_commit = FND_API.G_TRUE THEN
1791: ROLLBACK TO update_project_basic_info;
1792: END IF;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
1795: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1796: p_error_text => SUBSTRB(SQLERRM,1,240));
1797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798:

Line 1810: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1806: IF p_commit = FND_API.G_TRUE THEN
1807: ROLLBACK TO update_project_basic_info;
1808: END IF;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1811: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1812: p_error_text => SUBSTRB(SQLERRM,1,240));
1813: raise;
1814:

Line 1841: -- 02-Sep-2008 Bug 7286976 : Added WHO columns while updating pa_projects

1837: --
1838: -- History
1839: --
1840: -- 18-AUG-2000 -- Sakthi/William - Created.
1841: -- 02-Sep-2008 Bug 7286976 : Added WHO columns while updating pa_projects
1842: --
1843: --
1844: PROCEDURE UPDATE_PROJECT_ADDITIONAL_INFO
1845: (

Line 1891: l_record_version_number PA_PROJECTS_ALL.RECORD_VERSION_NUMBER%TYPE;

1887: l_data VARCHAR2(250);
1888: l_msg_index_out NUMBER;
1889: l_dummy VARCHAR2(1);
1890:
1891: l_record_version_number PA_PROJECTS_ALL.RECORD_VERSION_NUMBER%TYPE;
1892: l_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1893: l_work_type_id PA_PROJECTS_ALL.WORK_TYPE_ID%TYPE;
1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;
1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;

Line 1892: l_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;

1888: l_msg_index_out NUMBER;
1889: l_dummy VARCHAR2(1);
1890:
1891: l_record_version_number PA_PROJECTS_ALL.RECORD_VERSION_NUMBER%TYPE;
1892: l_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1893: l_work_type_id PA_PROJECTS_ALL.WORK_TYPE_ID%TYPE;
1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;
1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;
1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;

Line 1893: l_work_type_id PA_PROJECTS_ALL.WORK_TYPE_ID%TYPE;

1889: l_dummy VARCHAR2(1);
1890:
1891: l_record_version_number PA_PROJECTS_ALL.RECORD_VERSION_NUMBER%TYPE;
1892: l_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1893: l_work_type_id PA_PROJECTS_ALL.WORK_TYPE_ID%TYPE;
1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;
1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;
1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;

Line 1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;

1890:
1891: l_record_version_number PA_PROJECTS_ALL.RECORD_VERSION_NUMBER%TYPE;
1892: l_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1893: l_work_type_id PA_PROJECTS_ALL.WORK_TYPE_ID%TYPE;
1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;
1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;
1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;
1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;

Line 1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;

1891: l_record_version_number PA_PROJECTS_ALL.RECORD_VERSION_NUMBER%TYPE;
1892: l_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1893: l_work_type_id PA_PROJECTS_ALL.WORK_TYPE_ID%TYPE;
1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;
1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;
1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;
1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;
1899:

Line 1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;

1892: l_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1893: l_work_type_id PA_PROJECTS_ALL.WORK_TYPE_ID%TYPE;
1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;
1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;
1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;
1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;
1899:
1900: l_project_name PA_PROJECTS_ALL.NAME%TYPE;

Line 1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;

1893: l_work_type_id PA_PROJECTS_ALL.WORK_TYPE_ID%TYPE;
1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;
1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;
1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;
1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;
1899:
1900: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1901: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;

Line 1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;

1894: l_role_list_id PA_PROJECTS_ALL.ROLE_LIST_ID%TYPE;
1895: l_cost_job_group_id PA_PROJECTS_ALL.COST_JOB_GROUP_ID%TYPE;
1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;
1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;
1899:
1900: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1901: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1902: l_project_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;

Line 1900: l_project_name PA_PROJECTS_ALL.NAME%TYPE;

1896: l_bill_job_group_id PA_PROJECTS_ALL.BILL_JOB_GROUP_ID%TYPE;
1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;
1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;
1899:
1900: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1901: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1902: l_project_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1903: l_old_split PA_PROJECTS_ALL.SPLIT_COST_FROM_WORKPLAN_FLAG%TYPE;
1904:

Line 1901: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;

1897: l_split_cost_from_wokplan_flag PA_PROJECTS_ALL.split_cost_from_workplan_flag%TYPE;
1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;
1899:
1900: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1901: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1902: l_project_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1903: l_old_split PA_PROJECTS_ALL.SPLIT_COST_FROM_WORKPLAN_FLAG%TYPE;
1904:
1905: l_old_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;

Line 1902: l_project_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;

1898: l_split_cost_from_bill_flag PA_PROJECTS_ALL.split_cost_from_bill_flag%TYPE;
1899:
1900: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1901: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1902: l_project_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1903: l_old_split PA_PROJECTS_ALL.SPLIT_COST_FROM_WORKPLAN_FLAG%TYPE;
1904:
1905: l_old_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1906:

Line 1903: l_old_split PA_PROJECTS_ALL.SPLIT_COST_FROM_WORKPLAN_FLAG%TYPE;

1899:
1900: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
1901: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1902: l_project_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1903: l_old_split PA_PROJECTS_ALL.SPLIT_COST_FROM_WORKPLAN_FLAG%TYPE;
1904:
1905: l_old_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1906:
1907: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;

Line 1905: l_old_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;

1901: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE;
1902: l_project_description PA_PROJECTS_ALL.DESCRIPTION%TYPE;
1903: l_old_split PA_PROJECTS_ALL.SPLIT_COST_FROM_WORKPLAN_FLAG%TYPE;
1904:
1905: l_old_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1906:
1907: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1908: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;

Line 1907: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;

1903: l_old_split PA_PROJECTS_ALL.SPLIT_COST_FROM_WORKPLAN_FLAG%TYPE;
1904:
1905: l_old_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1906:
1907: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1908: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;

Line 1908: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;

1904:
1905: l_old_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1906:
1907: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1908: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;

Line 1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;

1905: l_old_calendar_id PA_PROJECTS_ALL.CALENDAR_ID%TYPE;
1906:
1907: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1908: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;

Line 1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;

1906:
1907: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1908: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;

Line 1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;

1907: l_attribute_category PA_PROJECTS_ALL.attribute_category%TYPE;
1908: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1915: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;

Line 1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;

1908: l_attribute1 PA_PROJECTS_ALL.attribute1%TYPE;
1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1915: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1916: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;

Line 1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;

1909: l_attribute2 PA_PROJECTS_ALL.attribute2%TYPE;
1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1915: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1916: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1917: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;

Line 1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;

1910: l_attribute3 PA_PROJECTS_ALL.attribute3%TYPE;
1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1915: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1916: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1917: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1918:

Line 1915: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;

1911: l_attribute4 PA_PROJECTS_ALL.attribute4%TYPE;
1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1915: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1916: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1917: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1918:
1919: --FPM Changes

Line 1916: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;

1912: l_attribute5 PA_PROJECTS_ALL.attribute5%TYPE;
1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1915: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1916: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1917: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1918:
1919: --FPM Changes
1920: --l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;

Line 1917: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;

1913: l_attribute6 PA_PROJECTS_ALL.attribute6%TYPE;
1914: l_attribute7 PA_PROJECTS_ALL.attribute7%TYPE;
1915: l_attribute8 PA_PROJECTS_ALL.attribute8%TYPE;
1916: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1917: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1918:
1919: --FPM Changes
1920: --l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1921: --l_allow_multi_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;

Line 1920: --l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;

1916: l_attribute9 PA_PROJECTS_ALL.attribute9%TYPE;
1917: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1918:
1919: --FPM Changes
1920: --l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1921: --l_allow_multi_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;
1922: --l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1923: --l_proj_allow_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;
1924: --l_flag VARCHAR2(1);

Line 1921: --l_allow_multi_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;

1917: l_attribute10 PA_PROJECTS_ALL.attribute10%TYPE;
1918:
1919: --FPM Changes
1920: --l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1921: --l_allow_multi_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;
1922: --l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1923: --l_proj_allow_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;
1924: --l_flag VARCHAR2(1);
1925:

Line 1922: --l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;

1918:
1919: --FPM Changes
1920: --l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1921: --l_allow_multi_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;
1922: --l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1923: --l_proj_allow_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;
1924: --l_flag VARCHAR2(1);
1925:
1926:

Line 1923: --l_proj_allow_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;

1919: --FPM Changes
1920: --l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1921: --l_allow_multi_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;
1922: --l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
1923: --l_proj_allow_program_rollup PA_PROJECTS_ALL.sys_program_flag%TYPE;
1924: --l_flag VARCHAR2(1);
1925:
1926:
1927: CURSOR l_get_project_attrs_csr

Line 1931: FROM PA_PROJECTS_ALL

1927: CURSOR l_get_project_attrs_csr
1928: IS
1929: SELECT name, segment1, description, split_cost_from_workplan_flag, calendar_id
1930: --,sys_program_flag,allow_multi_program_rollup
1931: FROM PA_PROJECTS_ALL
1932: WHERE project_id = p_project_id;
1933:
1934: BEGIN
1935:

Line 1949: FROM pa_projects

1945:
1946: if p_validate_only <> FND_API.G_TRUE then
1947: BEGIN
1948: SELECT 'x' INTO l_dummy
1949: FROM pa_projects
1950: WHERE project_id = p_project_id
1951: AND record_version_number = p_record_version_number
1952: FOR UPDATE OF record_version_number NOWAIT;
1953: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN

Line 1983: FROM pa_projects

1979: else
1980:
1981: BEGIN
1982: SELECT 'x' INTO l_dummy
1983: FROM pa_projects
1984: WHERE project_id = p_project_id
1985: AND record_version_number = p_record_version_number;
1986: EXCEPTION
1987: WHEN NO_DATA_FOUND THEN

Line 2019: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO Project Data ');

2015: END IF;
2016:
2017: -- write your program logic from here
2018:
2019: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO Project Data ');
2020:
2021: if p_validation_level > 0 then
2022: pa_debug.G_err_stage := 'Calling validate additional Info';
2023: if (p_debug_mode = 'Y') then

Line 2026: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO

2022: pa_debug.G_err_stage := 'Calling validate additional Info';
2023: if (p_debug_mode = 'Y') then
2024: pa_debug.debug('Update_project_additional_info PVT: Calling validate project info API');
2025: end if;
2026: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO
2027: (
2028: p_validation_level => p_validation_level,
2029: p_calling_module => 'ADDITIONAL_INFORMATION',
2030: p_action => 'UPDATE',

Line 2053: pa_debug.debug('Update_project_additional_info PVT: updating pa_projects table');

2049:
2050: IF NOT FND_API.TO_BOOLEAN(p_validate_only)
2051: THEN
2052: if (p_debug_mode = 'Y') then
2053: pa_debug.debug('Update_project_additional_info PVT: updating pa_projects table');
2054: end if;
2055: /* if p_record_version_number = FND_API.G_MISS_NUM
2056: then
2057: l_record_version_number := 0;

Line 2273: UPDATE pa_projects

2269: RAISE FND_API.G_EXC_ERROR;
2270: END IF;
2271: END IF;
2272: */
2273: UPDATE pa_projects
2274: SET record_version_number = record_version_number +1,
2275: attribute_category = l_attribute_category,
2276: attribute1 = l_attribute1,
2277: attribute2 = l_attribute2,

Line 2315: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2311: IF p_commit = FND_API.G_TRUE THEN
2312: ROLLBACK TO update_project_additional_info;
2313: END IF;
2314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2315: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2316: p_procedure_name => 'UPDATE_PROJECT_ADDITIONAL_INFO',
2317: p_error_text => SUBSTRB(SQLERRM,1,240));
2318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2319:

Line 2331: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2327: IF p_commit = FND_API.G_TRUE THEN
2328: ROLLBACK TO update_project_additional_info;
2329: END IF;
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2332: p_procedure_name => 'UPDATE_PROJECT_ADDITIONAL_INFO',
2333: p_error_text => SUBSTRB(SQLERRM,1,240));
2334: raise;
2335:

Line 2385: l_probability_member_id PA_PROJECTS_ALL.PROBABILITY_MEMBER_ID%TYPE;

2381: l_msg_data VARCHAR2(250);
2382: l_data VARCHAR2(250);
2383: l_dummy VARCHAR2(1);
2384:
2385: l_probability_member_id PA_PROJECTS_ALL.PROBABILITY_MEMBER_ID%TYPE;
2386: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
2387: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
2388: BEGIN
2389:

Line 2386: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;

2382: l_data VARCHAR2(250);
2383: l_dummy VARCHAR2(1);
2384:
2385: l_probability_member_id PA_PROJECTS_ALL.PROBABILITY_MEMBER_ID%TYPE;
2386: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
2387: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
2388: BEGIN
2389:
2390: IF p_commit = FND_API.G_TRUE THEN

Line 2387: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;

2383: l_dummy VARCHAR2(1);
2384:
2385: l_probability_member_id PA_PROJECTS_ALL.PROBABILITY_MEMBER_ID%TYPE;
2386: l_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
2387: l_expected_approval_date PA_PROJECTS_ALL.EXPECTED_APPROVAL_DATE%TYPE;
2388: BEGIN
2389:
2390: IF p_commit = FND_API.G_TRUE THEN
2391: SAVEPOINT update_project_pipeline_info;

Line 2403: FROM pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

2399: -- write your program logic from here
2400: if p_validate_only <> FND_API.G_TRUE then
2401: BEGIN
2402: SELECT 'x' INTO l_dummy
2403: FROM pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
2404: WHERE project_id = p_project_id
2405: AND record_version_number = p_record_version_number
2406: FOR UPDATE OF record_version_number NOWAIT;
2407: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN

Line 2436: FROM pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

2432: END;
2433: else
2434: BEGIN
2435: SELECT 'x' INTO l_dummy
2436: FROM pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
2437: WHERE project_id = p_project_id
2438: AND record_version_number = p_record_version_number;
2439: EXCEPTION
2440: WHEN NO_DATA_FOUND THEN

Line 2475: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO

2471: pa_debug.G_err_stage := 'Calling validate pipeline Info';
2472: if (p_debug_mode = 'Y') then
2473: pa_debug.debug('Update_project_pipeline_info PVT: Calling validate project API');
2474: end if;
2475: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO
2476: ( p_validation_level => p_validation_level,
2477: p_calling_module => 'PIPELINE',
2478: p_action => 'UPDATE',
2479: p_debug_mode => p_debug_mode,

Line 2498: pa_debug.debug('Update_project_pipeline_info PVT: update pa_projects table');

2494: END IF;
2495: IF NOT FND_API.TO_BOOLEAN(p_validate_only)
2496: THEN
2497: if (p_debug_mode = 'Y') then
2498: pa_debug.debug('Update_project_pipeline_info PVT: update pa_projects table');
2499: end if;
2500: if p_probability_member_id = FND_API.G_MISS_NUM
2501: then
2502: l_probability_member_id := null;

Line 2520: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

2516: l_expected_approval_date := null;
2517: else
2518: l_expected_approval_Date := p_expected_approval_date;
2519: end if;
2520: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
2521: SET record_version_number = record_version_number +1 ,
2522: probability_member_id = l_probability_member_id,
2523: project_value = l_project_value,
2524: expected_approval_date = l_expected_approval_date

Line 2538: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2534: IF p_commit = FND_API.G_TRUE THEN
2535: ROLLBACK TO update_project_pipeline_info;
2536: END IF;
2537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2538: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2539: p_procedure_name => 'UPDATE_PROJECT_PIPELINE_INFO',
2540: p_error_text => SUBSTRB(SQLERRM,1,240));
2541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2542:

Line 2554: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2550: IF p_commit = FND_API.G_TRUE THEN
2551: ROLLBACK TO update_project_pipeline_info;
2552: END IF;
2553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2554: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2555: p_procedure_name => 'UPDATE_PROJECT_PIPELINE_INFO',
2556: p_error_text => SUBSTRB(SQLERRM,1,240));
2557: raise;
2558:

Line 2663: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATION ');

2659: l_application_id NUMBER;
2660:
2661: BEGIN
2662:
2663: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATION ');
2664:
2665: IF p_commit = FND_API.G_TRUE THEN
2666: SAVEPOINT create_classifications_pvt;
2667: END IF;

Line 2678: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS Before ');

2674: end if;
2675:
2676: pa_debug.G_err_stage := 'Calling validate_classifications';
2677:
2678: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS Before ');
2679:
2680: if (p_debug_mode = 'Y') then
2681: pa_debug.debug('Create classification PVT: Calling validate_classification API ');
2682: end if;

Line 2686: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS

2682: end if;
2683:
2684: l_code_percentage := p_code_percentage;
2685:
2686: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS
2687: (
2688: p_validation_level => p_validation_level,
2689: p_calling_module => p_calling_module,
2690: p_action => 'INSERT',

Line 2892: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

2888: IF p_commit = FND_API.G_TRUE THEN
2889: ROLLBACK TO create_classifications_pvt;
2890: END IF;
2891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2892: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
2893: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2894: p_error_text => SUBSTRB(SQLERRM,1,240));
2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2896:

Line 2908: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

2904: IF p_commit = FND_API.G_TRUE THEN
2905: ROLLBACK TO create_classifications_pvt;
2906: END IF;
2907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2908: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
2909: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2910: p_error_text => SUBSTRB(SQLERRM,1,240));
2911: raise;
2912:

Line 3038: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications BEGIN');

3034: -- anlee end of changes
3035:
3036: BEGIN
3037: if (p_debug_mode = 'Y') then
3038: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications BEGIN');
3039: end if;
3040:
3041: if p_commit = FND_API.G_TRUE then
3042: savepoint update_classifications_pvt;

Line 3118: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS

3114: end if;
3115:
3116: l_code_percentage := p_code_percentage;
3117:
3118: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS
3119: (
3120: p_validation_level => p_validation_level,
3121: p_calling_module => p_calling_module,
3122: p_action => 'UPDATE',

Line 3329: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications END');

3325: commit work;
3326: end if;
3327:
3328: if (p_debug_mode = 'Y') then
3329: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications END');
3330: end if;
3331:
3332: EXCEPTION
3333: when FND_API.G_EXC_ERROR then

Line 3343: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

3339: if p_commit = FND_API.G_TRUE then
3340: rollback to update_classifications_pvt;
3341: end if;
3342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3343: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
3344: p_procedure_name => 'Update_Classifications',
3345: p_error_text => SUBSTRB(SQLERRM,1,240));
3346: raise;
3347: END UPDATE_CLASSIFICATIONS;

Line 3410: --dbms_output.put_line('PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_CAN_OVERRIDE ');

3406: BEGIN
3407:
3408: if p_action = 'INSERT' then
3409:
3410: --dbms_output.put_line('PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_CAN_OVERRIDE ');
3411:
3412: IF p_calling_module = 'QUICK_ENTRY'
3413: THEN
3414: if (p_debug_mode = 'Y') then

Line 3417: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_CAN_OVERRIDE(

3413: THEN
3414: if (p_debug_mode = 'Y') then
3415: pa_debug.debug('Validate classification PVT: Calling API to check if catg code can be overridden');
3416: end if;
3417: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_CAN_OVERRIDE(
3418: p_object_id,
3419: p_class_category,
3420: p_class_code,
3421: l_return_status,

Line 3437: if p_object_type = 'PA_PROJECTS' then

3433: if (p_debug_mode = 'Y') then
3434: pa_debug.debug('Validate classification PVT: Calling API to check if category is valid');
3435: end if;
3436:
3437: if p_object_type = 'PA_PROJECTS' then
3438: SELECT ppta.project_type_id
3439: INTO l_object_type_id
3440: FROM PA_PROJECT_TYPES_ALL ppta,
3441: PA_PROJECTS_ALL ppa

Line 3441: PA_PROJECTS_ALL ppa

3437: if p_object_type = 'PA_PROJECTS' then
3438: SELECT ppta.project_type_id
3439: INTO l_object_type_id
3440: FROM PA_PROJECT_TYPES_ALL ppta,
3441: PA_PROJECTS_ALL ppa
3442: WHERE ppa.project_id = p_object_id
3443: AND ppa.project_type = ppta.project_type
3444: -- AND NVL(ppa.org_id, -99) = NVL(ppta.org_id, -99); MOAC Changes: Bug 4363092 - removed nvl
3445: AND ppa.org_id = ppta.org_id;

Line 3458: PA_PROJECTS_MAINT_UTILS.CHECK_CATEGORY_VALID(

3454: -- not used in AMG/SS flow. Hence we can comment out the call to this API in
3455: -- CREATE/UPDATE flow from forms.
3456:
3457: /*
3458: PA_PROJECTS_MAINT_UTILS.CHECK_CATEGORY_VALID(
3459: l_object_type_id,
3460: p_class_category,
3461: l_return_status,
3462: l_error_msg_code);

Line 3472: PA_PROJECTS_MAINT_UTILS.CHECK_PERCENTAGE_ALLOWED(

3468: END IF;
3469:
3470: */
3471:
3472: PA_PROJECTS_MAINT_UTILS.CHECK_PERCENTAGE_ALLOWED(
3473: p_class_category,
3474: l_return_status,
3475: l_error_msg_code);
3476: if (p_code_percentage is not NULL) AND (p_code_percentage <> FND_API.G_MISS_NUM) then

Line 3488: PA_PROJECTS_MAINT_UTILS.CHECK_CATEGORY_TOTAL_VALID(

3484: p_msg_name => 'PA_CODE_PERCENT_INVALID');
3485: /* Commented for bug 3161704
3486: else
3487: if p_calling_module = 'FORMS' then
3488: PA_PROJECTS_MAINT_UTILS.CHECK_CATEGORY_TOTAL_VALID(
3489: p_object_id,
3490: p_object_type,
3491: p_class_category,
3492: NULL,

Line 3517: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_ONE_ONLY_CODE(

3513:
3514: if (p_debug_mode = 'Y') then
3515: pa_debug.debug('Validate classification PVT: Calling API to check if only one catg code can be entered');
3516: end if;
3517: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_ONE_ONLY_CODE(
3518: p_object_id,
3519: p_object_type,
3520: p_class_category,
3521: l_return_status,

Line 3535: PA_PROJECTS_MAINT_UTILS.CHECK_DUPLICATE_CLASS_CATG(

3531:
3532: if (p_debug_mode = 'Y') then
3533: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered is a duplicate');
3534: end if;
3535: PA_PROJECTS_MAINT_UTILS.CHECK_DUPLICATE_CLASS_CATG(
3536: p_object_id,
3537: p_object_type,
3538: p_class_category,
3539: p_class_code,

Line 3556: if p_object_type = 'PA_PROJECTS' then

3552: if (p_debug_mode = 'Y') then
3553: pa_debug.debug('Validate classification PVT: Calling API to check if category is valid');
3554: end if;
3555:
3556: if p_object_type = 'PA_PROJECTS' then
3557: SELECT ppta.project_type_id
3558: INTO l_object_type_id
3559: FROM PA_PROJECT_TYPES_ALL ppta,
3560: PA_PROJECTS_ALL ppa

Line 3560: PA_PROJECTS_ALL ppa

3556: if p_object_type = 'PA_PROJECTS' then
3557: SELECT ppta.project_type_id
3558: INTO l_object_type_id
3559: FROM PA_PROJECT_TYPES_ALL ppta,
3560: PA_PROJECTS_ALL ppa
3561: WHERE ppa.project_id = p_object_id
3562: AND ppa.project_type = ppta.project_type
3563: -- AND NVL(ppa.org_id, -99) = NVL(ppta.org_id, -99); MOAC Changes: Bug 4363092 - removed nvl
3564: AND ppa.org_id = ppta.org_id;

Line 3569: PA_PROJECTS_MAINT_UTILS.CHECK_CATEGORY_VALID(

3565: else
3566: l_object_type_id := -1;
3567: end if;
3568:
3569: PA_PROJECTS_MAINT_UTILS.CHECK_CATEGORY_VALID(
3570: l_object_type_id,
3571: p_class_category,
3572: l_return_status,
3573: l_error_msg_code);

Line 3581: PA_PROJECTS_MAINT_UTILS.CHECK_PERCENTAGE_ALLOWED(

3577: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3578: p_msg_name =>l_error_msg_code);
3579: END IF;
3580:
3581: PA_PROJECTS_MAINT_UTILS.CHECK_PERCENTAGE_ALLOWED(
3582: p_class_category,
3583: l_return_status,
3584: l_error_msg_code);
3585: if (p_code_percentage is not NULL) AND (p_code_percentage <> FND_API.G_MISS_NUM) then

Line 3597: PA_PROJECTS_MAINT_UTILS.CHECK_CATEGORY_TOTAL_VALID(

3593: p_msg_name => 'PA_CODE_PERCENT_INVALID');
3594: /* Commented for bug 3161704
3595: else
3596: if p_calling_module = 'FORMS' then
3597: PA_PROJECTS_MAINT_UTILS.CHECK_CATEGORY_TOTAL_VALID(
3598: p_object_id,
3599: p_object_type,
3600: p_class_category,
3601: p_rowid,

Line 3643: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_ONE_ONLY_CODE(

3639: if l_class_category <> p_class_category then
3640: if (p_debug_mode = 'Y') then
3641: pa_debug.debug('Validate classification PVT: Calling API to check if only one catg code can be entered');
3642: end if;
3643: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_ONE_ONLY_CODE(
3644: p_object_id,
3645: p_object_type,
3646: p_class_category,
3647: l_return_status,

Line 3662: PA_PROJECTS_MAINT_UTILS.CHECK_DUPLICATE_CLASS_CATG(

3658:
3659: if (p_debug_mode = 'Y') then
3660: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered is a duplicate');
3661: end if;
3662: PA_PROJECTS_MAINT_UTILS.CHECK_DUPLICATE_CLASS_CATG(
3663: p_object_id,
3664: p_object_type,
3665: p_class_category,
3666: p_class_code,

Line 3682: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_CAN_DELETE

3678:
3679: if (p_debug_mode = 'Y') then
3680: pa_debug.debug('Validate classification PVT: Calling API to check if the catg code entered can be deleted');
3681: end if;
3682: PA_PROJECTS_MAINT_UTILS.CHECK_CLASS_CATG_CAN_DELETE
3683: (p_object_id,
3684: p_object_type,
3685: p_class_category,
3686: l_return_status,

Line 3700: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3696: --dbms_output.put_line('SUCCESSFUL VALIDATION OVER ... '||l_error_msg_code||'Status :'||l_return_status);
3697:
3698: EXCEPTION
3699: when FND_API.G_EXC_UNEXPECTED_ERROR then
3700: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3701: p_procedure_name => 'VALIDATE_CLASSIFICATIONS',
3702: p_error_text => SUBSTRB(SQLERRM,1,240));
3703: WHEN OTHERS THEN
3704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

Line 3704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3700: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3701: p_procedure_name => 'VALIDATE_CLASSIFICATIONS',
3702: p_error_text => SUBSTRB(SQLERRM,1,240));
3703: WHEN OTHERS THEN
3704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3705: p_procedure_name => 'VALIDATE_CLASSIFICATIONS',
3706: p_error_text => SUBSTRB(SQLERRM,1,240));
3707: raise;
3708:

Line 3877: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS

3873: pa_debug.G_err_stage := 'Calling validate_classifications';
3874: if (p_debug_mode = 'Y') then
3875: pa_debug.debug('Delete classification PVT: Calling API to validate classfications');
3876: end if;
3877: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS
3878: (
3879: p_validation_level => p_validation_level,
3880: p_calling_module => p_calling_module,
3881: p_action => 'DELETE',

Line 3967: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3963: IF p_commit = FND_API.G_TRUE THEN
3964: ROLLBACK TO delete_classifications_pvt;
3965: END IF;
3966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3967: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3968: p_procedure_name => 'DELETE_CLASSIFICATIONS',
3969: p_error_text => SUBSTRB(SQLERRM,1,240));
3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3971:

Line 3983: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

3979: IF p_commit = FND_API.G_TRUE THEN
3980: ROLLBACK TO prm_create_project;
3981: END IF;
3982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3983: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
3984: p_procedure_name => 'DELETE_CLASSIFICATIONS',
3985: p_error_text => SUBSTRB(SQLERRM,1,240));
3986: raise;
3987:

Line 4075: l_project_id pa_projects.project_id%TYPE;

4071: -- end of changes
4072: IS
4073:
4074: l_dummy VARCHAR2(1) := 'N';
4075: l_project_id pa_projects.project_id%TYPE;
4076: l_return_status VARCHAR2(1);
4077: l_error_msg_code VARCHAR2(250);
4078: l_msg_count NUMBER;
4079: l_msg_data VARCHAR2(250);

Line 4134: FROM pa_projects_all

4130: --needed to check whether given project name is unique
4131: CURSOR l_project_name_unique_csr( p_project_name VARCHAR2)
4132: IS
4133: SELECT 'x'
4134: FROM pa_projects_all
4135: WHERE name = p_project_name;
4136:
4137: --needed to check whether given project number is unique
4138: CURSOR l_project_number_unique_csr( p_project_number VARCHAR2)

Line 4141: FROM pa_projects_all

4137: --needed to check whether given project number is unique
4138: CURSOR l_project_number_unique_csr( p_project_number VARCHAR2)
4139: IS
4140: SELECT 'x'
4141: FROM pa_projects_all
4142: WHERE segment1 = p_project_number;
4143:
4144: CURSOR l_project_details_csr( p_project_id NUMBER)
4145: IS

Line 4147: FROM pa_projects_all p -- Bug#3807805 : Modifed pa_projects to pa_projects_all

4143:
4144: CURSOR l_project_details_csr( p_project_id NUMBER)
4145: IS
4146: SELECT *
4147: FROM pa_projects_all p -- Bug#3807805 : Modifed pa_projects to pa_projects_all
4148: WHERE p.project_id = p_project_id
4149: FOR UPDATE OF p.record_version_number;
4150:
4151: Cursor c1 (x_country_code varchar2,

Line 4193: l_project_old_rec pa_projects_all%ROWTYPE; -- Bug#3807805 : Modifed pa_projects to pa_projects_all

4189: where project_type = c_project_type
4190: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4191:
4192: l_unassigned_time pa_project_types.unassigned_time%TYPE;
4193: l_project_old_rec pa_projects_all%ROWTYPE; -- Bug#3807805 : Modifed pa_projects to pa_projects_all
4194: l_project_type_rec get_project_type_info%ROWTYPE;
4195: l_probability_member_id number;
4196:
4197: -- anlee

Line 4263: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

4259: l_update_task_desc_allowed VARCHAR2(1) := 'Y';
4260: l_update_parent_task_allowed VARCHAR2(1) := 'Y';
4261: l_update_task_org_allowed VARCHAR2(1) := 'Y';
4262:
4263: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
4264:
4265: CURSOR get_product_code IS
4266: SELECT pm_product_code
4267: FROM PA_PROJECTS_ALL

Line 4267: FROM PA_PROJECTS_ALL

4263: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
4264:
4265: CURSOR get_product_code IS
4266: SELECT pm_product_code
4267: FROM PA_PROJECTS_ALL
4268: WHERE project_id = p_project_id;
4269: -- anlee end of changes
4270: --bug 3068781 maansari
4271: l_multi_currency_billing_flag VARCHAR2(1);

Line 4679: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

4675: close get_unassigned_time;
4676:
4677: -- Update project attributes from project_type
4678: if nvl(l_unassigned_time,'N') ='Y' then
4679: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
4680: SET role_list_id = l_project_type_rec.role_list_id,
4681: work_type_id = l_project_type_rec.work_type_id,
4682: cost_ind_rate_sch_id = l_project_type_rec.cost_ind_rate_sch_id,
4683: labor_sch_type = l_project_type_rec.labor_sch_type,

Line 4732: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

4728: --federal changes by sunkalya. Bug#5511353.
4729: --End PA L Changes 2872708
4730: WHERE project_id = p_project_id;
4731: else
4732: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
4733: SET role_list_id = l_project_type_rec.role_list_id,
4734: work_type_id = l_project_type_rec.work_type_id,
4735: -- service_type_code = l_project_type_rec.service_type_code,
4736: cost_ind_rate_sch_id = l_project_type_rec.cost_ind_rate_sch_id,

Line 4788: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

4784: WHERE PROJECT_ID = P_PROJECT_ID;
4785:
4786: -- Set cc_tax_task_id if project is a template and cc_prvdr_flag = 'N'
4787: if (l_project_old_rec.template_flag = 'Y') AND (l_project_type_rec.cc_prvdr_flag = 'N') then
4788: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
4789: SET cc_tax_task_id = NULL
4790: WHERE project_id = p_project_id;
4791: end if;
4792:

Line 4872: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

4868: OPEN get_dist_rule(p_project_type);
4869: FETCH get_dist_rule INTO l_distribution_rule;
4870: CLOSE get_dist_rule;
4871:
4872: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
4873: SET distribution_rule = l_distribution_rule
4874: WHERE project_id = p_project_id;
4875:
4876: End If; -- l_project_type_error = FALSE

Line 5229: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

5225: l_project_status_changed := 'Y';
5226:
5227: -- anlee
5228: -- Added validations for bug 2327927
5229: UPDATE pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
5230: SET closed_date = trunc(sysdate)
5231: WHERE project_id = p_project_id;
5232: -- anlee end of changes
5233: ELSIF Pa_project_stus_utils.is_project_status_closed

Line 5302: FROM PA_PROJECTS_ALL

5298:
5299: ELSIF l_verify_ok_flag = 'Y' THEN
5300: SELECT wf_status_code
5301: INTO l_wf_status_code
5302: FROM PA_PROJECTS_ALL
5303: WHERE project_id = p_project_id;
5304:
5305: if l_wf_status_code is null then
5306: IF l_wf_enabled_flag = 'Y' THEN

Line 5308: -- update wf status in pa_projects_all

5304:
5305: if l_wf_status_code is null then
5306: IF l_wf_enabled_flag = 'Y' THEN
5307:
5308: -- update wf status in pa_projects_all
5309: UPDATE pa_projects_all
5310: SET wf_status_code = 'IN_ROUTE',
5311: project_status_code = p_project_status_code
5312: WHERE project_id = p_project_id;

Line 5309: UPDATE pa_projects_all

5305: if l_wf_status_code is null then
5306: IF l_wf_enabled_flag = 'Y' THEN
5307:
5308: -- update wf status in pa_projects_all
5309: UPDATE pa_projects_all
5310: SET wf_status_code = 'IN_ROUTE',
5311: project_status_code = p_project_status_code
5312: WHERE project_id = p_project_id;
5313:

Line 5406: update pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all

5402:
5403: End if;
5404: End if;
5405: end if;
5406: update pa_projects_all -- Bug#3807805 : Modifed pa_projects to pa_projects_all
5407: set location_id = x_location_id
5408: where project_id = p_project_id;
5409: end if; -- P_calling_module 'BASIC_INFO'
5410:

Line 5428: --dbms_output.put_line('BEFORE PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ ');

5424: IF (p_debug_mode = 'Y')
5425: THEN
5426: pa_debug.debug('Validate_project_info PVT: Bill job group validation');
5427: END IF;
5428: --dbms_output.put_line('BEFORE PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ ');
5429:
5430: PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ(
5431: l_project_old_rec.project_type,
5432: p_bill_job_group_id,

Line 5430: PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ(

5426: pa_debug.debug('Validate_project_info PVT: Bill job group validation');
5427: END IF;
5428: --dbms_output.put_line('BEFORE PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ ');
5429:
5430: PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ(
5431: l_project_old_rec.project_type,
5432: p_bill_job_group_id,
5433: l_return_status,
5434: l_error_msg_code);

Line 5436: --dbms_output.put_line('AFTER PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ ');

5432: p_bill_job_group_id,
5433: l_return_status,
5434: l_error_msg_code);
5435:
5436: --dbms_output.put_line('AFTER PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ ');
5437:
5438: IF l_return_status = 'E'
5439: THEN
5440: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 5468: PA_PROJECTS_MAINT_UTILS.CHECK_PROBABILITY_CAN_CHANGE(

5464: IF nvl(p_probability_member_id, -999) <>
5465: nvl(l_project_old_rec.probability_member_id,-999)
5466: THEN
5467:
5468: PA_PROJECTS_MAINT_UTILS.CHECK_PROBABILITY_CAN_CHANGE(
5469: l_project_old_rec.project_status_code,
5470: l_return_status,
5471: l_error_msg_code);
5472: IF l_return_status = 'E'

Line 5498: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

5494:
5495: close l_project_details_csr;
5496:
5497: EXCEPTION WHEN OTHERS THEN
5498: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
5499: p_procedure_name => 'VALIDATE_PROJECT_INFO',
5500: p_error_text => SUBSTRB(SQLERRM,1,240));
5501: raise;
5502:

Line 5517: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM

5513: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
5514: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
5515: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
5516: -- p_project_id IN NUMBER Required
5517: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
5518: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5519: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5520: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
5521: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR

Line 5518: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM

5514: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
5515: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
5516: -- p_project_id IN NUMBER Required
5517: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
5518: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5519: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5520: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
5521: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
5522: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,

Line 5519: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM

5515: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
5516: -- p_project_id IN NUMBER Required
5517: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
5518: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5519: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5520: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
5521: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
5522: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5523: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM

Line 5520: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM

5516: -- p_project_id IN NUMBER Required
5517: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
5518: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5519: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5520: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
5521: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
5522: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5523: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
5524: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,

Line 5521: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR

5517: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
5518: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5519: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5520: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
5521: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
5522: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5523: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
5524: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5525: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM

Line 5523: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM

5519: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
5520: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
5521: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
5522: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5523: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
5524: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5525: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
5526: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5527: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM

Line 5525: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM

5521: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
5522: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5523: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
5524: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5525: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
5526: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5527: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
5528: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
5529: -- p_record_version_number IN NUMBER Required

Line 5527: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM

5523: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
5524: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5525: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
5526: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5527: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
5528: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
5529: -- p_record_version_number IN NUMBER Required
5530: -- x_return_status OUT VARCHAR2 Required
5531: -- x_msg_count OUT NUMBER Required

Line 5528: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR

5524: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5525: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
5526: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
5527: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
5528: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
5529: -- p_record_version_number IN NUMBER Required
5530: -- x_return_status OUT VARCHAR2 Required
5531: -- x_msg_count OUT NUMBER Required
5532: -- x_msg_data OUT VARCHAR2 Required

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

5544: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
5545: p_debug_mode IN VARCHAR2 := 'N' ,
5546: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
5547: p_project_id IN NUMBER ,
5548: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
5549: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
5550: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
5551: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,

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

5545: p_debug_mode IN VARCHAR2 := 'N' ,
5546: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
5547: p_project_id IN NUMBER ,
5548: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
5549: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
5550: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
5551: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
5553: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,

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

5546: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
5547: p_project_id IN NUMBER ,
5548: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
5549: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
5550: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
5551: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
5553: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
5554: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,

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

5547: p_project_id IN NUMBER ,
5548: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
5549: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
5550: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
5551: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
5553: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
5554: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
5555: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

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

5548: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
5549: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
5550: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
5551: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
5553: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
5554: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
5555: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
5556: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,

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

5549: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
5550: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
5551: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
5553: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
5554: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
5555: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
5556: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
5557: p_record_version_number IN NUMBER ,

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

5550: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
5551: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
5553: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
5554: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
5555: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
5556: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
5557: p_record_version_number IN NUMBER ,
5558: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

5551: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
5553: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
5554: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
5555: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
5556: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
5557: p_record_version_number IN NUMBER ,
5558: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
5559: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

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

5552: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
5553: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
5554: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
5555: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
5556: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
5557: p_record_version_number IN NUMBER ,
5558: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
5559: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
5560: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 5570: l_comp_match_weighting pa_projects_all.COMPETENCE_MATCH_WT%TYPE;

5566: l_data VARCHAR2(250);
5567: l_dummy VARCHAR2(1);
5568:
5569:
5570: l_comp_match_weighting pa_projects_all.COMPETENCE_MATCH_WT%TYPE;
5571: l_avail_match_weighting pa_projects_all.availability_match_wt%TYPE;
5572: l_job_level_match_weighting pa_projects_all.job_level_match_wt%TYPE;
5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;
5574: l_search_country_code pa_projects_all.search_country_code%TYPE;

Line 5571: l_avail_match_weighting pa_projects_all.availability_match_wt%TYPE;

5567: l_dummy VARCHAR2(1);
5568:
5569:
5570: l_comp_match_weighting pa_projects_all.COMPETENCE_MATCH_WT%TYPE;
5571: l_avail_match_weighting pa_projects_all.availability_match_wt%TYPE;
5572: l_job_level_match_weighting pa_projects_all.job_level_match_wt%TYPE;
5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;
5574: l_search_country_code pa_projects_all.search_country_code%TYPE;
5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;

Line 5572: l_job_level_match_weighting pa_projects_all.job_level_match_wt%TYPE;

5568:
5569:
5570: l_comp_match_weighting pa_projects_all.COMPETENCE_MATCH_WT%TYPE;
5571: l_avail_match_weighting pa_projects_all.availability_match_wt%TYPE;
5572: l_job_level_match_weighting pa_projects_all.job_level_match_wt%TYPE;
5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;
5574: l_search_country_code pa_projects_all.search_country_code%TYPE;
5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
5576: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;

Line 5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;

5569:
5570: l_comp_match_weighting pa_projects_all.COMPETENCE_MATCH_WT%TYPE;
5571: l_avail_match_weighting pa_projects_all.availability_match_wt%TYPE;
5572: l_job_level_match_weighting pa_projects_all.job_level_match_wt%TYPE;
5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;
5574: l_search_country_code pa_projects_all.search_country_code%TYPE;
5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
5576: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
5577: l_search_min_candidate_score pa_projects_all.min_cand_score_reqd_for_nom%TYPE;

Line 5574: l_search_country_code pa_projects_all.search_country_code%TYPE;

5570: l_comp_match_weighting pa_projects_all.COMPETENCE_MATCH_WT%TYPE;
5571: l_avail_match_weighting pa_projects_all.availability_match_wt%TYPE;
5572: l_job_level_match_weighting pa_projects_all.job_level_match_wt%TYPE;
5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;
5574: l_search_country_code pa_projects_all.search_country_code%TYPE;
5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
5576: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
5577: l_search_min_candidate_score pa_projects_all.min_cand_score_reqd_for_nom%TYPE;
5578: l_enable_auto_cand_nom_flag pa_projects_all.enable_automated_search%TYPE;

Line 5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;

5571: l_avail_match_weighting pa_projects_all.availability_match_wt%TYPE;
5572: l_job_level_match_weighting pa_projects_all.job_level_match_wt%TYPE;
5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;
5574: l_search_country_code pa_projects_all.search_country_code%TYPE;
5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
5576: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
5577: l_search_min_candidate_score pa_projects_all.min_cand_score_reqd_for_nom%TYPE;
5578: l_enable_auto_cand_nom_flag pa_projects_all.enable_automated_search%TYPE;
5579:

Line 5576: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;

5572: l_job_level_match_weighting pa_projects_all.job_level_match_wt%TYPE;
5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;
5574: l_search_country_code pa_projects_all.search_country_code%TYPE;
5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
5576: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
5577: l_search_min_candidate_score pa_projects_all.min_cand_score_reqd_for_nom%TYPE;
5578: l_enable_auto_cand_nom_flag pa_projects_all.enable_automated_search%TYPE;
5579:
5580: BEGIN

Line 5577: l_search_min_candidate_score pa_projects_all.min_cand_score_reqd_for_nom%TYPE;

5573: l_search_min_availability pa_projects_all.search_min_availability%TYPE;
5574: l_search_country_code pa_projects_all.search_country_code%TYPE;
5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
5576: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
5577: l_search_min_candidate_score pa_projects_all.min_cand_score_reqd_for_nom%TYPE;
5578: l_enable_auto_cand_nom_flag pa_projects_all.enable_automated_search%TYPE;
5579:
5580: BEGIN
5581:

Line 5578: l_enable_auto_cand_nom_flag pa_projects_all.enable_automated_search%TYPE;

5574: l_search_country_code pa_projects_all.search_country_code%TYPE;
5575: l_search_exp_org_struct_ver_id pa_projects_all.search_org_hier_id%TYPE;
5576: l_search_exp_start_org_id pa_projects_all.search_starting_org_id%TYPE;
5577: l_search_min_candidate_score pa_projects_all.min_cand_score_reqd_for_nom%TYPE;
5578: l_enable_auto_cand_nom_flag pa_projects_all.enable_automated_search%TYPE;
5579:
5580: BEGIN
5581:
5582: IF p_commit = FND_API.G_TRUE THEN

Line 5595: FROM pa_projects

5591: -- write your program logic from here
5592: if p_validate_only <> FND_API.G_TRUE then
5593: BEGIN
5594: SELECT 'x' INTO l_dummy
5595: FROM pa_projects
5596: WHERE project_id = p_project_id
5597: AND record_version_number = p_record_version_number
5598: FOR UPDATE OF record_version_number NOWAIT;
5599: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN

Line 5628: FROM pa_projects

5624: END;
5625: else
5626: BEGIN
5627: SELECT 'x' INTO l_dummy
5628: FROM pa_projects
5629: WHERE project_id = p_project_id
5630: AND record_version_number = p_record_version_number;
5631: EXCEPTION
5632: WHEN NO_DATA_FOUND THEN

Line 5666: pa_debug.debug('Update_project_staffing_info PVT: update pa_projects table');

5662:
5663: IF NOT FND_API.TO_BOOLEAN(p_validate_only)
5664: THEN
5665: if (p_debug_mode = 'Y') then
5666: pa_debug.debug('Update_project_staffing_info PVT: update pa_projects table');
5667: end if;
5668: if p_comp_match_weighting = FND_API.G_MISS_NUM then
5669: l_comp_match_weighting := null;
5670: else

Line 5723: UPDATE pa_projects_all

5719: else
5720: l_enable_auto_cand_nom_flag := p_enable_auto_cand_nom_flag;
5721: end if;
5722:
5723: UPDATE pa_projects_all
5724: SET record_version_number = record_version_number +1 ,
5725: COMPETENCE_MATCH_WT = p_comp_match_weighting,
5726: AVAILABILITY_MATCH_WT = p_avail_match_weighting,
5727: JOB_LEVEL_MATCH_WT = p_job_level_match_weighting,

Line 5747: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

5743: IF p_commit = FND_API.G_TRUE THEN
5744: ROLLBACK TO update_project_staffing_info;
5745: END IF;
5746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5747: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
5748: p_procedure_name => 'UPDATE_PROJECT_STAFFING_INFO',
5749: p_error_text => SUBSTRB(SQLERRM,1,240));
5750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5751:

Line 5763: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

5759: IF p_commit = FND_API.G_TRUE THEN
5760: ROLLBACK TO update_project_staffing_info;
5761: END IF;
5762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5763: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
5764: p_procedure_name => 'UPDATE_PROJECT_STAFFING_INFO',
5765: p_error_text => SUBSTRB(SQLERRM,1,240));
5766: raise;
5767:

Line 5770: END PA_PROJECTS_MAINT_PVT;

5766: raise;
5767:
5768: END UPDATE_PROJECT_STAFFING_INFO;
5769:
5770: END PA_PROJECTS_MAINT_PVT;