eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_WORKFLOW_PVT dependencies on HZ_PARTIES

Line 173: hz_parties sold_to_party,

169: invaddr.postal_code bill_to_postal_code,
170: invaddr.country bill_to_country,
171: oh.transactional_curr_code
172: from oe_order_headers_all oh,
173: hz_parties sold_to_party,
174: hz_cust_accounts sold_to_account,
175: hz_locations shipaddr,
176: hz_party_sites shp_party_site,
177: hz_cust_acct_sites_all shp_acct_site,

Line 272: Cursor c_hz_parties(c_party_id NUMBER) IS

268: SELECT Payment_type_code
269: FROM Aso_Payments
270: WHERE quote_header_id = p_quote_id;
271:
272: Cursor c_hz_parties(c_party_id NUMBER) IS
273: SELECT Party_Name,
274: Person_First_Name,
275: Person_Middle_Name,
276: Person_Last_name,

Line 279: FROM hz_parties

275: Person_Middle_Name,
276: Person_Last_name,
277: party_type,
278: Person_title
279: FROM hz_parties
280: WHERE party_id = c_party_id;
281:
282: Cursor c_hz_contact_points(p_party_id NUMBER) IS
283: SELECT Contact_Point_type,

Line 291: WHERE owner_table_name = 'HZ_PARTIES'

287: Phone_area_code,
288: Phone_number,
289: Email_address
290: FROM hz_contact_points
291: WHERE owner_table_name = 'HZ_PARTIES'
292: AND owner_table_id = p_party_id;
293:
294: cursor c_order_curr_code(c_order_id number) is
295: select transactional_curr_code

Line 323: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP

319: l_PartyType Varchar2(30);
320: l_UserType jtf_um_usertypes_b.usertype_key%type := 'B2B';
321: BEGIN
322: ----DBMS_OUTPUT.PUT('Into getusertype party_id is: '||ppartyid);
323: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
324: ----DBMS_OUTPUT.PUT('Opened the cursor loop');
325:
326: l_PartyType := rtrim(c_hz_parties_rec.party_type);
327: ----DBMS_OUTPUT.PUT('party_type is: '||l_partytype);

Line 326: l_PartyType := rtrim(c_hz_parties_rec.party_type);

322: ----DBMS_OUTPUT.PUT('Into getusertype party_id is: '||ppartyid);
323: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
324: ----DBMS_OUTPUT.PUT('Opened the cursor loop');
325:
326: l_PartyType := rtrim(c_hz_parties_rec.party_type);
327: ----DBMS_OUTPUT.PUT('party_type is: '||l_partytype);
328: END LOOP;
329:
330: If l_PartyType = 'PERSON' Then

Line 367: l_PartyType HZ_PARTIES.PARTY_TYPE%type :='';

363: Procedure getUserType(pPartyId IN NUMBER,
364: pUserType OUT NOCOPY Varchar2) IS
365:
366: l_api_name CONSTANT VARCHAR2(30) :='getUserType';
367: l_PartyType HZ_PARTIES.PARTY_TYPE%type :='';
368: l_UserType jtf_um_usertypes_b.usertype_key%type :='ALL';
369: l_user_name FND_USER.USER_NAME%type;
370: l_is_pv_partner boolean :=false;
371: l_is_int_primary_user boolean:=false;

Line 383: from jtf_um_usertype_reg a,jtf_um_usertypes_b b, fnd_user c , hz_parties d

379: --
380: -- cursor to retrieve user type from jta tables
381: Cursor c_get_user_type(c_party_id NUMBER) IS
382: select b.usertype_key
383: from jtf_um_usertype_reg a,jtf_um_usertypes_b b, fnd_user c , hz_parties d
384: where a.usertype_id=b.usertype_id and c.user_id = a.user_id
385: and d.party_id = c.customer_id and b.application_id=671
386: and d.party_id = c_party_id;
387:

Line 391: from fnd_user c , hz_parties d

387:
388: -- Cursor to get the party type , user name from fnd and hz tables
389: Cursor c_get_party_type_user_name(c_party_id NUMBER) IS
390: select d.party_type,c.user_name
391: from fnd_user c , hz_parties d
392: where d.party_id=c.customer_id
393: and d.party_id=c_party_id;
394:
395: BEGIN

Line 831: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,

827: END ;
828:
829:
830:
831: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
832: p_user_type IN VARCHAR2,
833: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
834: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
835: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,

Line 834: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,

830:
831: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
832: p_user_type IN VARCHAR2,
833: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
834: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
835: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
836: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
837:
838: l_usertype jtf_um_usertypes_b.usertype_key%type;

Line 835: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,

831: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
832: p_user_type IN VARCHAR2,
833: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
834: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
835: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
836: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
837:
838: l_usertype jtf_um_usertypes_b.usertype_key%type;
839: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 836: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS

832: p_user_type IN VARCHAR2,
833: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
834: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
835: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
836: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
837:
838: l_usertype jtf_um_usertypes_b.usertype_key%type;
839: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
840: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 839: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

835: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
836: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
837:
838: l_usertype jtf_um_usertypes_b.usertype_key%type;
839: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
840: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
841: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
842:
843: CURSOR c_get_recepient_name(p_party_id number) IS

Line 840: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

836: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
837:
838: l_usertype jtf_um_usertypes_b.usertype_key%type;
839: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
840: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
841: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
842:
843: CURSOR c_get_recepient_name(p_party_id number) IS
844: SELECT person_first_name, person_last_name

Line 841: l_partyid HZ_PARTIES.PARTY_ID%TYPE;

837:
838: l_usertype jtf_um_usertypes_b.usertype_key%type;
839: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
840: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
841: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
842:
843: CURSOR c_get_recepient_name(p_party_id number) IS
844: SELECT person_first_name, person_last_name
845: FROM hz_parties

Line 845: FROM hz_parties

841: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
842:
843: CURSOR c_get_recepient_name(p_party_id number) IS
844: SELECT person_first_name, person_last_name
845: FROM hz_parties
846: WHERE party_id = p_party_id;
847:
848: rec_get_recepient_name c_get_recepient_name%rowtype;
849:

Line 855: hz_parties p

851: SELECT p.person_first_name,
852: p.person_last_name,
853: p.party_id
854: FROM hz_relationships l,
855: hz_parties p
856: WHERE l.party_id = p_party_id
857: AND l.subject_id = p.party_id
858: AND l.subject_type = 'PERSON'
859: AND l.object_type = 'ORGANIZATION';

Line 915: PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,

911: --modified by abhandar for 11.5.10
912: --Modification : If party_type= person then
913: --retrieve name from the HZ_PARTY, else retrieve from the HZ_Relationship and HZ_Part tables .
914:
915: PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
916: p_user_type IN VARCHAR2,
917: p_sharee_number IN NUMBER := NULL,
918: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
919: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,

Line 918: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,

914:
915: PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
916: p_user_type IN VARCHAR2,
917: p_sharee_number IN NUMBER := NULL,
918: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
919: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
920: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
921:
922: l_usertype jtf_um_usertypes_b.usertype_key%type;

Line 919: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,

915: PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
916: p_user_type IN VARCHAR2,
917: p_sharee_number IN NUMBER := NULL,
918: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
919: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
920: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
921:
922: l_usertype jtf_um_usertypes_b.usertype_key%type;
923: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 920: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS

916: p_user_type IN VARCHAR2,
917: p_sharee_number IN NUMBER := NULL,
918: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
919: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
920: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
921:
922: l_usertype jtf_um_usertypes_b.usertype_key%type;
923: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
924: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 923: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

919: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
920: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
921:
922: l_usertype jtf_um_usertypes_b.usertype_key%type;
923: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
924: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
925: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
926: l_PartyType Varchar2(30);
927:

Line 924: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

920: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
921:
922: l_usertype jtf_um_usertypes_b.usertype_key%type;
923: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
924: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
925: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
926: l_PartyType Varchar2(30);
927:
928:

Line 925: l_partyid HZ_PARTIES.PARTY_ID%TYPE;

921:
922: l_usertype jtf_um_usertypes_b.usertype_key%type;
923: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
924: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
925: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
926: l_PartyType Varchar2(30);
927:
928:
929: CURSOR c_get_party_type_and_name (p_party_id number) IS

Line 931: FROM hz_parties

927:
928:
929: CURSOR c_get_party_type_and_name (p_party_id number) IS
930: SELECT party_type, person_first_name, person_last_name,party_id
931: FROM hz_parties
932: WHERE party_id = p_party_id;
933:
934: rec_get_recipient_name c_get_party_type_and_name%rowtype;
935:

Line 941: hz_parties p

937: SELECT p.person_first_name,
938: p.person_last_name,
939: p.party_id
940: FROM hz_relationships l,
941: hz_parties p
942: WHERE l.party_id = p_party_id
943: AND l.subject_id = p.party_id
944: AND l.subject_type = 'PERSON'
945: AND l.object_type = 'ORGANIZATION';

Line 1367: from hz_parties a,hz_parties b,hz_relationships c

1363: and rownum= 1 and application_id=671;
1364:
1365: Cursor C_get_org_num(c_party_id NUMBER) IS
1366: select b.party_number
1367: from hz_parties a,hz_parties b,hz_relationships c
1368: where a.party_id= c.party_id
1369: and b.party_id= c.object_id
1370: and c.subject_table_name = 'HZ_PARTIES'
1371: and c.object_table_name = 'HZ_PARTIES'

Line 1370: and c.subject_table_name = 'HZ_PARTIES'

1366: select b.party_number
1367: from hz_parties a,hz_parties b,hz_relationships c
1368: where a.party_id= c.party_id
1369: and b.party_id= c.object_id
1370: and c.subject_table_name = 'HZ_PARTIES'
1371: and c.object_table_name = 'HZ_PARTIES'
1372: and c.directional_flag = 'F'
1373: and a.party_id=c_party_id;
1374:

Line 1371: and c.object_table_name = 'HZ_PARTIES'

1367: from hz_parties a,hz_parties b,hz_relationships c
1368: where a.party_id= c.party_id
1369: and b.party_id= c.object_id
1370: and c.subject_table_name = 'HZ_PARTIES'
1371: and c.object_table_name = 'HZ_PARTIES'
1372: and c.directional_flag = 'F'
1373: and a.party_id=c_party_id;
1374:
1375: -- end-ab

Line 2742: hz_parties p

2738: o.sold_to_contact_id
2739: from oe_order_headers_all o,
2740: hz_cust_Account_roles r,
2741: hz_relationships l,
2742: hz_parties p
2743: where o.header_id = c_order_id
2744: and o.sold_to_contact_id = r.cust_account_role_id
2745: and r.party_id = l.party_id
2746: and l.subject_id = p.party_id

Line 2759: hz_parties p

2755: p.person_middle_name
2756:
2757: from hz_cust_accounts a,
2758: oe_order_headers_all o,
2759: hz_parties p
2760: where o.sold_to_org_id = a.cust_account_id
2761: and a.party_id = p.party_id
2762: and o.header_id = c_order_id;
2763:

Line 2771: from hz_parties p,

2767: o.last_updated_by ,
2768: p.person_first_name ,
2769: p.person_middle_name,
2770: p.person_last_name
2771: from hz_parties p,
2772: oe_order_headers_all o,
2773: fnd_user f,
2774: hz_relationships r
2775: where o.last_updated_by = f.user_id

Line 2826: IF (l_party_type = 'PERSON') then --B2C user, get the details directly from hz_parties

2822: ----DBMS_OUTPUT.PUT('Party type is: '||l_party_type);
2823: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2824: IBE_UTIL.debug('L_party_type in get_contact_details_for_order: '||l_party_type);
2825: END IF;
2826: IF (l_party_type = 'PERSON') then --B2C user, get the details directly from hz_parties
2827: x_contact_party_id := rec_b2c_contact.party_id;
2828: x_contact_first_name := rec_b2c_contact.person_first_name;
2829: x_contact_mid_name := rec_b2c_contact.person_middle_name;
2830: x_contact_last_name := rec_b2c_contact.person_last_name;

Line 4673: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES

4669:
4670: END Get_Speciality_Store_name;*/
4671:
4672: /********************************************************
4673: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES
4674: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be
4675: sent to ad-hoc users, otherwise they will be sent to users who will be identified by their party_id
4676: in the HZ_PARTIES table
4677: *********************************************************/

Line 4676: in the HZ_PARTIES table

4672: /********************************************************
4673: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES
4674: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be
4675: sent to ad-hoc users, otherwise they will be sent to users who will be identified by their party_id
4676: in the HZ_PARTIES table
4677: *********************************************************/
4678: procedure locate_contact_point
4679: ( p_contact_point_id IN NUMBER ,
4680: x_create_adhoc_flag OUT NOCOPY VARCHAR2 ) is

Line 4734: l_partyid HZ_PARTIES.PARTY_ID%TYPE;

4730: l_notif_context VARCHAR2(2000);
4731: l_Orgid Number := null;
4732: l_messageName WF_MESSAGES.NAME%TYPE;
4733: l_msgEnabled VARCHAR2(3);
4734: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
4735: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4736: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4737: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4738: l_user_name WF_USERS.NAME%TYPE;

Line 4735: x_partyid HZ_PARTIES.PARTY_ID%TYPE;

4731: l_Orgid Number := null;
4732: l_messageName WF_MESSAGES.NAME%TYPE;
4733: l_msgEnabled VARCHAR2(3);
4734: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
4735: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4736: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4737: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4738: l_user_name WF_USERS.NAME%TYPE;
4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;

Line 4747: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4746: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4747: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4748: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4749: l_recip_name Varchar2(2000);
4750:
4751: CURSOR c_msite_name(p_msite number) IS

Line 4748: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4746: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4747: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4748: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4749: l_recip_name Varchar2(2000);
4750:
4751: CURSOR c_msite_name(p_msite number) IS
4752: SELECT msite_name

Line 4945: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

4941: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4942: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4943: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4944:
4945: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4946: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4947: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4948: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4949:

Line 4946: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

4942: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4943: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4944:
4945: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4946: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4947: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4948: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4949:
4950: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 4947: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

4943: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4944:
4945: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4946: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4947: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4948: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4949:
4950: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4951: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 4948: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;

4944:
4945: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4946: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4947: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4948: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4949:
4950: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4951: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4952: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 4950: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

4946: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4947: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4948: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4949:
4950: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4951: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4952: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
4953:
4954: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 4951: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

4947: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4948: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4949:
4950: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4951: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4952: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
4953:
4954: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
4955:

Line 4952: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

4948: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4949:
4950: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4951: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4952: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
4953:
4954: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
4955:
4956: l_role_users Varchar2(200);

Line 5180: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

5176: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5177: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5178: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5179:
5180: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5181: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5182: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5183: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5184:

Line 5181: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

5177: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5178: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5179:
5180: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5181: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5182: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5183: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5184:
5185: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 5182: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

5178: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5179:
5180: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5181: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5182: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5183: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5184:
5185: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5186: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5183: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;

5179:
5180: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5181: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5182: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5183: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5184:
5185: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5186: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5187: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 5185: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

5181: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5182: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5183: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5184:
5185: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5186: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5187: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5188: l_accesslevel VARCHAR2(60);
5189:

Line 5186: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

5182: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5183: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5184:
5185: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5186: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5187: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5188: l_accesslevel VARCHAR2(60);
5189:
5190: l_role_users Varchar2(400);

Line 5187: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

5183: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5184:
5185: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5186: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5187: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5188: l_accesslevel VARCHAR2(60);
5189:
5190: l_role_users Varchar2(400);
5191: l_adhoc_role WF_ROLES.NAME%TYPE;

Line 5434: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

5430: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5431: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5432: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5433:
5434: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5435: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5436: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5437: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5438:

Line 5435: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

5431: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5432: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5433:
5434: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5435: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5436: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5437: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5438:
5439: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 5436: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

5432: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5433:
5434: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5435: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5436: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5437: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5438:
5439: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5440: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5437: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;

5433:
5434: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5435: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5436: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5437: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5438:
5439: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5440: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5441: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 5439: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

5435: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5436: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5437: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5438:
5439: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5440: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5441: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5442:
5443: l_new_access_level VARCHAR2(60);

Line 5440: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

5436: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5437: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5438:
5439: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5440: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5441: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5442:
5443: l_new_access_level VARCHAR2(60);
5444: l_old_access_level VARCHAR2(60);

Line 5441: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

5437: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5438:
5439: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5440: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5441: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5442:
5443: l_new_access_level VARCHAR2(60);
5444: l_old_access_level VARCHAR2(60);
5445:

Line 5510: -- And pipe it with HZ_PARTIES to get email id of the recepient.

5506: x_party_id => x_owner_new_party_id);
5507:
5508: -- Now identify whether the recepient is B2B or B2C ****
5509: -- Call the Get_Name_details to get the party_id of the recepient.
5510: -- And pipe it with HZ_PARTIES to get email id of the recepient.
5511:
5512: l_usertype := FND_API.G_MISS_CHAR;
5513: x_recepient_party_id := 0;
5514: Get_Name_details(p_party_id => l_quote_access_rec.party_id,

Line 6361: l_party_first_name hz_parties.person_first_name%TYPE;

6357: l_item_key wf_items.item_key%TYPE;
6358: l_quote_id NUMBER;
6359: l_event_type VARCHAR2(20);
6360: l_document VARCHAR2(32000) := '';
6361: l_party_first_name hz_parties.person_first_name%TYPE;
6362: l_party_last_name hz_parties.person_last_name%TYPE;
6363: l_temp_str VARCHAR2(2000):='';
6364: l_errmsg_data VARCHAR2(2000):='';
6365: l_order_id NUMBER;

Line 6362: l_party_last_name hz_parties.person_last_name%TYPE;

6358: l_quote_id NUMBER;
6359: l_event_type VARCHAR2(20);
6360: l_document VARCHAR2(32000) := '';
6361: l_party_first_name hz_parties.person_first_name%TYPE;
6362: l_party_last_name hz_parties.person_last_name%TYPE;
6363: l_temp_str VARCHAR2(2000):='';
6364: l_errmsg_data VARCHAR2(2000):='';
6365: l_order_id NUMBER;
6366: l_Ship_Method Varchar2(80);

Line 6600: l_party_first_name hz_parties.person_first_name%TYPE;

6596: l_item_key wf_items.item_key%TYPE;
6597: l_quote_id NUMBER;
6598: l_event_type VARCHAR2(20);
6599: l_comments VARCHAR2(2000);
6600: l_party_first_name hz_parties.person_first_name%TYPE;
6601: l_party_last_name hz_parties.person_last_name%TYPE;
6602: l_contact_party_id hz_parties.party_id%TYPE;
6603: l_contact_name VARCHAR2(400);
6604: l_contact_number VARCHAR2(70);

Line 6601: l_party_last_name hz_parties.person_last_name%TYPE;

6597: l_quote_id NUMBER;
6598: l_event_type VARCHAR2(20);
6599: l_comments VARCHAR2(2000);
6600: l_party_first_name hz_parties.person_first_name%TYPE;
6601: l_party_last_name hz_parties.person_last_name%TYPE;
6602: l_contact_party_id hz_parties.party_id%TYPE;
6603: l_contact_name VARCHAR2(400);
6604: l_contact_number VARCHAR2(70);
6605: l_contact_email hz_contact_points.email_address%TYPE;

Line 6602: l_contact_party_id hz_parties.party_id%TYPE;

6598: l_event_type VARCHAR2(20);
6599: l_comments VARCHAR2(2000);
6600: l_party_first_name hz_parties.person_first_name%TYPE;
6601: l_party_last_name hz_parties.person_last_name%TYPE;
6602: l_contact_party_id hz_parties.party_id%TYPE;
6603: l_contact_name VARCHAR2(400);
6604: l_contact_number VARCHAR2(70);
6605: l_contact_email hz_contact_points.email_address%TYPE;
6606: l_contact_fax VARCHAR2(70);

Line 6624: hz_parties p

6620: p.party_type
6621: from oe_order_headers_all o,
6622: hz_cust_Account_roles r,
6623: hz_relationships l,
6624: hz_parties p
6625: where o.header_id = pOrder
6626: and o.sold_to_contact_id = r.cust_account_role_id
6627: and r.party_id = l.party_id
6628: and l.subject_id = p.party_id

Line 6683: FOR c_hz_parties_rec IN c_hz_parties(g_header_rec.party_id) LOOP

6679: l_party_first_name := null;
6680: l_party_last_name := null;
6681: l_contact_name := null;
6682:
6683: FOR c_hz_parties_rec IN c_hz_parties(g_header_rec.party_id) LOOP
6684: If c_hz_parties_rec.Party_type = 'ORGANIZATION' Then
6685: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
6686: l_party_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
6687: l_party_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));

Line 6684: If c_hz_parties_rec.Party_type = 'ORGANIZATION' Then

6680: l_party_last_name := null;
6681: l_contact_name := null;
6682:
6683: FOR c_hz_parties_rec IN c_hz_parties(g_header_rec.party_id) LOOP
6684: If c_hz_parties_rec.Party_type = 'ORGANIZATION' Then
6685: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
6686: l_party_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
6687: l_party_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
6688: l_contact_name := l_party_first_name||' '||l_party_last_name;

Line 6692: l_party_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));

6688: l_contact_name := l_party_first_name||' '||l_party_last_name;
6689: l_contact_party_id := c_b2b_contact_rec.contact_party_id;
6690: End Loop;
6691: Else
6692: l_party_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));
6693: l_party_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));
6694: l_contact_name := l_party_first_name||' '||l_party_last_name;
6695: l_contact_party_id := g_header_rec.party_id;
6696: End If;

Line 6693: l_party_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));

6689: l_contact_party_id := c_b2b_contact_rec.contact_party_id;
6690: End Loop;
6691: Else
6692: l_party_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));
6693: l_party_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));
6694: l_contact_name := l_party_first_name||' '||l_party_last_name;
6695: l_contact_party_id := g_header_rec.party_id;
6696: End If;
6697: END LOOP;

Line 8628: l_bill_to_party_name hz_parties.party_name%TYPE;

8624: l_comments VARCHAR2(2000);
8625: l_contact_name VARCHAR2(400);
8626: l_contact_number VARCHAR2(70);
8627: l_contact_email hz_contact_points.email_address%TYPE;
8628: l_bill_to_party_name hz_parties.party_name%TYPE;
8629: l_bill_to_name VARCHAR2(400);
8630: l_bill_to_number VARCHAR2(70);
8631: l_bill_to_fax VARCHAR2(70);
8632: l_bill_to_address hz_locations.address1%TYPE;

Line 8644: l_ship_to_party_name hz_parties.party_name%TYPE;

8640: l_ship_method_code aso_shipments.ship_method_code%TYPE;
8641:
8642: l_ship_method varchar2(80);
8643:
8644: l_ship_to_party_name hz_parties.party_name%TYPE;
8645: l_ship_to_name VARCHAR2(400);
8646: l_ship_to_number VARCHAR2(70);
8647: l_ship_to_fax VARCHAR2(70);
8648: l_ship_to_address hz_locations.address1%TYPE;

Line 8676: FROM hz_cust_accounts hc, hz_parties hp

8672:
8673:
8674: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
8675: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
8676: FROM hz_cust_accounts hc, hz_parties hp
8677: WHERE cust_account_id = p_cust_account_id
8678: AND hc.party_id = hp.party_id;
8679:
8680: l_sold_contact_party_id Number;

Line 8735: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP

8731:
8732: l_contact_name := null;
8733: l_sold_contact_party_id := null;
8734:
8735: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
8736: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8737: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
8738:
8739: l_sold_contact_party_id := g_quote_header_rec.party_id;

Line 8736: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then

8732: l_contact_name := null;
8733: l_sold_contact_party_id := null;
8734:
8735: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
8736: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8737: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
8738:
8739: l_sold_contact_party_id := g_quote_header_rec.party_id;
8740: End If;

Line 8737: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));

8733: l_sold_contact_party_id := null;
8734:
8735: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
8736: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8737: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
8738:
8739: l_sold_contact_party_id := g_quote_header_rec.party_id;
8740: End If;
8741: END LOOP;

Line 8803: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id) LOOP

8799:
8800: /* Bill Contact Info. From Invoice_To_Party_ID (PARTY_RELATIONSHIP) OR Bill Customer Party Id. */
8801:
8802: If g_quote_header_rec.invoice_to_party_id is not null Then
8803: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id) LOOP
8804: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8805: l_bill_contact_party_id := g_quote_header_rec.party_id;
8806: End If;
8807: END LOOP;

Line 8804: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then

8800: /* Bill Contact Info. From Invoice_To_Party_ID (PARTY_RELATIONSHIP) OR Bill Customer Party Id. */
8801:
8802: If g_quote_header_rec.invoice_to_party_id is not null Then
8803: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id) LOOP
8804: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8805: l_bill_contact_party_id := g_quote_header_rec.party_id;
8806: End If;
8807: END LOOP;
8808: End if;

Line 8895: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP

8891: END IF;
8892:
8893: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
8894: If l_ship_to_party_id is not null Then
8895: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP
8896: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8897: l_ship_contact_party_id := g_quote_header_rec.party_id;
8898: End If;
8899: END LOOP;

Line 8896: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then

8892:
8893: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
8894: If l_ship_to_party_id is not null Then
8895: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP
8896: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8897: l_ship_contact_party_id := g_quote_header_rec.party_id;
8898: End If;
8899: END LOOP;
8900: End If;

Line 9623: hz_parties p

9619: p.party_type
9620: from oe_order_headers_all o,
9621: hz_cust_Account_roles r,
9622: hz_relationships l,
9623: hz_parties p
9624: where o.header_id = c_order_id
9625: and o.sold_to_contact_id = r.cust_account_role_id
9626: and r.party_id = l.party_id
9627: and l.subject_id = p.party_id

Line 9638: hz_parties p

9634: p.person_last_name,
9635: p.person_title,
9636: p.party_type
9637: from hz_relationships l,
9638: hz_parties p
9639: where l.party_id = pPartyId
9640: and l.subject_id = p.party_id
9641: and l.subject_type = 'PERSON'
9642: and l.object_type = 'ORGANIZATION';

Line 9652: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9648: l_party_id := c_quote_rec.party_id;
9649: l_order_id := c_quote_rec.order_id;
9650: END LOOP;
9651:
9652: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9653: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9654: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9655: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9656: End Loop;

Line 9653: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then

9649: l_order_id := c_quote_rec.order_id;
9650: END LOOP;
9651:
9652: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9653: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9654: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9655: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9656: End Loop;
9657: Else

Line 9658: l_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));

9654: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9655: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9656: End Loop;
9657: Else
9658: l_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));
9659: End If;
9660: END LOOP;
9661:
9662: --bug 2299210

Line 9664: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9660: END LOOP;
9661:
9662: --bug 2299210
9663: IF l_first_name IS NULL THEN
9664: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9665: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9666: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9667: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9668: END LOOP;

Line 9665: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN

9661:
9662: --bug 2299210
9663: IF l_first_name IS NULL THEN
9664: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9665: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9666: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9667: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9668: END LOOP;
9669: END IF;

Line 9703: hz_parties p

9699: p.party_type
9700: from oe_order_headers_all o,
9701: hz_cust_Account_roles r,
9702: hz_relationships l,
9703: hz_parties p
9704: where o.header_id = c_Order_id
9705: and o.sold_to_contact_id = r.cust_account_role_id
9706: and r.party_id = l.party_id
9707: and l.subject_id = p.party_id

Line 9718: hz_parties p

9714: p.person_last_name,
9715: p.person_title,
9716: p.party_type
9717: from hz_relationships l,
9718: hz_parties p
9719: where l.party_id = pPartyId
9720: and l.subject_id = p.party_id
9721: and l.subject_type = 'PERSON'
9722: and l.object_type = 'ORGANIZATION';

Line 9732: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9728: l_party_id := c_quote_rec.party_id;
9729: l_order_id := c_quote_rec.order_id;
9730: END LOOP;
9731:
9732: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9733: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9734: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9735: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9736: End Loop;

Line 9733: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then

9729: l_order_id := c_quote_rec.order_id;
9730: END LOOP;
9731:
9732: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9733: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9734: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9735: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9736: End Loop;
9737: Else

Line 9738: l_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));

9734: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9735: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9736: End Loop;
9737: Else
9738: l_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));
9739: End If;
9740: END LOOP;
9741:
9742: --bug 2299210

Line 9744: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9740: END LOOP;
9741:
9742: --bug 2299210
9743: IF l_last_name IS NULL THEN
9744: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9745: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9746: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9747: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9748: END LOOP;

Line 9745: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN

9741:
9742: --bug 2299210
9743: IF l_last_name IS NULL THEN
9744: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9745: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9746: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9747: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9748: END LOOP;
9749: END IF;

Line 9773: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;

9769: ) IS
9770:
9771: l_party_id number;
9772: l_order_id number;
9773: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;
9774:
9775: Cursor c_b2b_contact(c_Order_id Number) IS
9776: Select p.party_id Person_Party_id,
9777: l.party_id contact_party_id,

Line 9785: hz_parties p

9781: p.person_title
9782: from oe_order_headers_all o,
9783: hz_cust_Account_roles r,
9784: hz_relationships l,
9785: hz_parties p
9786: where o.header_id = c_order_id
9787: and o.sold_to_contact_id = r.cust_account_role_id
9788: and r.party_id = l.party_id
9789: and l.subject_id = p.party_id

Line 9800: hz_parties p

9796: p.person_last_name,
9797: p.person_title,
9798: p.party_type
9799: from hz_relationships l,
9800: hz_parties p
9801: where l.party_id = pPartyId
9802: and l.subject_id = p.party_id
9803: and l.subject_type = 'PERSON'
9804: and l.object_type = 'ORGANIZATION';

Line 9814: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9810: l_party_id := c_quote_rec.party_id;
9811: l_order_id := c_quote_rec.order_id;
9812: END LOOP;
9813:
9814: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9815: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9816: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9817: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9818: End Loop;

Line 9815: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then

9811: l_order_id := c_quote_rec.order_id;
9812: END LOOP;
9813:
9814: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9815: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9816: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9817: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9818: End Loop;
9819: Else

Line 9820: l_person_title := upper(rtrim(c_hz_parties_rec.person_title));

9816: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9817: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9818: End Loop;
9819: Else
9820: l_person_title := upper(rtrim(c_hz_parties_rec.person_title));
9821: End If;
9822: END LOOP;
9823:
9824: --bug 2299210

Line 9826: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9822: END LOOP;
9823:
9824: --bug 2299210
9825: IF l_person_title IS NULL THEN
9826: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9827: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9828: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9829: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9830: END LOOP;

Line 9827: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN

9823:
9824: --bug 2299210
9825: IF l_person_title IS NULL THEN
9826: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9827: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9828: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9829: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9830: END LOOP;
9831: END IF;