DBA Data[Home] [Help]

APPS.PQH_DOC_BUS dependencies on HR_API

Line 49: hr_api.mandatory_arg_error

45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Ensure that all the mandatory parameter are not null
48: --
49: hr_api.mandatory_arg_error
50: (p_api_name => l_proc
51: ,p_argument => 'document_id'
52: ,p_argument_value => p_document_id
53: );

Line 75: hr_api.set_security_group_id

71: close csr_sec_grp;
72: --
73: -- Set the security_group_id in CLIENT_INFO
74: --
75: hr_api.set_security_group_id
76: (p_security_group_id => l_security_group_id
77: );
78: end if;
79: --

Line 117: hr_api.mandatory_arg_error

113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'document_id'
120: ,p_argument_value => p_document_id
121: );

Line 123: if ( nvl(pqh_doc_bus.g_document_id, hr_api.g_number)

119: ,p_argument => 'document_id'
120: ,p_argument_value => p_document_id
121: );
122: --
123: if ( nvl(pqh_doc_bus.g_document_id, hr_api.g_number)
124: = p_document_id) then
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global

Line 257: hr_api.mandatory_arg_error

253: Begin
254: --
255: -- Ensure that the p_datetrack_mode argument is not null
256: --
257: hr_api.mandatory_arg_error
258: (p_api_name => l_proc
259: ,p_argument => 'datetrack_mode'
260: ,p_argument_value => p_datetrack_mode
261: );

Line 267: hr_api.mandatory_arg_error

263: -- Mode will be valid, as this is checked at the start of the upd.
264: --
265: -- Ensure the arguments are not null
266: --
267: hr_api.mandatory_arg_error
268: (p_api_name => l_proc
269: ,p_argument => 'validation_start_date'
270: ,p_argument_value => p_validation_start_date
271: );

Line 273: hr_api.mandatory_arg_error

269: ,p_argument => 'validation_start_date'
270: ,p_argument_value => p_validation_start_date
271: );
272: --
273: hr_api.mandatory_arg_error
274: (p_api_name => l_proc
275: ,p_argument => 'validation_end_date'
276: ,p_argument_value => p_validation_end_date
277: );

Line 341: hr_api.mandatory_arg_error

337: Begin
338: --
339: -- Ensure that the p_datetrack_mode argument is not null
340: --
341: hr_api.mandatory_arg_error
342: (p_api_name => l_proc
343: ,p_argument => 'datetrack_mode'
344: ,p_argument_value => p_datetrack_mode
345: );

Line 350: If (p_datetrack_mode = hr_api.g_delete or

346: --
347: -- Only perform the validation if the datetrack mode is either
348: -- DELETE or ZAP
349: --
350: If (p_datetrack_mode = hr_api.g_delete or
351: p_datetrack_mode = hr_api.g_zap) then
352: --
353: --
354: -- Ensure the arguments are not null

Line 351: p_datetrack_mode = hr_api.g_zap) then

347: -- Only perform the validation if the datetrack mode is either
348: -- DELETE or ZAP
349: --
350: If (p_datetrack_mode = hr_api.g_delete or
351: p_datetrack_mode = hr_api.g_zap) then
352: --
353: --
354: -- Ensure the arguments are not null
355: --

Line 356: hr_api.mandatory_arg_error

352: --
353: --
354: -- Ensure the arguments are not null
355: --
356: hr_api.mandatory_arg_error
357: (p_api_name => l_proc
358: ,p_argument => 'validation_start_date'
359: ,p_argument_value => p_validation_start_date
360: );

Line 362: hr_api.mandatory_arg_error

358: ,p_argument => 'validation_start_date'
359: ,p_argument_value => p_validation_start_date
360: );
361: --
362: hr_api.mandatory_arg_error
363: (p_api_name => l_proc
364: ,p_argument => 'validation_end_date'
365: ,p_argument_value => p_validation_end_date
366: );

Line 368: hr_api.mandatory_arg_error

364: ,p_argument => 'validation_end_date'
365: ,p_argument_value => p_validation_end_date
366: );
367: --
368: hr_api.mandatory_arg_error
369: (p_api_name => l_proc
370: ,p_argument => 'document_id'
371: ,p_argument_value => p_document_id
372: );

Line 374: If (p_datetrack_mode <> hr_api.g_future_change) then

370: ,p_argument => 'document_id'
371: ,p_argument_value => p_document_id
372: );
373: --
374: If (p_datetrack_mode <> hr_api.g_future_change) then
375: If (dt_api.rows_exist
376: (p_base_table_name => 'pqh_document_attributes_f'
377: ,p_base_key_column => 'document_id'
378: ,p_base_key_value => p_document_id