APPS.ICX_POR_ITEM_UPLOAD dependencies on ICX_POR_CONTRACT_REFERENCES

Line 4694: from icx_por_contract_references

4690: cursor c_contract_references is
4691: select request_id, line_number, buyer_id, buyer_name,
4692: contract_reference_id, contract_reference_num, supplier_id,
4693: supplier_site, pricelist_id, currency_code, error_message
4694: from icx_por_contract_references
4695: where request_id = p_request_id;
4696:
4697: l_progress varchar2(10) := '100';
4698: BEGIN

Line 4767: from icx_por_contract_references

4763: p_currency := null;
4764:
4765: select count(distinct supplier_id)
4766: into l_count
4767: from icx_por_contract_references
4768: where supplier_id is not null
4769: and request_id=p_request_id;
4770:
4771: l_progress := 120;

Line 4784: from icx_por_contract_references

4780: -- Are there multiple currencies ?
4781: -- Error out..
4782: select count(distinct currency_code)
4783: into l_count
4784: from icx_por_contract_references
4785: where currency_code is not null
4786: and request_id=p_request_id;
4787: l_progress := 140;
4788:

Line 4832: from po_vendors poV, icx_por_contract_references icxC

4828: -- Get the Globally used Supplier in the Contract
4829: -- Reference Section: Get for Valid contracts only
4830:
4831: select distinct vendor_name into p_supplier
4832: from po_vendors poV, icx_por_contract_references icxC
4833: where poV.vendor_id = icxC.supplier_id
4834: and icxC.request_id=p_request_id
4835: and icxC.supplier_id is not null;
4836:

Line 4843: from icx_por_contract_references icxC

4839: -- Get the Globally used Currency in the Contract
4840: -- Reference Section: Get for Valid contracts only
4841:
4842: select distinct currency_code into p_currency
4843: from icx_por_contract_references icxC
4844: where icxC.request_id=p_request_id
4845: and icxC.currency_code is not null;
4846:
4847: l_progress := 230;

Line 4873: from icx_por_contract_references

4869: p_failed_count := 0;
4870:
4871: -- Get the Number of successful Contract references
4872: select count(0) into p_succ_count
4873: from icx_por_contract_references
4874: where error_message is null
4875: and request_id = p_request_id;
4876:
4877: l_progress := '110';

Line 4881: from icx_por_contract_references

4877: l_progress := '110';
4878:
4879: -- Get the Number of Failed Contract references
4880: select count(0) into p_failed_count
4881: from icx_por_contract_references
4882: where error_message is not null
4883: and request_id = p_request_id;
4884:
4885: l_progress := '120';