DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_RESOURCE_ASSIGNMENTS_S

Line 405: --in pa_resource_assignments should be nulled out.

401: --Added the check for FND_API.G_MISS_XXX in the below decodes as the UI can pass input parameters
402: --as FND_API.G_MISS_XXX even if the existing value of the attribute is NULL. NOTE: The input parameter
403: --to update_planning_transactions should be NULL if the corresponding column in pa_resource_assignments
404: --should not be changed and the input parameter should be FND_API.G_MISS_XXX if thhe corresponding column
405: --in pa_resource_assignments should be nulled out.
406: FOR i IN p_resource_assignment_id_tbl.FIRST .. p_resource_assignment_id_tbl.LAST LOOP
407:
408: --dbms_output.put_line('6.2 '||p_resource_assignment_id_tbl(i) );
409:

Line 4349: PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL -- RESOURCE_ASSIGNMENT_ID

4345: ,RATE_EXPENDITURE_ORG_ID,INCUR_BY_RES_CLASS_CODE,INCUR_BY_ROLE_ID
4346: ,PROJECT_ROLE_ID,RESOURCE_CLASS_FLAG,NAMED_ROLE,TXN_ACCUM_HEADER_ID
4347: ,PM_PRODUCT_CODE, PM_RES_ASSIGNMENT_REFERENCE, resource_rate_based_flag)
4348: VALUES (
4349: PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL -- RESOURCE_ASSIGNMENT_ID
4350: ,l_budget_version_id -- BUDGET_VERSION_ID
4351: ,p_project_id -- PROJECT_ID
4352: ,l_ins_proj_element_id_tbl(i) -- TASK_ID
4353: ,l_people_res_class_rlm_id -- RESOURCE_LIST_MEMBER_ID

Line 4640: VALUES(PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL -- RESOURCE_ASSIGNMENT_ID

4636: ,RATE_EXPENDITURE_ORG_ID,INCUR_BY_RES_CLASS_CODE,INCUR_BY_ROLE_ID
4637: ,PROJECT_ROLE_ID,RESOURCE_CLASS_FLAG,NAMED_ROLE,TXN_ACCUM_HEADER_ID,UNPLANNED_FLAG
4638: ,PM_PRODUCT_CODE, PM_RES_ASSIGNMENT_REFERENCE,SCHEDULED_DELAY, resource_rate_based_flag,
4639: cbs_element_id) --Bug#16200605
4640: VALUES(PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL -- RESOURCE_ASSIGNMENT_ID
4641: ,l_budget_version_id -- BUDGET_VERSION_ID
4642: ,p_project_id -- PROJECT_ID
4643: ,decode(p_one_to_one_mapping_flag,'Y',l_proj_elem_rlm_tbl(j)
4644: ,l_proj_element_id_tbl(i)) -- TASK_ID

Line 5183: ( pa_resource_assignments_s.nextval -- RESOURCE_ASSIGNMENT_ID

5179: ,PM_PRODUCT_CODE, PM_RES_ASSIGNMENT_REFERENCE, resource_rate_based_flag,
5180: cbs_element_id --Bug#16200605
5181: )
5182: VALUES
5183: ( pa_resource_assignments_s.nextval -- RESOURCE_ASSIGNMENT_ID
5184: ,l_budget_version_id -- BUDGET_VERSION_ID
5185: ,p_project_id -- PROJECT_ID
5186: ,decode(p_one_to_one_mapping_flag,'Y',l_bf_proj_elem_tbl(j)
5187: ,l_proj_element_id_tbl(i)) -- TASK_ID