DBA Data[Home] [Help]

APPS.BEN_CWB_CHANGE_ACCESS dependencies on BEN_TRANSACTION

Line 74: insert into ben_transaction ( transaction_id,

70: /* If comments is <> null update the transaction and send the notification */
71: if( p_comments is not null) then
72:
73: /* Update the transaction table with the contents of notification */
74: insert into ben_transaction ( transaction_id,
75: transaction_type,
76: attribute1, -- from_person_id,
77: attribute2, -- to_person_id,
78: attribute3, -- to_per_in_ler_id,

Line 89: values ( ben_transaction_s.nextval,

85: attribute10, -- old_access_cd
86: attribute11, -- requestor first name
87: attribute12 -- requestor last name
88: )
89: values ( ben_transaction_s.nextval,
90: 'CWBNTF',
91: p_from_person_id,
92: p_rcvr_person_id,
93: p_group_per_in_ler_id,

Line 119: /* NEED TO SAVE DATA IN BEN_TRANSACTIONS AND CALL NTF api */

115: if g_debug then
116: hr_utility.set_location(l_proc, 8);
117: end if;
118: --
119: /* NEED TO SAVE DATA IN BEN_TRANSACTIONS AND CALL NTF api */
120: -- Populating the OUT parameters.
121: --
122: p_object_version_number := l_object_version_number;
123: --