DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3413: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3409: Rec_Count NUMBER;
3410: ----------------------------------- FP_M changes : End
3411:
3412: --Added for 14209636
3413: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3414: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3415: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3416: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3417: -- l_Src_Proj_Element_id NUMBER;

Line 3414: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3410: ----------------------------------- FP_M changes : End
3411:
3412: --Added for 14209636
3413: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3414: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3415: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3416: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3417: -- l_Src_Proj_Element_id NUMBER;
3418: l_errorcode NUMBER;

Line 3415: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3411:
3412: --Added for 14209636
3413: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3414: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3415: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3416: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3417: -- l_Src_Proj_Element_id NUMBER;
3418: l_errorcode NUMBER;
3419: /* not required

Line 3416: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3412: --Added for 14209636
3413: l_orig_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3414: l_new_proj_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3415: l_orig_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3416: l_new_task_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3417: -- l_Src_Proj_Element_id NUMBER;
3418: l_errorcode NUMBER;
3419: /* not required
3420: CURSOR cur_dest_proj_element_id(c_dest_task_version_id NUMBER,c_project_id NUMBER)

Line 4831: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_src_project_id));

4827:
4828:
4829: /* Added for 14209636 */
4830: IF (p_user_defn_att_flag='Y') THEN
4831: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_src_project_id));
4832: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_dest_project_id));
4833: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_task_id));
4834: /* not required
4835: if(p_src_task_version_id is not NULL) THEN

Line 4832: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_dest_project_id));

4828:
4829: /* Added for 14209636 */
4830: IF (p_user_defn_att_flag='Y') THEN
4831: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_src_project_id));
4832: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_dest_project_id));
4833: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_task_id));
4834: /* not required
4835: if(p_src_task_version_id is not NULL) THEN
4836: OPEN cur_dest_proj_element_id(p_src_task_version_id,p_src_project_id);

Line 4833: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_task_id));

4829: /* Added for 14209636 */
4830: IF (p_user_defn_att_flag='Y') THEN
4831: l_orig_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_src_project_id));
4832: l_new_proj_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJECT_ID', p_dest_project_id));
4833: l_new_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', l_task_id));
4834: /* not required
4835: if(p_src_task_version_id is not NULL) THEN
4836: OPEN cur_dest_proj_element_id(p_src_task_version_id,p_src_project_id);
4837: FETCH cur_dest_proj_element_id into l_Src_Proj_Element_id;

Line 4841: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', cur_obj_rel_rec.proj_element_id));

4837: FETCH cur_dest_proj_element_id into l_Src_Proj_Element_id;
4838: CLOSE cur_dest_proj_element_id;
4839: END IF;
4840: */
4841: l_orig_task_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PROJ_ELEMENT_ID', cur_obj_rel_rec.proj_element_id));
4842:
4843: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data (
4844: p_api_version => 1.0
4845: ,p_application_id => 275