[Home] [Help]
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
34: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
40: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
112: IS
113:
114: CURSOR csr_get_tp_amt_type_name (p_tp_amt_type IN VARCHAR2) IS
115: SELECT plks.meaning
116: FROM pa_lookups plks
117: WHERE plks.lookup_type = 'TP_AMOUNT_TYPE'
118: AND plks.lookup_code = p_tp_amt_type;
119:
120: l_item_type VARCHAR2(8) := 'PARMATRX';
807: l_first_assignment_id NUMBER;
808: l_document VARCHAR2(32767);
809: l_conflict_group_id NUMBER;
810: l_overcommitment_flag VARCHAR2(1);
811: l_resolve_con_action_code pa_lookups.meaning%TYPE;
812: l_view_conflicts_link VARCHAR2(2000);
813: l_conf_asgmt_count NUMBER;
814: l_message_name fnd_new_messages.message_name%TYPE;
815: l_view_conf_action_text fnd_new_messages.message_text%TYPE;
1255:
1256: -- Added for Perf fix 4918687 SQL ID 14910597
1257: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
1258: SELECT lkup.meaning fcst_tp_amount_type_name
1259: FROM pa_project_assignments asgn, pa_lookups lkup
1260: WHERE lkup.lookup_type(+) = 'TP_AMOUNT_TYPE'
1261: AND asgn.fcst_tp_amount_type = lkup.lookup_code(+)
1262: AND asgn.assignment_id = p_asg_id;
1263:
1297: l_project_name pa_projects_all.name%TYPE;
1298: l_project_number pa_projects_all.segment1%TYPE;
1299: l_project_subteam_name pa_project_subteams.name%TYPE;
1300: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1301: l_staffing_priority_name pa_lookups.meaning%TYPE;
1302: l_project_role_name pa_project_role_types.meaning%TYPE;
1303: l_location_city pa_locations.city%TYPE;
1304: l_location_region pa_locations.region%TYPE;
1305: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
1384: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1386: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1387: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;
1388: l_expense_owner_meaning pa_lookups.meaning%TYPE;
1389: l_fcst_tp_amount_type_meaning pa_lookups.meaning%TYPE;
1390: l_rating_level per_rating_levels_v.step_value%TYPE;
1391: l_submitter_user_id NUMBER;
1392: l_submitter_resp_id NUMBER;
1385: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1386: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1387: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;
1388: l_expense_owner_meaning pa_lookups.meaning%TYPE;
1389: l_fcst_tp_amount_type_meaning pa_lookups.meaning%TYPE;
1390: l_rating_level per_rating_levels_v.step_value%TYPE;
1391: l_submitter_user_id NUMBER;
1392: l_submitter_resp_id NUMBER;
1393: l_submitter_resp_appl_id NUMBER;
1496: --get the name as we will only have the code as the field is a poplist on the page
1497: IF l_staffing_priority_code <> FND_API.G_MISS_CHAR AND l_staffing_priority_code IS NOT NULL THEN
1498: IF l_staffing_priority_name = FND_API.G_MISS_CHAR OR l_staffing_priority_name IS NULL THEN
1499: SELECT meaning INTO l_staffing_priority_name
1500: FROM pa_lookups
1501: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'
1502: AND lookup_code = l_staffing_priority_code;
1503: END IF;
1504: x_document := x_document||get_translated_attr_name('STAFFING_PRIORITY_NAME')||' - '||l_staffing_priority_name||'
';
1708: --append to x_document to display the Updated Information region in the wf notification
1709: --get the meaning as we will not have it as the field is a poplist on the page
1710: IF l_expense_owner <> FND_API.G_MISS_CHAR AND l_expense_owner IS NOT NULL THEN
1711: SELECT meaning INTO l_expense_owner_meaning
1712: FROM pa_lookups
1713: WHERE lookup_type = 'EXPENSE_OWNER_TYPE'
1714: AND lookup_code = l_expense_owner;
1715: x_document := x_document||get_translated_attr_name('EXPENSE_OWNER')||' - '||l_expense_owner_meaning||'
';
1716: END IF;
1865: --append to x_document to display the Updated Information region in the wf notification
1866: --get the meaning as we will not have it as the field is a poplist on the page
1867: IF l_fcst_tp_amount_type <> FND_API.G_MISS_CHAR AND l_fcst_tp_amount_type IS NOT NULL THEN
1868: SELECT meaning INTO l_fcst_tp_amount_type_meaning
1869: FROM pa_lookups
1870: WHERE lookup_type = 'TP_AMOUNT_TYPE'
1871: AND lookup_code = l_fcst_tp_amount_type;
1872: x_document := x_document||get_translated_attr_name('FCST_TP_AMOUNT_TYPE')||' - '||l_fcst_tp_amount_type_meaning||'
';
1873: END IF;
2767: FUNCTION Is_Asgmt_Revert_Or_Cancel(p_conflict_group_id IN NUMBER,
2768: p_assignment_id IN pa_project_assignments.assignment_id%TYPE)
2769: RETURN BOOLEAN IS
2770:
2771: l_resolve_con_action_code pa_lookups.meaning%TYPE;
2772:
2773: CURSOR check_asgmt_revert_or_cancel IS
2774: SELECT resolve_conflicts_action_code
2775: FROM pa_assignment_conflict_hist
3112: --get the translated updated attribute name from lookups.
3113: --this will be displayed in the Updated Information section of the mass update
3114: --workflow notification.
3115: SELECT meaning INTO l_meaning
3116: FROM pa_lookups
3117: WHERE lookup_type = 'MASS_ASSIGNMENT_UPDATE_ATTR'
3118: AND lookup_code = p_lookup_code;
3119:
3120: RETURN l_meaning;