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.POS_PROFILE_PKG dependencies on HZ_PARTY_SITE_USES

Line 317: l_status hz_party_site_uses.status%TYPE;

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:

Line 318: l_rfq_obj_no hz_party_site_uses.object_version_number%TYPE;

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;

Line 319: l_pay_obj_no hz_party_site_uses.object_version_number%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;

Line 320: l_pur_obj_no hz_party_site_uses.object_version_number%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;

Line 322: l_rfq_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;

Line 323: l_pur_status hz_party_site_uses.status%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;

Line 324: l_pay_status hz_party_site_uses.status%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;

Line 326: l_rfq_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;

Line 327: l_pur_use_id hz_party_site_uses.party_site_use_id%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

Line 328: l_pay_use_id hz_party_site_uses.party_site_use_id%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
332:

Line 344: from hz_party_sites hps ,hz_party_site_uses pay, hz_party_site_uses pur, hz_party_site_uses rfq

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