APPS.PON_NEGOTIATION_COPY_GRP dependencies on HZ_PARTIES

Line 678: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

674: l_user_id NUMBER;
675: l_tp_id NUMBER;
676: l_tp_contact_id NUMBER;
677:
678: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
679: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
680:
681: l_source_doctype_id NUMBER := NULL;
682: l_source_orig_round_id NUMBER := NULL;

Line 679: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

675: l_tp_id NUMBER;
676: l_tp_contact_id NUMBER;
677:
678: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
679: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
680:
681: l_source_doctype_id NUMBER := NULL;
682: l_source_orig_round_id NUMBER := NULL;
683: l_source_prev_round_id NUMBER := NULL;

Line 887: FROM HZ_PARTIES

883: --
884: BEGIN
885: SELECT PARTY_NAME
886: INTO l_tp_name
887: FROM HZ_PARTIES
888: WHERE PARTY_ID = l_tp_id;
889:
890: EXCEPTION
891: WHEN NO_DATA_FOUND THEN

Line 9273: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

9269: IS_LARGE_DESTINATION VARCHAR2(1);
9270: l_auction_header_id NUMBER := p_destination_auction_hdr_id;
9271: l_tp_id NUMBER := p_trading_partner_id;
9272: l_tp_contact_id NUMBER := p_trading_partner_contact_id;
9273: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
9274: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
9275: l_user_id NUMBER := p_user_id;
9276: l_source_doctype_id NUMBER := p_source_doctype_id;
9277: l_round_number NUMBER := p_round_number;

Line 9274: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

9270: l_auction_header_id NUMBER := p_destination_auction_hdr_id;
9271: l_tp_id NUMBER := p_trading_partner_id;
9272: l_tp_contact_id NUMBER := p_trading_partner_contact_id;
9273: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
9274: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
9275: l_user_id NUMBER := p_user_id;
9276: l_source_doctype_id NUMBER := p_source_doctype_id;
9277: l_round_number NUMBER := p_round_number;
9278: L_SOURCE_DOC_NUM pon_auction_headers_all.document_number%TYPE := p_source_doc_num;