67:
68: cursor c_party(l_user_id number)
69: is
70: select person_party_id
71: from fnd_user
72: where user_id = l_user_id;
73:
74: l_party_id number ;
75:
112: IF fnd_api.to_boolean (p_init_msg_list) THEN
113: fnd_msg_pub.initialize;
114: END IF;
115:
116: /*If party id has not been passed then get the party id from fnd_user */
117: if(p_party_id is null)
118: then
119: open c_party(p_user_id);
120: fetch c_party into l_party_id;
352:
353: cursor c_party(l_user_id number)
354: is
355: select customer_id
356: from fnd_user
357: where user_id = l_user_id;
358:
359: l_party_id number;
360:
384: IF fnd_api.to_boolean (p_init_msg_list) THEN
385: fnd_msg_pub.initialize;
386: END IF;
387:
388: /*If party id has not been passed then get the party id from fnd_user */
389: if(p_party_id is null)
390: then
391: open c_party(p_user_id);
392: fetch c_party into l_party_id;
503:
504: cursor c_party(l_user_id number)
505: is
506: select customer_id
507: from fnd_user
508: where user_id = l_user_id;
509:
510: l_party_id number ;
511:
542: IF fnd_api.to_boolean (p_init_msg_list) THEN
543: fnd_msg_pub.initialize;
544: END IF;
545:
546: /*If party id has not been passed then get the party id from fnd_user */
547: if(p_party_id is null)
548: then
549: open c_party(p_user_id);
550: fetch c_party into l_party_id;