413: p_CITY => l_city_name,
414: p_REGION => l_region_name,
415: p_COUNTRY_CODE => l_country_code,
416: p_CREATION_DATE => SYSDATE,
417: p_CREATED_BY => FND_GLOBAL.USER_ID,
418: p_LAST_UPDATE_DATE => SYSDATE,
419: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
420: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
421: X_ROWID => x_rowid,
415: p_COUNTRY_CODE => l_country_code,
416: p_CREATION_DATE => SYSDATE,
417: p_CREATED_BY => FND_GLOBAL.USER_ID,
418: p_LAST_UPDATE_DATE => SYSDATE,
419: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
420: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
421: X_ROWID => x_rowid,
422: X_LOCATION_ID => l_location_id);
423:
416: p_CREATION_DATE => SYSDATE,
417: p_CREATED_BY => FND_GLOBAL.USER_ID,
418: p_LAST_UPDATE_DATE => SYSDATE,
419: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
420: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
421: X_ROWID => x_rowid,
422: X_LOCATION_ID => l_location_id);
423:
424: end if;
502: , NULL -- X_task_manager_person_id
503: , NULL -- X_service_type
504: , NULL -- X_task_start_date
505: , NULL -- X_task_end_date
506: , FND_GLOBAL.USER_ID -- X_entered_by_user_id
507: , null -- X_attribute_category
508: , null -- X_attribute1
509: , null -- X_attribute2
510: , null -- X_attribute3
593: ,X_Project_Id => l_template_id
594: ,X_Name => p_project_name
595: ,X_Segment1 => p_project_number
596: ,X_Last_Update_Date => SYSDATE
597: ,X_Last_Updated_By => FND_GLOBAL.USER_ID
598: ,X_Creation_Date => SYSDATE
599: ,X_Created_By => FND_GLOBAL.USER_ID
600: ,X_Last_Update_Login => FND_GLOBAL.LOGIN_ID
601: ,X_Project_Type => p_project_type
595: ,X_Segment1 => p_project_number
596: ,X_Last_Update_Date => SYSDATE
597: ,X_Last_Updated_By => FND_GLOBAL.USER_ID
598: ,X_Creation_Date => SYSDATE
599: ,X_Created_By => FND_GLOBAL.USER_ID
600: ,X_Last_Update_Login => FND_GLOBAL.LOGIN_ID
601: ,X_Project_Type => p_project_type
602: ,X_Carrying_Out_Organization_Id => p_organization_id
603: ,X_Public_Sector_Flag => NVL( l_public_sector_flag, 'N' )
596: ,X_Last_Update_Date => SYSDATE
597: ,X_Last_Updated_By => FND_GLOBAL.USER_ID
598: ,X_Creation_Date => SYSDATE
599: ,X_Created_By => FND_GLOBAL.USER_ID
600: ,X_Last_Update_Login => FND_GLOBAL.LOGIN_ID
601: ,X_Project_Type => p_project_type
602: ,X_Carrying_Out_Organization_Id => p_organization_id
603: ,X_Public_Sector_Flag => NVL( l_public_sector_flag, 'N' )
604: ,X_Project_Status_Code => l_Status_code
940: X_task_id => l_task_id,
941: X_Project_id => l_template_id,
942: X_Task_Number => '1',
943: X_Creation_Date => sysdate,
944: X_Created_By => FND_GLOBAL.USER_ID,
945: X_Last_Update_Date => sysdate,
946: X_last_Updated_By => FND_GLOBAL.USER_ID,
947: X_Last_Update_login => FND_GLOBAL.LOGIN_ID,
948: X_Task_Name => 'Task 1',
942: X_Task_Number => '1',
943: X_Creation_Date => sysdate,
944: X_Created_By => FND_GLOBAL.USER_ID,
945: X_Last_Update_Date => sysdate,
946: X_last_Updated_By => FND_GLOBAL.USER_ID,
947: X_Last_Update_login => FND_GLOBAL.LOGIN_ID,
948: X_Task_Name => 'Task 1',
949: X_Long_Task_Name => 'Task 1',
950: X_Top_Task_Id => null,
943: X_Creation_Date => sysdate,
944: X_Created_By => FND_GLOBAL.USER_ID,
945: X_Last_Update_Date => sysdate,
946: X_last_Updated_By => FND_GLOBAL.USER_ID,
947: X_Last_Update_login => FND_GLOBAL.LOGIN_ID,
948: X_Task_Name => 'Task 1',
949: X_Long_Task_Name => 'Task 1',
950: X_Top_Task_Id => null,
951: X_Wbs_level => 1,
1733: p_CITY => l_city_name,
1734: p_REGION => l_region_name,
1735: p_COUNTRY_CODE => l_country_code,
1736: p_CREATION_DATE => SYSDATE,
1737: p_CREATED_BY => FND_GLOBAL.USER_ID,
1738: p_LAST_UPDATE_DATE => SYSDATE,
1739: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1740: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1741: X_ROWID => x_rowid,
1735: p_COUNTRY_CODE => l_country_code,
1736: p_CREATION_DATE => SYSDATE,
1737: p_CREATED_BY => FND_GLOBAL.USER_ID,
1738: p_LAST_UPDATE_DATE => SYSDATE,
1739: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1740: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1741: X_ROWID => x_rowid,
1742: X_LOCATION_ID => l_location_id);
1743:
1736: p_CREATION_DATE => SYSDATE,
1737: p_CREATED_BY => FND_GLOBAL.USER_ID,
1738: p_LAST_UPDATE_DATE => SYSDATE,
1739: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1740: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1741: X_ROWID => x_rowid,
1742: X_LOCATION_ID => l_location_id);
1743:
1744: end if;
1767: , NULL -- X_task_manager_person_id
1768: , NULL -- X_service_type
1769: , NULL -- X_task_start_date
1770: , NULL -- X_task_end_date
1771: , FND_GLOBAL.USER_ID -- X_entered_by_user_id
1772: , null -- X_attribute_category
1773: , null -- X_attribute1
1774: , null -- X_attribute2
1775: , null -- X_attribute3
2326: )
2327: VALUES ( p_project_id,
2328: p_option_code,
2329: SYSDATE,
2330: FND_GLOBAL.USER_ID,
2331: SYSDATE,
2332: FND_GLOBAL.USER_ID,
2333: FND_GLOBAL.LOGIN_ID ,
2334: 1
2328: p_option_code,
2329: SYSDATE,
2330: FND_GLOBAL.USER_ID,
2331: SYSDATE,
2332: FND_GLOBAL.USER_ID,
2333: FND_GLOBAL.LOGIN_ID ,
2334: 1
2335: );
2336: END IF;
2329: SYSDATE,
2330: FND_GLOBAL.USER_ID,
2331: SYSDATE,
2332: FND_GLOBAL.USER_ID,
2333: FND_GLOBAL.LOGIN_ID ,
2334: 1
2335: );
2336: END IF;
2337: CLOSE cur_chk_options;
2780: VALUES ( p_project_id ,
2781: p_field_name ,
2782: p_prompt ,
2783: SYSDATE ,
2784: FND_GLOBAL.USER_ID ,
2785: SYSDATE ,
2786: FND_GLOBAL.USER_ID ,
2787: FND_GLOBAL.LOGIN_ID ,
2788: p_limiting_value ,
2782: p_prompt ,
2783: SYSDATE ,
2784: FND_GLOBAL.USER_ID ,
2785: SYSDATE ,
2786: FND_GLOBAL.USER_ID ,
2787: FND_GLOBAL.LOGIN_ID ,
2788: p_limiting_value ,
2789: p_sort_order ,
2790: p_required_flag ,
2783: SYSDATE ,
2784: FND_GLOBAL.USER_ID ,
2785: SYSDATE ,
2786: FND_GLOBAL.USER_ID ,
2787: FND_GLOBAL.LOGIN_ID ,
2788: p_limiting_value ,
2789: p_sort_order ,
2790: p_required_flag ,
2791: 1
3058: UPDATE pa_project_copy_overrides
3059: SET FIELD_NAME = p_field_name ,
3060: DISPLAY_NAME = p_prompt ,
3061: LAST_UPDATE_DATE = SYSDATE ,
3062: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
3063: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID ,
3064: LIMITING_VALUE = p_limiting_value ,
3065: SORT_ORDER = p_sort_order ,
3066: MANDATORY_FLAG = p_required_flag ,
3059: SET FIELD_NAME = p_field_name ,
3060: DISPLAY_NAME = p_prompt ,
3061: LAST_UPDATE_DATE = SYSDATE ,
3062: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
3063: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID ,
3064: LIMITING_VALUE = p_limiting_value ,
3065: SORT_ORDER = p_sort_order ,
3066: MANDATORY_FLAG = p_required_flag ,
3067: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 1 ) + 1
3282: )
3283: VALUES ( p_project_id,
3284: l_option_code,
3285: SYSDATE,
3286: FND_GLOBAL.USER_ID,
3287: SYSDATE,
3288: FND_GLOBAL.USER_ID,
3289: FND_GLOBAL.LOGIN_ID ,
3290: 1
3284: l_option_code,
3285: SYSDATE,
3286: FND_GLOBAL.USER_ID,
3287: SYSDATE,
3288: FND_GLOBAL.USER_ID,
3289: FND_GLOBAL.LOGIN_ID ,
3290: 1
3291: );
3292: END IF;
3285: SYSDATE,
3286: FND_GLOBAL.USER_ID,
3287: SYSDATE,
3288: FND_GLOBAL.USER_ID,
3289: FND_GLOBAL.LOGIN_ID ,
3290: 1
3291: );
3292: END IF;
3293: CLOSE cur_chk_options;