APPS.IBY_CREDITCARD_PKG dependencies on HZ_PARTIES

Line 71: p_party_id IN hz_parties.party_id%TYPE

67: END isNumber;
68:
69: FUNCTION Get_Billing_Site
70: (p_party_site_id IN hz_party_sites.party_site_id%TYPE,
71: p_party_id IN hz_parties.party_id%TYPE
72: )
73: RETURN hz_party_site_uses.party_site_use_id%TYPE
74: IS
75: l_site_use_id hz_party_site_uses.party_site_use_id%TYPE;

Line 84: ci_party_id IN hz_parties.party_id%TYPE

80: lx_msg_data VARCHAR2(2000);
81:
82: CURSOR c_site_use
83: (ci_party_site IN hz_party_sites.party_site_id%TYPE,
84: ci_party_id IN hz_parties.party_id%TYPE
85: )
86: IS
87: SELECT u.party_site_use_id
88: FROM hz_party_site_uses u, hz_party_sites s

Line 100: ci_party_id IN hz_parties.party_id%TYPE

96: AND ( NVL(u.end_date,SYSDATE+10) > SYSDATE);
97:
98: CURSOR c_site
99: (ci_party_site hz_party_sites.party_site_id%TYPE,
100: ci_party_id IN hz_parties.party_id%TYPE
101: )
102: IS
103: SELECT party_site_id
104: FROM hz_party_sites

Line 439: (ci_owner_id IN hz_parties.party_id%TYPE,

435: l_isAlphaNumericCard VARCHAR2(1) := 'N';
436: l_allow_invalid_card VARCHAR2(1);
437:
438: CURSOR c_card
439: (ci_owner_id IN hz_parties.party_id%TYPE,
440: ci_hash1 IN iby_creditcard.cc_number_hash1%TYPE,
441: ci_hash2 IN iby_creditcard.cc_number_hash1%TYPE
442: )
443: IS