DBA Data[Home] [Help]

APPS.HXC_RDB_PROCESS dependencies on FND_PROFILE

Line 41: ,argument1 => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

37: FND_REQUEST.SUBMIT_REQUEST(application => 'PER'
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: )

Line 44: TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

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'))
48: )

Line 47: TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))

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
51: ,argument7 => p_gre_id

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: );

Line 65: SYSDATE- fnd_profile.value('HXC_RETRIEVAL_CHANGES_DATE')

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: );
69:

Line 106: FND_REQUEST.SET_ORG_ID(FND_PROFILE.VALUE('ORG_ID'));

102: END IF;
103:
104: IF p_application = 'PA'
105: THEN
106: FND_REQUEST.SET_ORG_ID(FND_PROFILE.VALUE('ORG_ID'));
107: l_request_id :=
108: FND_REQUEST.SUBMIT_REQUEST(application => 'PA'
109: ,program => 'PAXTRTRX'
110: ,description => NULL