75: --Used to retrieve the party id for party name
76: CURSOR for_party_name(c_party_name IN VARCHAR2)
77: IS
78: SELECT party_id
79: FROM hz_parties
80: WHERE upper(party_name) = upper(c_party_name);
81:
82: --Get the party id from hz parties
83: CURSOR for_party_id(c_party_id IN NUMBER)
78: SELECT party_id
79: FROM hz_parties
80: WHERE upper(party_name) = upper(c_party_name);
81:
82: --Get the party id from hz parties
83: CURSOR for_party_id(c_party_id IN NUMBER)
84: IS
85: SELECT party_id
86: FROM hz_parties
82: --Get the party id from hz parties
83: CURSOR for_party_id(c_party_id IN NUMBER)
84: IS
85: SELECT party_id
86: FROM hz_parties
87: WHERE party_id = c_party_id;
88:
89: -- enhancement #2525108: lov for PO Number : pbarman april 2003
90: -- Get Puchase Order Number from PO_PURCHASE_ORDER_V
706: x_msg_data OUT NOCOPY VARCHAR2
707: )
708: IS
709:
710: -- Get the party id from hz parties
711: CURSOR for_party_name(c_party_name IN VARCHAR2)
712: IS
713: SELECT party_id
714: FROM hz_parties
710: -- Get the party id from hz parties
711: CURSOR for_party_name(c_party_name IN VARCHAR2)
712: IS
713: SELECT party_id
714: FROM hz_parties
715: WHERE upper(party_name) = upper(c_party_name);
716:
717: --Get the party id from hz parties
718: CURSOR for_party_id(c_party_id IN NUMBER)
713: SELECT party_id
714: FROM hz_parties
715: WHERE upper(party_name) = upper(c_party_name);
716:
717: --Get the party id from hz parties
718: CURSOR for_party_id(c_party_id IN NUMBER)
719: IS
720: SELECT party_id
721: FROM hz_parties
717: --Get the party id from hz parties
718: CURSOR for_party_id(c_party_id IN NUMBER)
719: IS
720: SELECT party_id
721: FROM hz_parties
722: WHERE party_id = c_party_id;
723:
724: -- Enhancement #2525108: lov for PO Number : pbarman april 2003
725: -- Get Puchase Order Number from PO_PURCHASE_ORDER_V