APPS.PN_AM_WF dependencies on PN_LEASES_ALL

Line 20: p_lease_id IN pn_leases_all.lease_id%TYPE,

16: -- End of comments
17: PROCEDURE raise_business_event (
18: p_transaction_id IN NUMBER,
19: p_event_name IN VARCHAR2,
20: p_lease_id IN pn_leases_all.lease_id%TYPE,
21: p_old_lease_status IN pn_leases_all.lease_status%TYPE,
22: p_new_lease_status IN pn_leases_all.lease_status%TYPE
23: )
24: IS

Line 21: p_old_lease_status IN pn_leases_all.lease_status%TYPE,

17: PROCEDURE raise_business_event (
18: p_transaction_id IN NUMBER,
19: p_event_name IN VARCHAR2,
20: p_lease_id IN pn_leases_all.lease_id%TYPE,
21: p_old_lease_status IN pn_leases_all.lease_status%TYPE,
22: p_new_lease_status IN pn_leases_all.lease_status%TYPE
23: )
24: IS
25: l_parameter_list wf_parameter_list_t;

Line 22: p_new_lease_status IN pn_leases_all.lease_status%TYPE

18: p_transaction_id IN NUMBER,
19: p_event_name IN VARCHAR2,
20: p_lease_id IN pn_leases_all.lease_id%TYPE,
21: p_old_lease_status IN pn_leases_all.lease_status%TYPE,
22: p_new_lease_status IN pn_leases_all.lease_status%TYPE
23: )
24: IS
25: l_parameter_list wf_parameter_list_t;
26: l_event_key VARCHAR2 (240);

Line 293: FROM pn_leases_all pla, pn_lease_details_all plda

289: wf_debug ('TRANSACTION_ID' || l_transaction_id);
290:
291: SELECT plda.lease_commencement_date, pla.lease_status
292: INTO l_commencement_date, l_lease_status
293: FROM pn_leases_all pla, pn_lease_details_all plda
294: WHERE pla.lease_id = plda.lease_id
295: AND pla.lease_id = l_transaction_id
296: AND pla.org_id = plda.org_id;
297:

Line 300: UPDATE pn_leases_all

296: AND pla.org_id = plda.org_id;
297:
298: IF l_result = 'APPROVED'
299: THEN
300: UPDATE pn_leases_all
301: SET status = 'F'
302: WHERE lease_id = l_transaction_id;
303:
304: l_requestid :=

Line 326: UPDATE pn_leases_all

322:
323: wf_debug ('Value of request_id' || l_requestid);
324: ELSIF l_result = 'REJECT'
325: THEN
326: UPDATE pn_leases_all
327: SET status = 'D'
328: WHERE lease_id = l_transaction_id;
329: END IF;
330:

Line 424: FROM pn_leases_all pla, pn_lease_details_all plda, fnd_user f

420: SELECT f.user_name, pla.lease_num, plda.lease_commencement_date,
421: plda.lease_termination_date
422: INTO l_requester, l_lease_number, l_commencement_date,
423: l_termination_date
424: FROM pn_leases_all pla, pn_lease_details_all plda, fnd_user f
425: WHERE pla.lease_id = plda.lease_id
426: AND pla.lease_id = p_lease_id
427: AND pla.last_updated_by = f.user_id
428: AND pla.org_id = plda.org_id;