DBA Data[Home] [Help]

APPS.PA_RELATIONSHIP_PVT dependencies on FND_GLOBAL

Line 479: p_user_id => FND_GLOBAL.USER_ID

475: l_id_from := l_task_version_id;
476: l_type_from := 'PA_TASKS';
477:
478: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
479: p_user_id => FND_GLOBAL.USER_ID
480: ,p_object_type_from => l_type_from
481: ,p_object_id_from1 => l_id_from
482: ,p_object_id_from2 => NULL
483: ,p_object_id_from3 => NULL

Line 550: p_user_id => FND_GLOBAL.USER_ID

546: l_weighting_percentage := p_weighting_percentage;
547: END IF;
548:
549: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
550: p_user_id => FND_GLOBAL.USER_ID
551: ,p_object_type_from => l_type_from
552: ,p_object_id_from1 => l_id_from
553: ,p_object_id_from2 => NULL
554: ,p_object_id_from3 => NULL

Line 605: p_user_id => FND_GLOBAL.USER_ID

601: l_id_to := p_task_version_id_to;
602: l_type_to := 'PA_TASKS';
603: END IF;
604: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
605: p_user_id => FND_GLOBAL.USER_ID
606: , p_object_type_from => l_type_from
607: , p_object_id_from1 => l_id_from
608: , p_object_id_from2 => NULL
609: , p_object_id_from3 => NULL

Line 804: p_user_id => FND_GLOBAL.USER_ID

800: END IF;
801: -- End 4537865
802:
803: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
804: p_user_id => FND_GLOBAL.USER_ID
805: ,p_object_type_from => l_type_from
806: ,p_object_id_from1 => l_id_from
807: ,p_object_id_from2 => NULL
808: ,p_object_id_from3 => NULL

Line 1252: p_user_id => FND_GLOBAL.USER_ID

1248: END IF;
1249:
1250: --Create record in relationships table.
1251: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1252: p_user_id => FND_GLOBAL.USER_ID
1253: ,p_object_type_from => 'PA_TASKS'
1254: ,p_object_id_from1 => p_src_task_ver_id
1255: ,p_object_id_from2 => p_src_proj_id
1256: ,p_object_id_from3 => NULL

Line 1357: p_user_id => FND_GLOBAL.USER_ID

1353: END IF;
1354:
1355: --Create record in relationships table.
1356: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1357: p_user_id => FND_GLOBAL.USER_ID
1358: ,p_object_type_from => 'PA_TASKS'
1359: ,p_object_id_from1 => p_src_task_ver_id
1360: ,p_object_id_from2 => p_src_proj_id
1361: ,p_object_id_from3 => NULL

Line 1542: ( p_user_id => FND_GLOBAL.USER_ID

1538:
1539: --update record in object relationships table
1540:
1541: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW
1542: ( p_user_id => FND_GLOBAL.USER_ID
1543: ,p_object_relationship_id => l_obj_rel_rec.object_relationship_id
1544: ,p_relationship_type => l_obj_rel_rec.relationship_type
1545: ,p_relationship_subtype => l_rel_subtype
1546: ,p_lag_day => l_lag_days

Line 2055: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

2051: l_debug_mode VARCHAR2(1); --debug messages added while fixing bug 5067296
2052: BEGIN
2053:
2054: --debug messages added while fixing bug 5067296
2055: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
2056:
2057: IF (l_debug_mode = 'Y') THEN
2058: pa_debug.write(x_Module=>'PA_RELATIONSHIP_PVT.COPY_INTRA_DEPENDENCY', x_Msg => 'PA_RELATIONSHIP_PVT.COPY_INTRA_DEPENDENCY Start : Passed Parameters :', x_Log_Level=> 3);
2059: /* These two lines are causing bug 5076461 in publish flow.

Line 2236: ,FND_GLOBAL.USER_ID

2232: ,RECORD_VERSION_NUMBER
2233: )
2234: VALUES (
2235: pa_object_relationships_s.nextval
2236: ,FND_GLOBAL.USER_ID
2237: ,sysdate
2238: ,FND_GLOBAL.USER_ID
2239: ,sysdate
2240: ,FND_GLOBAL.USER_ID

Line 2238: ,FND_GLOBAL.USER_ID

2234: VALUES (
2235: pa_object_relationships_s.nextval
2236: ,FND_GLOBAL.USER_ID
2237: ,sysdate
2238: ,FND_GLOBAL.USER_ID
2239: ,sysdate
2240: ,FND_GLOBAL.USER_ID
2241: ,'D'
2242: ,'PA_TASKS'

Line 2240: ,FND_GLOBAL.USER_ID

2236: ,FND_GLOBAL.USER_ID
2237: ,sysdate
2238: ,FND_GLOBAL.USER_ID
2239: ,sysdate
2240: ,FND_GLOBAL.USER_ID
2241: ,'D'
2242: ,'PA_TASKS'
2243: ,'PA_TASKS'
2244: ,l_suc_ver_id_tbl(i)

Line 2793: p_user_id => FND_GLOBAL.USER_ID

2789: EXIT when Create_Proj_Depend%NOTFOUND;
2790:
2791: l_object_relationship_id := NULL;
2792: PA_Object_Relationships_PKG.Insert_Row(
2793: p_user_id => FND_GLOBAL.USER_ID
2794: ,p_object_type_from => 'PA_TASKS'
2795: ,p_object_id_from1 => l_src_task_ver_id
2796: ,p_object_id_from2 => l_src_proj_id
2797: ,p_object_id_from3 => NULL

Line 2872: p_user_id => FND_GLOBAL.USER_ID

2868: End IF;
2869: */
2870: l_object_relationship_id := NULL;
2871: PA_Object_Relationships_PKG.Insert_Row(
2872: p_user_id => FND_GLOBAL.USER_ID
2873: ,p_object_type_from => 'PA_TASKS'
2874: ,p_object_id_from1 => l_obj_id_from1
2875: ,p_object_id_from2 => l_obj_id_from2
2876: ,p_object_id_from3 => NULL

Line 3165: last_updated_by = FND_GLOBAL.USER_ID,

3161: UPDATE PA_TASKS
3162: SET
3163: CHARGEABLE_FLAG = 'N',
3164: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3165: last_updated_by = FND_GLOBAL.USER_ID,
3166: last_update_login = FND_GLOBAL.USER_ID,
3167: last_update_date = sysdate
3168: WHERE TASK_ID = p_src_task_elem_id;
3169: END IF;

Line 3166: last_update_login = FND_GLOBAL.USER_ID,

3162: SET
3163: CHARGEABLE_FLAG = 'N',
3164: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3165: last_updated_by = FND_GLOBAL.USER_ID,
3166: last_update_login = FND_GLOBAL.USER_ID,
3167: last_update_date = sysdate
3168: WHERE TASK_ID = p_src_task_elem_id;
3169: END IF;
3170: ELSE

Line 3176: last_updated_by = FND_GLOBAL.USER_ID,

3172: UPDATE PA_TASKS
3173: SET
3174: CHARGEABLE_FLAG = 'N',
3175: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3176: last_updated_by = FND_GLOBAL.USER_ID,
3177: last_update_login = FND_GLOBAL.USER_ID,
3178: last_update_date = sysdate
3179: WHERE TASK_ID = p_src_task_elem_id;
3180: END IF;

Line 3177: last_update_login = FND_GLOBAL.USER_ID,

3173: SET
3174: CHARGEABLE_FLAG = 'N',
3175: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3176: last_updated_by = FND_GLOBAL.USER_ID,
3177: last_update_login = FND_GLOBAL.USER_ID,
3178: last_update_date = sysdate
3179: WHERE TASK_ID = p_src_task_elem_id;
3180: END IF;
3181: ELSE --not share, check if financial only

Line 3188: last_updated_by = FND_GLOBAL.USER_ID,

3184: UPDATE PA_TASKS
3185: SET
3186: CHARGEABLE_FLAG = 'N',
3187: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3188: last_updated_by = FND_GLOBAL.USER_ID,
3189: last_update_login = FND_GLOBAL.USER_ID,
3190: last_update_date = sysdate
3191: WHERE TASK_ID = p_src_task_elem_id;
3192: END IF;

Line 3189: last_update_login = FND_GLOBAL.USER_ID,

3185: SET
3186: CHARGEABLE_FLAG = 'N',
3187: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3188: last_updated_by = FND_GLOBAL.USER_ID,
3189: last_update_login = FND_GLOBAL.USER_ID,
3190: last_update_date = sysdate
3191: WHERE TASK_ID = p_src_task_elem_id;
3192: END IF;
3193: END IF;

Line 3244: p_user_id => FND_GLOBAL.USER_ID

3240: --
3241: /* This API call create relationship between linking task and destination structure vesion */
3242: /* in the pa_object_relationships table */
3243: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3244: p_user_id => FND_GLOBAL.USER_ID
3245: ,p_object_type_from => 'PA_TASKS'
3246: ,p_object_id_from1 => x_lnk_task_elem_ver_id
3247: ,p_object_id_from2 => p_src_proj_id
3248: ,p_object_id_from3 => NULL

Line 4981: p_user_id => FND_GLOBAL.USER_ID

4977: CLOSE get_new_pub_lnk_task_ver_id;
4978:
4979: IF (l_new_pub_lnk_task_ver_id IS NOT NULL) THEN
4980: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4981: p_user_id => FND_GLOBAL.USER_ID
4982: ,p_object_type_from => 'PA_TASKS'
4983: ,p_object_id_from1 => l_new_pub_lnk_task_ver_id
4984: ,p_object_id_from2 => get_going_out_lnk_info_rec.object_id_from2
4985: ,p_object_id_from3 => NULL

Line 5232: p_user_id => FND_GLOBAL.USER_ID

5228: --For Task
5229: IF l_move_link_fl='Y' THEN
5230: x_object_relationship_id := NULL;
5231: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
5232: p_user_id => FND_GLOBAL.USER_ID
5233: ,p_object_type_from => 'PA_TASKS'
5234: ,p_object_id_from1 => get_coming_in_lnk_info_rec.object_id_from1
5235: ,p_object_id_from2 => get_coming_in_lnk_info_rec.object_id_from2
5236: ,p_object_id_from3 => NULL