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 1253: p_user_id => FND_GLOBAL.USER_ID

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

Line 1358: p_user_id => FND_GLOBAL.USER_ID

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

Line 1544: ( p_user_id => FND_GLOBAL.USER_ID

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

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

2059: BEGIN
2060: Delete from PA_COPY_DEP_TEMP; --Bug#8842950
2061:
2062: --debug messages added while fixing bug 5067296
2063: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
2064:
2065: IF (l_debug_mode = 'Y') THEN
2066: 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);
2067: /* These two lines are causing bug 5076461 in publish flow.

Line 2244: ,FND_GLOBAL.USER_ID

2240: ,RECORD_VERSION_NUMBER
2241: )
2242: VALUES (
2243: pa_object_relationships_s.nextval
2244: ,FND_GLOBAL.USER_ID
2245: ,sysdate
2246: ,FND_GLOBAL.USER_ID
2247: ,sysdate
2248: ,FND_GLOBAL.USER_ID

Line 2246: ,FND_GLOBAL.USER_ID

2242: VALUES (
2243: pa_object_relationships_s.nextval
2244: ,FND_GLOBAL.USER_ID
2245: ,sysdate
2246: ,FND_GLOBAL.USER_ID
2247: ,sysdate
2248: ,FND_GLOBAL.USER_ID
2249: ,'D'
2250: ,'PA_TASKS'

Line 2248: ,FND_GLOBAL.USER_ID

2244: ,FND_GLOBAL.USER_ID
2245: ,sysdate
2246: ,FND_GLOBAL.USER_ID
2247: ,sysdate
2248: ,FND_GLOBAL.USER_ID
2249: ,'D'
2250: ,'PA_TASKS'
2251: ,'PA_TASKS'
2252: ,l_suc_ver_id_tbl(i)

Line 2805: p_user_id => FND_GLOBAL.USER_ID

2801: EXIT when Create_Proj_Depend%NOTFOUND;
2802:
2803: l_object_relationship_id := NULL;
2804: PA_Object_Relationships_PKG.Insert_Row(
2805: p_user_id => FND_GLOBAL.USER_ID
2806: ,p_object_type_from => 'PA_TASKS'
2807: ,p_object_id_from1 => l_src_task_ver_id
2808: ,p_object_id_from2 => l_src_proj_id
2809: ,p_object_id_from3 => NULL

Line 2884: p_user_id => FND_GLOBAL.USER_ID

2880: End IF;
2881: */
2882: l_object_relationship_id := NULL;
2883: PA_Object_Relationships_PKG.Insert_Row(
2884: p_user_id => FND_GLOBAL.USER_ID
2885: ,p_object_type_from => 'PA_TASKS'
2886: ,p_object_id_from1 => l_obj_id_from1
2887: ,p_object_id_from2 => l_obj_id_from2
2888: ,p_object_id_from3 => NULL

Line 3178: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 3179: last_update_login = FND_GLOBAL.USER_ID,

3175: SET
3176: CHARGEABLE_FLAG = 'N',
3177: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3178: last_updated_by = FND_GLOBAL.USER_ID,
3179: last_update_login = FND_GLOBAL.USER_ID,
3180: last_update_date = sysdate
3181: WHERE TASK_ID = p_src_task_elem_id;
3182: END IF;
3183: ELSE

Line 3189: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 3190: last_update_login = FND_GLOBAL.USER_ID,

3186: SET
3187: CHARGEABLE_FLAG = 'N',
3188: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3189: last_updated_by = FND_GLOBAL.USER_ID,
3190: last_update_login = FND_GLOBAL.USER_ID,
3191: last_update_date = sysdate
3192: WHERE TASK_ID = p_src_task_elem_id;
3193: END IF;
3194: ELSE --not share, check if financial only

Line 3201: last_updated_by = FND_GLOBAL.USER_ID,

3197: UPDATE PA_TASKS
3198: SET
3199: CHARGEABLE_FLAG = 'N',
3200: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3201: last_updated_by = FND_GLOBAL.USER_ID,
3202: last_update_login = FND_GLOBAL.USER_ID,
3203: last_update_date = sysdate
3204: WHERE TASK_ID = p_src_task_elem_id;
3205: END IF;

Line 3202: last_update_login = FND_GLOBAL.USER_ID,

3198: SET
3199: CHARGEABLE_FLAG = 'N',
3200: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
3201: last_updated_by = FND_GLOBAL.USER_ID,
3202: last_update_login = FND_GLOBAL.USER_ID,
3203: last_update_date = sysdate
3204: WHERE TASK_ID = p_src_task_elem_id;
3205: END IF;
3206: END IF;

Line 3257: p_user_id => FND_GLOBAL.USER_ID

3253: --
3254: /* This API call create relationship between linking task and destination structure vesion */
3255: /* in the pa_object_relationships table */
3256: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3257: p_user_id => FND_GLOBAL.USER_ID
3258: ,p_object_type_from => 'PA_TASKS'
3259: ,p_object_id_from1 => x_lnk_task_elem_ver_id
3260: ,p_object_id_from2 => p_src_proj_id
3261: ,p_object_id_from3 => NULL

Line 5003: p_user_id => FND_GLOBAL.USER_ID

4999: CLOSE get_new_pub_lnk_task_ver_id;
5000:
5001: IF (l_new_pub_lnk_task_ver_id IS NOT NULL) THEN
5002: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
5003: p_user_id => FND_GLOBAL.USER_ID
5004: ,p_object_type_from => 'PA_TASKS'
5005: ,p_object_id_from1 => l_new_pub_lnk_task_ver_id
5006: ,p_object_id_from2 => get_going_out_lnk_info_rec.object_id_from2
5007: ,p_object_id_from3 => NULL

Line 5254: p_user_id => FND_GLOBAL.USER_ID

5250: --For Task
5251: IF l_move_link_fl='Y' THEN
5252: x_object_relationship_id := NULL;
5253: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
5254: p_user_id => FND_GLOBAL.USER_ID
5255: ,p_object_type_from => 'PA_TASKS'
5256: ,p_object_id_from1 => get_coming_in_lnk_info_rec.object_id_from1
5257: ,p_object_id_from2 => get_coming_in_lnk_info_rec.object_id_from2
5258: ,p_object_id_from3 => NULL