APPS.PA_MASS_ASGMT_TRX dependencies on FND_LOOKUPS

Line 1325: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;

1321: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1322: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1323: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1324: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1325: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;
1326: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
1327: l_fcst_job_id NUMBER;
1328: l_fcst_job_group_id NUMBER;
1329: l_expenditure_org_id NUMBER;

Line 1386: l_extension_possible_meaning fnd_lookups.meaning%TYPE;

1382: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1383: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_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;

Line 1387: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;

1383: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_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;

Line 1549: FROM fnd_lookups

1545: --append to x_document to display the Updated Information region in the wf notification
1546: --get the meaning as we will not have it as the field is a poplist on the page
1547: IF l_extension_possible <> FND_API.G_MISS_CHAR AND l_extension_possible IS NOT NULL THEN
1548: SELECT meaning INTO l_extension_possible_meaning
1549: FROM fnd_lookups
1550: WHERE lookup_type='YES_NO'
1551: AND lookup_code = l_extension_possible;
1552: x_document := x_document||get_translated_attr_name('EXTENSION_POSSIBLE')||' - '||l_extension_possible_meaning||'
';
1553: END IF;

Line 1832: FROM fnd_lookups

1828: --if the attribute has been updated then
1829: --append to x_document to display the Updated Information region in the wf notification
1830: IF L_ENABLE_AUTO_CAND_NOM_FLAG <> FND_API.G_MISS_CHAR AND L_ENABLE_AUTO_CAND_NOM_FLAG IS NOT NULL THEN
1831: SELECT meaning INTO L_ENABLE_AUTO_CAND_NOM_MEANING
1832: FROM fnd_lookups
1833: WHERE lookup_type='YES_NO'
1834: AND lookup_code = L_ENABLE_AUTO_CAND_NOM_FLAG;
1835: x_document := x_document||get_translated_attr_name('ENABLE_AUTO_CAND_NOM_FLAG')||' - '||L_ENABLE_AUTO_CAND_NOM_MEANING||'
';
1836: END IF;

Line 2227: FROM fnd_lookups

2223: --if mandatory_flag is not null then get the meaning
2224: --in order to display on the wf notification.
2225: IF l_mandatory_flag_tbl(i) <> FND_API.G_MISS_CHAR AND l_mandatory_flag_tbl(i) IS NOT NULL THEN
2226: SELECT meaning INTO l_mandatory_flag_meaning
2227: FROM fnd_lookups
2228: WHERE lookup_type = 'YES_NO'
2229: AND lookup_code = l_mandatory_flag_tbl(i);
2230: END IF;
2231: