[Home] [Help]
1072: OR (px_resource_list_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1073: AND px_resource_list_id IS NOT NULL) THEN
1074: -- convert resource_list_name to resource_list_id
1075: px_resource_list_id_in := px_resource_list_id;
1076: pa_resource_pub.Convert_List_name_to_id
1077: ( p_resource_list_name => px_resource_list_name,
1078: p_resource_list_id => px_resource_list_id_in,
1079: p_out_resource_list_id => px_resource_list_id,
1080: p_return_status => x_return_status );
1758: ELSE
1759:
1760: -- convert resource_list_name to resource_list_id
1761: px_resource_list_id_in := px_resource_list_id;
1762: pa_resource_pub.Convert_List_name_to_id
1763: ( p_resource_list_name => px_resource_list_name,
1764: p_resource_list_id => px_resource_list_id_in,
1765: p_out_resource_list_id => px_resource_list_id,
1766: p_return_status => x_return_status );
7021: AND px_budget_lines_in(i).resource_list_member_id IS NOT NULL)
7022: THEN
7023:
7024: --Selecting the index if it will be based on rlm_id or resource_alias. This index is decided on the
7025: --basis of whther this (pa_resource_pub.Convert_alias_to_id ) API call would honour the
7026: --rlm_id or resource_alias. The rule is rlm_id is honoured if both are passed to the API
7027: --otherwise whichever value is passed that value is honoured by the API.
7028: --Also note while preparing the index we are prepending 'RLMID' or 'RALIAS' before the actual values.
7029: --The index would always be in this format.
7049: --rlm_id/resource_alias). If present then read the rlm_id from the table for this index
7050: --else call the api.
7051: IF( NOT(l_rlm_id_tbl.exists(l_distinct_rlmid_idx) ) )
7052: THEN
7053: pa_resource_pub.Convert_alias_to_id
7054: ( p_project_id => p_pa_project_id
7055: ,p_resource_list_id => p_resource_list_id
7056: ,p_alias => px_budget_lines_in(i).resource_alias
7057: ,p_resource_list_member_id => px_budget_lines_in(i).resource_list_member_id
7219: END IF;
7220: END IF;
7221: --Changed the if below for bug#4488926.
7222: IF (l_valid_rlmid = 'Y') THEN /*l_valid_rlmid equal to Y would ensure that no error
7223: occurred after the API call pa_resource_pub.Convert_alias_to_id made above till this
7224: point in code*/
7225: --If the API completes and above validations completes successfully then store the rlm_id in the
7226: --l_rlm_id_tbl at the location indexed by l_distinct_rlmid_idx.
7227: l_rlm_id_tbl(l_distinct_rlmid_idx) := px_budget_lines_in(i).resource_list_member_id;