APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_RESOURCE_ASSIGNMENTS_S

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

345: --Added the check for FND_API.G_MISS_XXX in the below decodes as the UI can pass input parameters
346: --as FND_API.G_MISS_XXX even if the existing value of the attribute is NULL. NOTE: The input parameter
347: --to update_planning_transactions should be NULL if the corresponding column in pa_resource_assignments
348: --should not be changed and the input parameter should be FND_API.G_MISS_XXX if thhe corresponding column
349: --in pa_resource_assignments should be nulled out.
350: FOR i IN p_resource_assignment_id_tbl.FIRST .. p_resource_assignment_id_tbl.LAST LOOP
351:
352: --dbms_output.put_line('6.2 '||p_resource_assignment_id_tbl(i) );
353:

Line 3993: PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL -- RESOURCE_ASSIGNMENT_ID

3989: ,RATE_EXPENDITURE_ORG_ID,INCUR_BY_RES_CLASS_CODE,INCUR_BY_ROLE_ID
3990: ,PROJECT_ROLE_ID,RESOURCE_CLASS_FLAG,NAMED_ROLE,TXN_ACCUM_HEADER_ID
3991: ,PM_PRODUCT_CODE, PM_RES_ASSIGNMENT_REFERENCE, resource_rate_based_flag)
3992: VALUES (
3993: PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL -- RESOURCE_ASSIGNMENT_ID
3994: ,l_budget_version_id -- BUDGET_VERSION_ID
3995: ,p_project_id -- PROJECT_ID
3996: ,l_ins_proj_element_id_tbl(i) -- TASK_ID
3997: ,l_people_res_class_rlm_id -- RESOURCE_LIST_MEMBER_ID

Line 4244: VALUES(PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL -- RESOURCE_ASSIGNMENT_ID

4240: ,SP_FIXED_DATE,PERSON_TYPE_CODE,RATE_BASED_FLAG,USE_TASK_SCHEDULE_FLAG,RATE_EXP_FUNC_CURR_CODE
4241: ,RATE_EXPENDITURE_ORG_ID,INCUR_BY_RES_CLASS_CODE,INCUR_BY_ROLE_ID
4242: ,PROJECT_ROLE_ID,RESOURCE_CLASS_FLAG,NAMED_ROLE,TXN_ACCUM_HEADER_ID,UNPLANNED_FLAG
4243: ,PM_PRODUCT_CODE, PM_RES_ASSIGNMENT_REFERENCE,SCHEDULED_DELAY, resource_rate_based_flag)
4244: VALUES(PA_RESOURCE_ASSIGNMENTS_S.NEXTVAL -- RESOURCE_ASSIGNMENT_ID
4245: ,l_budget_version_id -- BUDGET_VERSION_ID
4246: ,p_project_id -- PROJECT_ID
4247: ,decode(p_one_to_one_mapping_flag,'Y',l_proj_elem_rlm_tbl(j)
4248: ,l_proj_element_id_tbl(i)) -- TASK_ID

Line 4595: ( pa_resource_assignments_s.nextval -- RESOURCE_ASSIGNMENT_ID

4591: ,RATE_EXPENDITURE_ORG_ID,INCUR_BY_RES_CLASS_CODE,INCUR_BY_ROLE_ID
4592: ,PROJECT_ROLE_ID,RESOURCE_CLASS_FLAG,NAMED_ROLE,TXN_ACCUM_HEADER_ID
4593: ,PM_PRODUCT_CODE, PM_RES_ASSIGNMENT_REFERENCE, resource_rate_based_flag)
4594: VALUES
4595: ( pa_resource_assignments_s.nextval -- RESOURCE_ASSIGNMENT_ID
4596: ,l_budget_version_id -- BUDGET_VERSION_ID
4597: ,p_project_id -- PROJECT_ID
4598: ,decode(p_one_to_one_mapping_flag,'Y',l_bf_proj_elem_tbl(j)
4599: ,l_proj_element_id_tbl(i)) -- TASK_ID