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_ALL

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 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 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 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 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 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 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 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 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 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 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 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 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 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,