APPS.PA_MASS_ASGMT_TRX dependencies on FND_LOOKUPS

Line 1268: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;

1264: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1265: l_search_exp_start_org_name hr_organization_units.name%TYPE;
1266: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1267: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
1268: l_enable_auto_cand_nom_meaning fnd_lookups.meaning%TYPE;
1269: l_fcst_tp_amount_type pa_project_assignments.fcst_tp_amount_type%TYPE;
1270: l_fcst_job_id NUMBER;
1271: l_fcst_job_group_id NUMBER;
1272: l_expenditure_org_id NUMBER;

Line 1329: l_extension_possible_meaning fnd_lookups.meaning%TYPE;

1325: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1326: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1327: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1328: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1329: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1330: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;
1331: l_expense_owner_meaning pa_lookups.meaning%TYPE;
1332: l_fcst_tp_amount_type_meaning pa_lookups.meaning%TYPE;
1333: l_rating_level per_rating_levels_v.step_value%TYPE;

Line 1330: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;

1326: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1327: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1328: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1329: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1330: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;
1331: l_expense_owner_meaning pa_lookups.meaning%TYPE;
1332: l_fcst_tp_amount_type_meaning pa_lookups.meaning%TYPE;
1333: l_rating_level per_rating_levels_v.step_value%TYPE;
1334: l_submitter_user_id NUMBER;

Line 1492: FROM fnd_lookups

1488: --append to x_document to display the Updated Information region in the wf notification
1489: --get the meaning as we will not have it as the field is a poplist on the page
1490: IF l_extension_possible <> FND_API.G_MISS_CHAR AND l_extension_possible IS NOT NULL THEN
1491: SELECT meaning INTO l_extension_possible_meaning
1492: FROM fnd_lookups
1493: WHERE lookup_type='YES_NO'
1494: AND lookup_code = l_extension_possible;
1495: x_document := x_document||get_translated_attr_name('EXTENSION_POSSIBLE')||' - '||l_extension_possible_meaning||'
';
1496: END IF;

Line 1775: FROM fnd_lookups

1771: --if the attribute has been updated then
1772: --append to x_document to display the Updated Information region in the wf notification
1773: IF L_ENABLE_AUTO_CAND_NOM_FLAG <> FND_API.G_MISS_CHAR AND L_ENABLE_AUTO_CAND_NOM_FLAG IS NOT NULL THEN
1774: SELECT meaning INTO L_ENABLE_AUTO_CAND_NOM_MEANING
1775: FROM fnd_lookups
1776: WHERE lookup_type='YES_NO'
1777: AND lookup_code = L_ENABLE_AUTO_CAND_NOM_FLAG;
1778: x_document := x_document||get_translated_attr_name('ENABLE_AUTO_CAND_NOM_FLAG')||' - '||L_ENABLE_AUTO_CAND_NOM_MEANING||'
';
1779: END IF;

Line 2170: FROM fnd_lookups

2166: --if mandatory_flag is not null then get the meaning
2167: --in order to display on the wf notification.
2168: IF l_mandatory_flag_tbl(i) <> FND_API.G_MISS_CHAR AND l_mandatory_flag_tbl(i) IS NOT NULL THEN
2169: SELECT meaning INTO l_mandatory_flag_meaning
2170: FROM fnd_lookups
2171: WHERE lookup_type = 'YES_NO'
2172: AND lookup_code = l_mandatory_flag_tbl(i);
2173: END IF;
2174: