APPS.IGS_FI_COM_REC_INTERFACE dependencies on HZ_PARTIES

Line 100: FUNCTION get_party_number(p_party_id IN hz_parties.party_id%TYPE) RETURN VARCHAR2 AS

96:
97: END chk_manage_account;
98:
99:
100: FUNCTION get_party_number(p_party_id IN hz_parties.party_id%TYPE) RETURN VARCHAR2 AS
101: ------------------------------------------------------------------
102: --Created by : Priya Athipatla, Oracle IDC
103: --Date created: 21-APR-2003
104: --

Line 113: CURSOR cur_get_party(cp_party_id hz_parties.party_id%TYPE) IS

109: --Change History:
110: --Who When What
111: --
112: -------------------------------------------------------------------
113: CURSOR cur_get_party(cp_party_id hz_parties.party_id%TYPE) IS
114: SELECT party_number
115: FROM hz_parties
116: WHERE party_id = cp_party_id;
117:

Line 115: FROM hz_parties

111: --
112: -------------------------------------------------------------------
113: CURSOR cur_get_party(cp_party_id hz_parties.party_id%TYPE) IS
114: SELECT party_number
115: FROM hz_parties
116: WHERE party_id = cp_party_id;
117:
118: l_v_party_number hz_parties.party_number%TYPE := NULL;
119:

Line 118: l_v_party_number hz_parties.party_number%TYPE := NULL;

114: SELECT party_number
115: FROM hz_parties
116: WHERE party_id = cp_party_id;
117:
118: l_v_party_number hz_parties.party_number%TYPE := NULL;
119:
120: BEGIN
121:
122: -- Obtain the party_number corresponding to the party_id passed

Line 242: l_n_last_person_id hz_parties.party_id%TYPE := NULL;

238: l_v_fee_type igs_lookup_values.meaning%TYPE := NULL;
239: l_v_charge_amt igs_lookup_values.meaning%TYPE := NULL;
240: l_v_credit_number igs_lookup_values.meaning%TYPE := NULL;
241:
242: l_n_last_person_id hz_parties.party_id%TYPE := NULL;
243: l_org_id VARCHAR2(15);
244: l_rowid ROWID := NULL;
245:
246: skip_record EXCEPTION;