[Home] [Help]
1179: ,p_lock_flag => g_lock_flag_value
1180: ,p_wd_restricted => g_wd_restricted_flag_value
1181: ,p_start_date => l_start_date
1182: ,p_end_date => l_end_date
1183: ,p_attach_file_id => p_attach_file_id -- This procedure picks up the file name from FND_LOBS.
1184: ,p_attribute_type_codes => l_attribute_type_codes
1185: ,p_attributes => l_attributes
1186: ,p_component_citems => NULL
1187: ,p_component_atypes => NULL
1582: ,p_lock_flag => g_lock_flag_value
1583: ,p_wd_restricted => g_wd_restricted_flag_value
1584: ,p_start_date => l_start_date
1585: ,p_end_date => l_end_date
1586: ,p_attach_file_id => NULL -- This procedure picks up the file name from FND_LOBS.
1587: ,p_attribute_type_codes => p_attr_types
1588: ,p_attributes => p_attr_values
1589: ,p_component_citems => NULL
1590: ,p_component_atypes => NULL
4150: ,p_lock_flag => g_lock_flag_value
4151: ,p_wd_restricted => g_wd_restricted_flag_value
4152: ,p_start_date => sysdate
4153: ,p_end_date => null
4154: ,p_attach_file_id => p_attach_file_id -- This procedure picks up the file name from FND_LOBS.
4155: ,p_attribute_type_codes => l_attribute_type_codes
4156: ,p_attributes => l_attributes
4157: ,p_component_citems => NULL
4158: ,p_component_atypes => NULL
5625: -- test cursor for file id.
5626:
5627: CURSOR c_fild_id_check IS
5628: SELECT file_id, file_name
5629: FROM fnd_lobs
5630: WHERE file_id = p_attach_file_id ;
5631:
5632: l_test_file_id NUMBER ;
5633: l_test_file_name VARCHAR2(250) ;
6170:
6171: x_return_status := FND_API.G_RET_STS_SUCCESS;
6172:
6173: select file_data into l_blob
6174: from fnd_lobs
6175: where file_id = p_file_id
6176: for update;
6177:
6178: l_length := dbms_lob.getlength(l_blob);