DBA Data[Home] [Help]

APPS.HXC_RDB_PROCESS dependencies on FND_DATE

Line 42: ,argument2 => FND_DATE.DATE_TO_CANONICAL(TRUNC(SYSDATE))

38: ,program => 'PYTSHPRI'
39: ,description => NULL
40: ,sub_request => FALSE
41: ,argument1 => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
42: ,argument2 => FND_DATE.DATE_TO_CANONICAL(TRUNC(SYSDATE))
43: ,argument3 => FND_DATE.DATE_TO_CANONICAL(
44: TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
45: )
46: ,argument4 => FND_DATE.DATE_TO_CANONICAL(

Line 43: ,argument3 => FND_DATE.DATE_TO_CANONICAL(

39: ,description => NULL
40: ,sub_request => FALSE
41: ,argument1 => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
42: ,argument2 => FND_DATE.DATE_TO_CANONICAL(TRUNC(SYSDATE))
43: ,argument3 => FND_DATE.DATE_TO_CANONICAL(
44: TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
45: )
46: ,argument4 => FND_DATE.DATE_TO_CANONICAL(
47: TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

Line 46: ,argument4 => FND_DATE.DATE_TO_CANONICAL(

42: ,argument2 => FND_DATE.DATE_TO_CANONICAL(TRUNC(SYSDATE))
43: ,argument3 => FND_DATE.DATE_TO_CANONICAL(
44: TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
45: )
46: ,argument4 => FND_DATE.DATE_TO_CANONICAL(
47: TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
48: )
49: ,argument5 => NULL
50: ,argument6 => NULL

Line 64: ,argument20 => FND_DATE.DATE_TO_CANONICAL(NVL(TO_DATE(p_changes_since,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),

60: ,argument16 => p_new_batch_ref
61: ,argument17 => NULL
62: ,argument18 => p_bee_status
63: ,argument19 => NULL
64: ,argument20 => FND_DATE.DATE_TO_CANONICAL(NVL(TO_DATE(p_changes_since,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
65: SYSDATE- fnd_profile.value('HXC_RETRIEVAL_CHANGES_DATE')
66: )
67: )
68: );