313: )
314: IS
315:
316: l_step NUMBER;
317: l_status hz_party_site_uses.status%TYPE;
318: l_rfq_obj_no hz_party_site_uses.object_version_number%TYPE;
319: l_pay_obj_no hz_party_site_uses.object_version_number%TYPE;
320: l_pur_obj_no hz_party_site_uses.object_version_number%TYPE;
321:
314: IS
315:
316: l_step NUMBER;
317: l_status hz_party_site_uses.status%TYPE;
318: l_rfq_obj_no hz_party_site_uses.object_version_number%TYPE;
319: l_pay_obj_no hz_party_site_uses.object_version_number%TYPE;
320: l_pur_obj_no hz_party_site_uses.object_version_number%TYPE;
321:
322: l_rfq_status hz_party_site_uses.status%TYPE;
315:
316: l_step NUMBER;
317: l_status hz_party_site_uses.status%TYPE;
318: l_rfq_obj_no hz_party_site_uses.object_version_number%TYPE;
319: l_pay_obj_no hz_party_site_uses.object_version_number%TYPE;
320: l_pur_obj_no hz_party_site_uses.object_version_number%TYPE;
321:
322: l_rfq_status hz_party_site_uses.status%TYPE;
323: l_pur_status hz_party_site_uses.status%TYPE;
316: l_step NUMBER;
317: l_status hz_party_site_uses.status%TYPE;
318: l_rfq_obj_no hz_party_site_uses.object_version_number%TYPE;
319: l_pay_obj_no hz_party_site_uses.object_version_number%TYPE;
320: l_pur_obj_no hz_party_site_uses.object_version_number%TYPE;
321:
322: l_rfq_status hz_party_site_uses.status%TYPE;
323: l_pur_status hz_party_site_uses.status%TYPE;
324: l_pay_status hz_party_site_uses.status%TYPE;
318: l_rfq_obj_no hz_party_site_uses.object_version_number%TYPE;
319: l_pay_obj_no hz_party_site_uses.object_version_number%TYPE;
320: l_pur_obj_no hz_party_site_uses.object_version_number%TYPE;
321:
322: l_rfq_status hz_party_site_uses.status%TYPE;
323: l_pur_status hz_party_site_uses.status%TYPE;
324: l_pay_status hz_party_site_uses.status%TYPE;
325:
326: l_rfq_use_id hz_party_site_uses.party_site_use_id%TYPE;
319: l_pay_obj_no hz_party_site_uses.object_version_number%TYPE;
320: l_pur_obj_no hz_party_site_uses.object_version_number%TYPE;
321:
322: l_rfq_status hz_party_site_uses.status%TYPE;
323: l_pur_status hz_party_site_uses.status%TYPE;
324: l_pay_status hz_party_site_uses.status%TYPE;
325:
326: l_rfq_use_id hz_party_site_uses.party_site_use_id%TYPE;
327: l_pur_use_id hz_party_site_uses.party_site_use_id%TYPE;
320: l_pur_obj_no hz_party_site_uses.object_version_number%TYPE;
321:
322: l_rfq_status hz_party_site_uses.status%TYPE;
323: l_pur_status hz_party_site_uses.status%TYPE;
324: l_pay_status hz_party_site_uses.status%TYPE;
325:
326: l_rfq_use_id hz_party_site_uses.party_site_use_id%TYPE;
327: l_pur_use_id hz_party_site_uses.party_site_use_id%TYPE;
328: l_pay_use_id hz_party_site_uses.party_site_use_id%TYPE;
322: l_rfq_status hz_party_site_uses.status%TYPE;
323: l_pur_status hz_party_site_uses.status%TYPE;
324: l_pay_status hz_party_site_uses.status%TYPE;
325:
326: l_rfq_use_id hz_party_site_uses.party_site_use_id%TYPE;
327: l_pur_use_id hz_party_site_uses.party_site_use_id%TYPE;
328: l_pay_use_id hz_party_site_uses.party_site_use_id%TYPE;
329:
330: l_party_site_name hz_party_sites.party_site_name%type;
323: l_pur_status hz_party_site_uses.status%TYPE;
324: l_pay_status hz_party_site_uses.status%TYPE;
325:
326: l_rfq_use_id hz_party_site_uses.party_site_use_id%TYPE;
327: l_pur_use_id hz_party_site_uses.party_site_use_id%TYPE;
328: l_pay_use_id hz_party_site_uses.party_site_use_id%TYPE;
329:
330: l_party_site_name hz_party_sites.party_site_name%type;
331: BEGIN
324: l_pay_status hz_party_site_uses.status%TYPE;
325:
326: l_rfq_use_id hz_party_site_uses.party_site_use_id%TYPE;
327: l_pur_use_id hz_party_site_uses.party_site_use_id%TYPE;
328: l_pay_use_id hz_party_site_uses.party_site_use_id%TYPE;
329:
330: l_party_site_name hz_party_sites.party_site_name%type;
331: BEGIN
332:
340: pay.object_version_number, pur.object_version_number, rfq.object_version_number,
341: pay.status, pur.status, rfq.status, hps.party_site_name
342: into l_pay_use_id, l_pur_use_id, l_rfq_use_id, l_pay_obj_no, l_pur_obj_no, l_rfq_obj_no,
343: l_pay_status, l_pur_status, l_rfq_status , l_party_site_name
344: from hz_party_sites hps ,hz_party_site_uses pay, hz_party_site_uses pur, hz_party_site_uses rfq
345: where hps.party_site_id = p_party_site_id
346: --and hps.created_by_module like 'POS%'
347: and pay.party_site_id(+) = hps.party_site_id
348: and pur.party_site_id(+) = hps.party_site_id