9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
10: g_pk2_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
11:
12: procedure insert_party_sites_acc (p_party_site_id hz_party_sites.party_site_id%type,
13: p_party_id hz_parties.party_id%type,
14: p_user_id fnd_user.user_id%type)
15: is
16: l_sysdate date;
17: begin
48: p_error_msg OUT NOCOPY VARCHAR2,
49: x_return_status IN OUT NOCOPY VARCHAR2
50: )
51: IS
52: l_party_id hz_parties.party_id%type;
53: l_err_msg VARCHAR2(4000);
54: l_ret_status VARCHAR2(4000);
55:
56: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type)
104: p_error_msg OUT NOCOPY VARCHAR2,
105: x_return_status IN OUT NOCOPY VARCHAR2
106: )
107: IS
108: l_party_id hz_parties.party_id%type;
109: l_err_msg VARCHAR2(4000);
110: l_ret_status VARCHAR2(4000);
111:
112: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type)