eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_AA_HISTORY_PKG dependencies on STANDARD

Line 31: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.insert_p' );

27: PROCEDURE insert_p( p_aah_rec IN ar_approval_action_history%ROWTYPE,
28: p_aah_id OUT NOCOPY ar_approval_action_history.approval_action_history_id%TYPE) IS
29: l_aah_id ar_approval_action_history.approval_action_history_id%TYPE;
30: BEGIN
31: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.insert_p' );
32: --
33: SELECT ar_approval_action_history_s.nextval
34: INTO l_aah_id
35: FROM dual;

Line 67: arp_standard.profile.user_id,

63: attribute14,
64: attribute15
65: )
66: VALUES ( l_aah_id,
67: arp_standard.profile.user_id,
68: SYSDATE,
69: arp_standard.profile.user_id,
70: SYSDATE,
71: NVL( arp_standard.profile.last_update_login,

Line 69: arp_standard.profile.user_id,

65: )
66: VALUES ( l_aah_id,
67: arp_standard.profile.user_id,
68: SYSDATE,
69: arp_standard.profile.user_id,
70: SYSDATE,
71: NVL( arp_standard.profile.last_update_login,
72: p_aah_rec.last_update_login ),
73: p_aah_rec.action_name,

Line 71: NVL( arp_standard.profile.last_update_login,

67: arp_standard.profile.user_id,
68: SYSDATE,
69: arp_standard.profile.user_id,
70: SYSDATE,
71: NVL( arp_standard.profile.last_update_login,
72: p_aah_rec.last_update_login ),
73: p_aah_rec.action_name,
74: p_aah_rec.adjustment_id,
75: p_aah_rec.action_date,

Line 96: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.insert_p' );

92: p_aah_rec.attribute15
93: );
94: p_aah_id := l_aah_id;
95: --
96: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.insert_p' );
97: EXCEPTION
98: WHEN OTHERS THEN
99: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.insert_p' );
100: RAISE;

Line 99: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.insert_p' );

95: --
96: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.insert_p' );
97: EXCEPTION
98: WHEN OTHERS THEN
99: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.insert_p' );
100: RAISE;
101: END;
102: --
103: /*===========================================================================+

Line 126: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.update_p' );

122: | |
123: +===========================================================================*/
124: PROCEDURE update_p( p_aah_rec IN ar_approval_action_history%ROWTYPE ) IS
125: BEGIN
126: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.update_p' );
127: --
128: UPDATE ar_approval_action_history SET
129: approval_action_history_id =
130: p_aah_rec.approval_action_history_id,

Line 131: last_updated_by = arp_standard.profile.user_id,

127: --
128: UPDATE ar_approval_action_history SET
129: approval_action_history_id =
130: p_aah_rec.approval_action_history_id,
131: last_updated_by = arp_standard.profile.user_id,
132: last_update_date = SYSDATE,
133: last_update_login =
134: NVL( arp_standard.profile.last_update_login,
135: p_aah_rec.last_update_login ),

Line 134: NVL( arp_standard.profile.last_update_login,

130: p_aah_rec.approval_action_history_id,
131: last_updated_by = arp_standard.profile.user_id,
132: last_update_date = SYSDATE,
133: last_update_login =
134: NVL( arp_standard.profile.last_update_login,
135: p_aah_rec.last_update_login ),
136: action_name = p_aah_rec.action_name,
137: adjustment_id = p_aah_rec.adjustment_id,
138: action_date = p_aah_rec.action_date,

Line 158: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.update_p' );

154: attribute14 = p_aah_rec.attribute14,
155: attribute15 = p_aah_rec.attribute15
156: WHERE approval_action_history_id = p_aah_rec.approval_action_history_id;
157: --
158: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.update_p' );
159: EXCEPTION
160: WHEN OTHERS THEN
161: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.update_p' );
162: RAISE;

Line 161: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.update_p' );

157: --
158: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.update_p' );
159: EXCEPTION
160: WHEN OTHERS THEN
161: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.update_p' );
162: RAISE;
163: END;
164: --
165: /*===========================================================================+

Line 189: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.delete_p' );

185: +===========================================================================*/
186: PROCEDURE delete_p(
187: p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE ) IS
188: BEGIN
189: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.delete_p' );
190: DELETE FROM ar_approval_action_history
191: WHERE approval_action_history_id = p_aah_id;
192: --
193: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.delete_p' );

Line 193: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.delete_p' );

189: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.delete_p' );
190: DELETE FROM ar_approval_action_history
191: WHERE approval_action_history_id = p_aah_id;
192: --
193: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.delete_p' );
194: EXCEPTION
195: WHEN OTHERS THEN
196: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.delete_p' );
197: RAISE;

Line 196: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.delete_p' );

192: --
193: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.delete_p' );
194: EXCEPTION
195: WHEN OTHERS THEN
196: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.delete_p' );
197: RAISE;
198: END;
199: --
200: /*===========================================================================+

Line 227: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.fetch_p' );

223: PROCEDURE fetch_p(
224: p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE,
225: p_aah_rec OUT NOCOPY ar_approval_action_history%ROWTYPE ) IS
226: BEGIN
227: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.fetch_p' );
228: SELECT *
229: INTO p_aah_rec
230: FROM ar_approval_action_history
231: WHERE approval_action_history_id = p_aah_id;

Line 232: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.fetch_p' );

228: SELECT *
229: INTO p_aah_rec
230: FROM ar_approval_action_history
231: WHERE approval_action_history_id = p_aah_id;
232: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.fetch_p' );
233: --
234: EXCEPTION
235: WHEN OTHERS THEN
236: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.fetch_p' );

Line 236: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.fetch_p' );

232: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.fetch_p' );
233: --
234: EXCEPTION
235: WHEN OTHERS THEN
236: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.fetch_p' );
237: RAISE;
238: END;
239: --
240: /*===========================================================================+

Line 268: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.lock_p' );

264: PROCEDURE lock_p(
265: p_aah_id IN ar_approval_action_history.approval_action_history_id%TYPE ) IS
266: l_aah_id ar_approval_action_history.approval_action_history_id%TYPE;
267: BEGIN
268: arp_standard.debug( '>>>>>>>> arp_aa_history_pkg.lock_p' );
269: SELECT approval_action_history_id
270: INTO l_aah_id
271: FROM ar_approval_action_history
272: WHERE approval_action_history_id = p_aah_id

Line 275: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.lock_p' );

271: FROM ar_approval_action_history
272: WHERE approval_action_history_id = p_aah_id
273: FOR UPDATE OF ACTION_NAME NOWAIT;
274: --
275: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.lock_p' );
276: EXCEPTION
277: WHEN OTHERS THEN
278: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.lock_p' );
279: RAISE;

Line 278: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.lock_p' );

274: --
275: arp_standard.debug( '<<<<<<<< arp_aa_history_pkg.lock_p' );
276: EXCEPTION
277: WHEN OTHERS THEN
278: arp_standard.debug( 'EXCEPTION: arp_aa_history_pkg.lock_p' );
279: RAISE;
280: END;
281:
282: END ARP_AA_HISTORY_PKG;