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 163: hz_parties sold_to_party,

159: invaddr.postal_code bill_to_postal_code,
160: invaddr.country bill_to_country,
161: oh.transactional_curr_code
162: from oe_order_headers_all oh,
163: hz_parties sold_to_party,
164: hz_cust_accounts sold_to_account,
165: hz_locations shipaddr,
166: hz_party_sites shp_party_site,
167: hz_cust_acct_sites_all shp_acct_site,

Line 262: Cursor c_hz_parties(c_party_id NUMBER) IS

258: SELECT Payment_type_code
259: FROM Aso_Payments
260: WHERE quote_header_id = p_quote_id;
261:
262: Cursor c_hz_parties(c_party_id NUMBER) IS
263: SELECT Party_Name,
264: Person_First_Name,
265: Person_Middle_Name,
266: Person_Last_name,

Line 269: FROM hz_parties

265: Person_Middle_Name,
266: Person_Last_name,
267: party_type,
268: Person_title
269: FROM hz_parties
270: WHERE party_id = c_party_id;
271:
272: Cursor c_hz_contact_points(p_party_id NUMBER) IS
273: SELECT Contact_Point_type,

Line 281: WHERE owner_table_name = 'HZ_PARTIES'

277: Phone_area_code,
278: Phone_number,
279: Email_address
280: FROM hz_contact_points
281: WHERE owner_table_name = 'HZ_PARTIES'
282: AND owner_table_id = p_party_id;
283:
284: cursor c_order_curr_code(c_order_id number) is
285: select transactional_curr_code

Line 313: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP

309: l_PartyType Varchar2(30);
310: l_UserType Varchar2(30) := 'B2B';
311: BEGIN
312: ----DBMS_OUTPUT.PUT('Into getusertype party_id is: '||ppartyid);
313: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
314: ----DBMS_OUTPUT.PUT('Opened the cursor loop');
315:
316: l_PartyType := rtrim(c_hz_parties_rec.party_type);
317: ----DBMS_OUTPUT.PUT('party_type is: '||l_partytype);

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

312: ----DBMS_OUTPUT.PUT('Into getusertype party_id is: '||ppartyid);
313: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
314: ----DBMS_OUTPUT.PUT('Opened the cursor loop');
315:
316: l_PartyType := rtrim(c_hz_parties_rec.party_type);
317: ----DBMS_OUTPUT.PUT('party_type is: '||l_partytype);
318: END LOOP;
319:
320: If l_PartyType = 'PERSON' Then

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

353: Procedure getUserType(pPartyId IN NUMBER,
354: pUserType OUT NOCOPY Varchar2) IS
355:
356: l_api_name CONSTANT VARCHAR2(30) :='getUserType';
357: l_PartyType HZ_PARTIES.PARTY_TYPE%type :='';
358: l_UserType jtf_um_usertypes_b.usertype_key%type :='ALL';
359: l_user_name FND_USER.USER_NAME%type;
360: l_is_pv_partner boolean :=false;
361: l_is_int_primary_user boolean:=false;

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

369: --
370: -- cursor to retrieve user type from jta tables
371: Cursor c_get_user_type(c_party_id NUMBER) IS
372: select b.usertype_key
373: from jtf_um_usertype_reg a,jtf_um_usertypes_b b, fnd_user c , hz_parties d
374: where a.usertype_id=b.usertype_id and c.user_id = a.user_id
375: and d.party_id = c.customer_id and b.application_id=671
376: and d.party_id = c_party_id;
377:

Line 381: from fnd_user c , hz_parties d

377:
378: -- Cursor to get the party type , user name from fnd and hz tables
379: Cursor c_get_party_type_user_name(c_party_id NUMBER) IS
380: select d.party_type,c.user_name
381: from fnd_user c , hz_parties d
382: where d.party_id=c.customer_id
383: and d.party_id=c_party_id;
384:
385: BEGIN

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

817: END ;
818:
819:
820:
821: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
822: p_user_type IN VARCHAR2,
823: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
824: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
825: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,

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

820:
821: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
822: p_user_type IN VARCHAR2,
823: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
824: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
825: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
826: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
827:
828: l_usertype Varchar2(30);

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

821: /*PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
822: p_user_type IN VARCHAR2,
823: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
824: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
825: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
826: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
827:
828: l_usertype Varchar2(30);
829: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

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

822: p_user_type IN VARCHAR2,
823: p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
824: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
825: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
826: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
827:
828: l_usertype Varchar2(30);
829: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
830: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 829: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

825: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
826: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
827:
828: l_usertype Varchar2(30);
829: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
830: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
831: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
832:
833: CURSOR c_get_recepient_name(p_party_id number) IS

Line 830: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

826: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
827:
828: l_usertype Varchar2(30);
829: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
830: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
831: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
832:
833: CURSOR c_get_recepient_name(p_party_id number) IS
834: SELECT person_first_name, person_last_name

Line 831: l_partyid HZ_PARTIES.PARTY_ID%TYPE;

827:
828: l_usertype Varchar2(30);
829: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
830: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
831: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
832:
833: CURSOR c_get_recepient_name(p_party_id number) IS
834: SELECT person_first_name, person_last_name
835: FROM hz_parties

Line 835: FROM hz_parties

831: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
832:
833: CURSOR c_get_recepient_name(p_party_id number) IS
834: SELECT person_first_name, person_last_name
835: FROM hz_parties
836: WHERE party_id = p_party_id;
837:
838: rec_get_recepient_name c_get_recepient_name%rowtype;
839:

Line 845: hz_parties p

841: SELECT p.person_first_name,
842: p.person_last_name,
843: p.party_id
844: FROM hz_relationships l,
845: hz_parties p
846: WHERE l.party_id = p_party_id
847: AND l.subject_id = p.party_id
848: AND l.subject_type = 'PERSON'
849: AND l.object_type = 'ORGANIZATION';

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

901: --modified by abhandar for 11.5.10
902: --Modification : If party_type= person then
903: --retrieve name from the HZ_PARTY, else retrieve from the HZ_Relationship and HZ_Part tables .
904:
905: PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
906: p_user_type IN VARCHAR2,
907: p_sharee_number IN NUMBER := NULL,
908: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
909: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,

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

904:
905: PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
906: p_user_type IN VARCHAR2,
907: p_sharee_number IN NUMBER := NULL,
908: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
909: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
910: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
911:
912: l_usertype Varchar2(30);

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

905: PROCEDURE Get_Name_details(p_party_id IN HZ_PARTIES.PARTY_ID%TYPE,
906: p_user_type IN VARCHAR2,
907: p_sharee_number IN NUMBER := NULL,
908: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
909: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
910: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
911:
912: l_usertype Varchar2(30);
913: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

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

906: p_user_type IN VARCHAR2,
907: p_sharee_number IN NUMBER := NULL,
908: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
909: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
910: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
911:
912: l_usertype Varchar2(30);
913: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
914: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 913: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

909: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
910: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
911:
912: l_usertype Varchar2(30);
913: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
914: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
915: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
916: l_PartyType Varchar2(30);
917:

Line 914: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

910: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
911:
912: l_usertype Varchar2(30);
913: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
914: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
915: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
916: l_PartyType Varchar2(30);
917:
918:

Line 915: l_partyid HZ_PARTIES.PARTY_ID%TYPE;

911:
912: l_usertype Varchar2(30);
913: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
914: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
915: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
916: l_PartyType Varchar2(30);
917:
918:
919: CURSOR c_get_party_type_and_name (p_party_id number) IS

Line 921: FROM hz_parties

917:
918:
919: CURSOR c_get_party_type_and_name (p_party_id number) IS
920: SELECT party_type, person_first_name, person_last_name,party_id
921: FROM hz_parties
922: WHERE party_id = p_party_id;
923:
924: rec_get_recipient_name c_get_party_type_and_name%rowtype;
925:

Line 931: hz_parties p

927: SELECT p.person_first_name,
928: p.person_last_name,
929: p.party_id
930: FROM hz_relationships l,
931: hz_parties p
932: WHERE l.party_id = p_party_id
933: AND l.subject_id = p.party_id
934: AND l.subject_type = 'PERSON'
935: AND l.object_type = 'ORGANIZATION';

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

1353: and rownum= 1 and application_id=671;
1354:
1355: Cursor C_get_org_num(c_party_id NUMBER) IS
1356: select b.party_number
1357: from hz_parties a,hz_parties b,hz_relationships c
1358: where a.party_id= c.party_id
1359: and b.party_id= c.object_id
1360: and c.subject_table_name = 'HZ_PARTIES'
1361: and c.object_table_name = 'HZ_PARTIES'

Line 1360: and c.subject_table_name = 'HZ_PARTIES'

1356: select b.party_number
1357: from hz_parties a,hz_parties b,hz_relationships c
1358: where a.party_id= c.party_id
1359: and b.party_id= c.object_id
1360: and c.subject_table_name = 'HZ_PARTIES'
1361: and c.object_table_name = 'HZ_PARTIES'
1362: and c.directional_flag = 'F'
1363: and a.party_id=c_party_id;
1364:

Line 1361: and c.object_table_name = 'HZ_PARTIES'

1357: from hz_parties a,hz_parties b,hz_relationships c
1358: where a.party_id= c.party_id
1359: and b.party_id= c.object_id
1360: and c.subject_table_name = 'HZ_PARTIES'
1361: and c.object_table_name = 'HZ_PARTIES'
1362: and c.directional_flag = 'F'
1363: and a.party_id=c_party_id;
1364:
1365: -- end-ab

Line 2652: hz_parties p

2648: o.sold_to_contact_id
2649: from oe_order_headers_all o,
2650: hz_cust_Account_roles r,
2651: hz_relationships l,
2652: hz_parties p
2653: where o.header_id = c_order_id
2654: and o.sold_to_contact_id = r.cust_account_role_id
2655: and r.party_id = l.party_id
2656: and l.subject_id = p.party_id

Line 2669: hz_parties p

2665: p.person_middle_name
2666:
2667: from hz_cust_accounts a,
2668: oe_order_headers_all o,
2669: hz_parties p
2670: where o.sold_to_org_id = a.cust_account_id
2671: and a.party_id = p.party_id
2672: and o.header_id = c_order_id;
2673:

Line 2681: from hz_parties p,

2677: o.last_updated_by ,
2678: p.person_first_name ,
2679: p.person_middle_name,
2680: p.person_last_name
2681: from hz_parties p,
2682: oe_order_headers_all o,
2683: fnd_user f,
2684: hz_relationships r
2685: where o.last_updated_by = f.user_id

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

2732: ----DBMS_OUTPUT.PUT('Party type is: '||l_party_type);
2733: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2734: IBE_UTIL.debug('L_party_type in get_contact_details_for_order: '||l_party_type);
2735: END IF;
2736: IF (l_party_type = 'PERSON') then --B2C user, get the details directly from hz_parties
2737: x_contact_party_id := rec_b2c_contact.party_id;
2738: x_contact_first_name := rec_b2c_contact.person_first_name;
2739: x_contact_mid_name := rec_b2c_contact.person_middle_name;
2740: x_contact_last_name := rec_b2c_contact.person_last_name;

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

4574:
4575: END Get_Speciality_Store_name;*/
4576:
4577: /********************************************************
4578: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES
4579: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be
4580: sent to ad-hoc users, otherwise they will be sent to users who will be identified by their party_id
4581: in the HZ_PARTIES table
4582: *********************************************************/

Line 4581: in the HZ_PARTIES table

4577: /********************************************************
4578: This API is tyo determine if the contact point is saved against IBE_SH_QUOTE_ACCESS or HZ_PARTIES
4579: If the contact point is saved against IBE_SH_QUOTE_ACCESS then notifications will only be
4580: sent to ad-hoc users, otherwise they will be sent to users who will be identified by their party_id
4581: in the HZ_PARTIES table
4582: *********************************************************/
4583: procedure locate_contact_point
4584: ( p_contact_point_id IN NUMBER ,
4585: x_create_adhoc_flag OUT NOCOPY VARCHAR2 ) is

Line 4639: l_partyid HZ_PARTIES.PARTY_ID%TYPE;

4635: l_notif_context VARCHAR2(2000);
4636: l_Orgid Number := null;
4637: l_messageName WF_MESSAGES.NAME%TYPE;
4638: l_msgEnabled VARCHAR2(3);
4639: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
4640: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4641: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4642: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4643: l_user_name WF_USERS.NAME%TYPE;

Line 4640: x_partyid HZ_PARTIES.PARTY_ID%TYPE;

4636: l_Orgid Number := null;
4637: l_messageName WF_MESSAGES.NAME%TYPE;
4638: l_msgEnabled VARCHAR2(3);
4639: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
4640: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4641: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4642: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4643: l_user_name WF_USERS.NAME%TYPE;
4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;

Line 4652: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4651: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4652: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4653: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4654: l_recip_name Varchar2(2000);
4655:
4656: CURSOR c_msite_name(p_msite number) IS

Line 4653: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4651: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4652: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4653: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4654: l_recip_name Varchar2(2000);
4655:
4656: CURSOR c_msite_name(p_msite number) IS
4657: SELECT msite_name

Line 4850: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

4846: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4848: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4849:
4850: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4851: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4852: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4853: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4854:

Line 4851: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4848: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4849:
4850: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4851: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4852: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4853: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4854:
4855: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 4852: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

4848: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4849:
4850: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4851: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4852: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4853: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4854:
4855: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4856: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 4853: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;

4849:
4850: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4851: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4852: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4853: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4854:
4855: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4856: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4857: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 4855: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

4851: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4852: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4853: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4854:
4855: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4856: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4857: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
4858:
4859: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 4856: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

4852: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
4853: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4854:
4855: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4856: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4857: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
4858:
4859: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
4860:

Line 4857: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

4853: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
4854:
4855: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4856: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4857: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
4858:
4859: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
4860:
4861: l_role_users Varchar2(200);

Line 5085: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

5081: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5083: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5084:
5085: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5086: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5087: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5088: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5089:

Line 5086: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5083: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5084:
5085: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5086: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5087: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5088: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5089:
5090: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 5087: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

5083: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5084:
5085: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5086: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5087: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5088: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5089:
5090: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5091: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5088: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;

5084:
5085: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5086: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5087: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5088: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5089:
5090: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5091: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5092: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 5090: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

5086: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5087: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5088: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5089:
5090: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5091: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5092: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5093: l_accesslevel VARCHAR2(60);
5094:

Line 5091: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

5087: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5088: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5089:
5090: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5091: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5092: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5093: l_accesslevel VARCHAR2(60);
5094:
5095: l_role_users Varchar2(400);

Line 5092: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

5088: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5089:
5090: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5091: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5092: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5093: l_accesslevel VARCHAR2(60);
5094:
5095: l_role_users Varchar2(400);
5096: l_adhoc_role WF_ROLES.NAME%TYPE;

Line 5339: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

5335: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5337: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5338:
5339: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5340: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5341: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5342: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5343:

Line 5340: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5337: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5338:
5339: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5340: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5341: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5342: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5343:
5344: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 5341: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;

5337: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5338:
5339: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5340: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5341: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5342: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5343:
5344: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5345: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5342: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;

5338:
5339: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5340: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5341: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5342: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5343:
5344: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5345: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5346: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

Line 5344: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

5340: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5341: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5342: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5343:
5344: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5345: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5346: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5347:
5348: l_new_access_level VARCHAR2(60);

Line 5345: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

5341: l_owner_partyid HZ_PARTIES.PARTY_ID%TYPE;
5342: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5343:
5344: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5345: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5346: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5347:
5348: l_new_access_level VARCHAR2(60);
5349: l_old_access_level VARCHAR2(60);

Line 5346: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;

5342: x_owner_new_party_id HZ_PARTIES.PARTY_ID%TYPE;
5343:
5344: l_recepient_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5345: l_recepient_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
5346: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5347:
5348: l_new_access_level VARCHAR2(60);
5349: l_old_access_level VARCHAR2(60);
5350:

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

5411: x_party_id => x_owner_new_party_id);
5412:
5413: -- Now identify whether the recepient is B2B or B2C ****
5414: -- Call the Get_Name_details to get the party_id of the recepient.
5415: -- And pipe it with HZ_PARTIES to get email id of the recepient.
5416:
5417: l_usertype := FND_API.G_MISS_CHAR;
5418: x_recepient_party_id := 0;
5419: Get_Name_details(p_party_id => l_quote_access_rec.party_id,

Line 6266: l_party_first_name hz_parties.person_first_name%TYPE;

6262: l_item_key wf_items.item_key%TYPE;
6263: l_quote_id NUMBER;
6264: l_event_type VARCHAR2(20);
6265: l_document VARCHAR2(32000) := '';
6266: l_party_first_name hz_parties.person_first_name%TYPE;
6267: l_party_last_name hz_parties.person_last_name%TYPE;
6268: l_temp_str VARCHAR2(2000):='';
6269: l_errmsg_data VARCHAR2(2000):='';
6270: l_order_id NUMBER;

Line 6267: l_party_last_name hz_parties.person_last_name%TYPE;

6263: l_quote_id NUMBER;
6264: l_event_type VARCHAR2(20);
6265: l_document VARCHAR2(32000) := '';
6266: l_party_first_name hz_parties.person_first_name%TYPE;
6267: l_party_last_name hz_parties.person_last_name%TYPE;
6268: l_temp_str VARCHAR2(2000):='';
6269: l_errmsg_data VARCHAR2(2000):='';
6270: l_order_id NUMBER;
6271: l_Ship_Method Varchar2(80);

Line 6505: l_party_first_name hz_parties.person_first_name%TYPE;

6501: l_item_key wf_items.item_key%TYPE;
6502: l_quote_id NUMBER;
6503: l_event_type VARCHAR2(20);
6504: l_comments VARCHAR2(2000);
6505: l_party_first_name hz_parties.person_first_name%TYPE;
6506: l_party_last_name hz_parties.person_last_name%TYPE;
6507: l_contact_party_id hz_parties.party_id%TYPE;
6508: l_contact_name VARCHAR2(400);
6509: l_contact_number VARCHAR2(70);

Line 6506: l_party_last_name hz_parties.person_last_name%TYPE;

6502: l_quote_id NUMBER;
6503: l_event_type VARCHAR2(20);
6504: l_comments VARCHAR2(2000);
6505: l_party_first_name hz_parties.person_first_name%TYPE;
6506: l_party_last_name hz_parties.person_last_name%TYPE;
6507: l_contact_party_id hz_parties.party_id%TYPE;
6508: l_contact_name VARCHAR2(400);
6509: l_contact_number VARCHAR2(70);
6510: l_contact_email hz_contact_points.email_address%TYPE;

Line 6507: l_contact_party_id hz_parties.party_id%TYPE;

6503: l_event_type VARCHAR2(20);
6504: l_comments VARCHAR2(2000);
6505: l_party_first_name hz_parties.person_first_name%TYPE;
6506: l_party_last_name hz_parties.person_last_name%TYPE;
6507: l_contact_party_id hz_parties.party_id%TYPE;
6508: l_contact_name VARCHAR2(400);
6509: l_contact_number VARCHAR2(70);
6510: l_contact_email hz_contact_points.email_address%TYPE;
6511: l_contact_fax VARCHAR2(70);

Line 6529: hz_parties p

6525: p.party_type
6526: from oe_order_headers_all o,
6527: hz_cust_Account_roles r,
6528: hz_relationships l,
6529: hz_parties p
6530: where o.header_id = pOrder
6531: and o.sold_to_contact_id = r.cust_account_role_id
6532: and r.party_id = l.party_id
6533: and l.subject_id = p.party_id

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

6584: l_party_first_name := null;
6585: l_party_last_name := null;
6586: l_contact_name := null;
6587:
6588: FOR c_hz_parties_rec IN c_hz_parties(g_header_rec.party_id) LOOP
6589: If c_hz_parties_rec.Party_type = 'ORGANIZATION' Then
6590: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
6591: l_party_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
6592: l_party_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));

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

6585: l_party_last_name := null;
6586: l_contact_name := null;
6587:
6588: FOR c_hz_parties_rec IN c_hz_parties(g_header_rec.party_id) LOOP
6589: If c_hz_parties_rec.Party_type = 'ORGANIZATION' Then
6590: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
6591: l_party_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
6592: l_party_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
6593: l_contact_name := l_party_first_name||' '||l_party_last_name;

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

6593: l_contact_name := l_party_first_name||' '||l_party_last_name;
6594: l_contact_party_id := c_b2b_contact_rec.contact_party_id;
6595: End Loop;
6596: Else
6597: l_party_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));
6598: l_party_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));
6599: l_contact_name := l_party_first_name||' '||l_party_last_name;
6600: l_contact_party_id := g_header_rec.party_id;
6601: End If;

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

6594: l_contact_party_id := c_b2b_contact_rec.contact_party_id;
6595: End Loop;
6596: Else
6597: l_party_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));
6598: l_party_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));
6599: l_contact_name := l_party_first_name||' '||l_party_last_name;
6600: l_contact_party_id := g_header_rec.party_id;
6601: End If;
6602: END LOOP;

Line 8533: l_bill_to_party_name hz_parties.party_name%TYPE;

8529: l_comments VARCHAR2(2000);
8530: l_contact_name VARCHAR2(400);
8531: l_contact_number VARCHAR2(70);
8532: l_contact_email hz_contact_points.email_address%TYPE;
8533: l_bill_to_party_name hz_parties.party_name%TYPE;
8534: l_bill_to_name VARCHAR2(400);
8535: l_bill_to_number VARCHAR2(70);
8536: l_bill_to_fax VARCHAR2(70);
8537: l_bill_to_address hz_locations.address1%TYPE;

Line 8549: l_ship_to_party_name hz_parties.party_name%TYPE;

8545: l_ship_method_code aso_shipments.ship_method_code%TYPE;
8546:
8547: l_ship_method varchar2(80);
8548:
8549: l_ship_to_party_name hz_parties.party_name%TYPE;
8550: l_ship_to_name VARCHAR2(400);
8551: l_ship_to_number VARCHAR2(70);
8552: l_ship_to_fax VARCHAR2(70);
8553: l_ship_to_address hz_locations.address1%TYPE;

Line 8581: FROM hz_cust_accounts hc, hz_parties hp

8577:
8578:
8579: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
8580: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
8581: FROM hz_cust_accounts hc, hz_parties hp
8582: WHERE cust_account_id = p_cust_account_id
8583: AND hc.party_id = hp.party_id;
8584:
8585: l_sold_contact_party_id Number;

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

8636:
8637: l_contact_name := null;
8638: l_sold_contact_party_id := null;
8639:
8640: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
8641: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8642: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
8643:
8644: l_sold_contact_party_id := g_quote_header_rec.party_id;

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

8637: l_contact_name := null;
8638: l_sold_contact_party_id := null;
8639:
8640: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
8641: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8642: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
8643:
8644: l_sold_contact_party_id := g_quote_header_rec.party_id;
8645: End If;

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

8638: l_sold_contact_party_id := null;
8639:
8640: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.party_id) LOOP
8641: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8642: l_contact_name := upper(rtrim(c_hz_parties_rec.person_first_name))||' '||upper(rtrim(c_hz_parties_rec.person_last_name));
8643:
8644: l_sold_contact_party_id := g_quote_header_rec.party_id;
8645: End If;
8646: END LOOP;

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

8704:
8705: /* Bill Contact Info. From Invoice_To_Party_ID (PARTY_RELATIONSHIP) OR Bill Customer Party Id. */
8706:
8707: If g_quote_header_rec.invoice_to_party_id is not null Then
8708: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id) LOOP
8709: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8710: l_bill_contact_party_id := g_quote_header_rec.party_id;
8711: End If;
8712: END LOOP;

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

8705: /* Bill Contact Info. From Invoice_To_Party_ID (PARTY_RELATIONSHIP) OR Bill Customer Party Id. */
8706:
8707: If g_quote_header_rec.invoice_to_party_id is not null Then
8708: FOR c_hz_parties_rec IN c_hz_parties(g_quote_header_rec.invoice_to_party_id) LOOP
8709: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8710: l_bill_contact_party_id := g_quote_header_rec.party_id;
8711: End If;
8712: END LOOP;
8713: End if;

Line 8800: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP

8796: END IF;
8797:
8798: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
8799: If l_ship_to_party_id is not null Then
8800: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP
8801: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8802: l_ship_contact_party_id := g_quote_header_rec.party_id;
8803: End If;
8804: END LOOP;

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

8797:
8798: /* Shipping Contact ship_to_party_id(PARTY_REALTIONSHIP) OR Ship Customer's Party Id */
8799: If l_ship_to_party_id is not null Then
8800: FOR c_hz_parties_rec IN c_hz_parties(l_ship_to_party_id) LOOP
8801: If c_hz_parties_rec.party_type = 'PARTY_RELATIONSHIP' Then
8802: l_ship_contact_party_id := g_quote_header_rec.party_id;
8803: End If;
8804: END LOOP;
8805: End If;

Line 9528: hz_parties p

9524: p.party_type
9525: from oe_order_headers_all o,
9526: hz_cust_Account_roles r,
9527: hz_relationships l,
9528: hz_parties p
9529: where o.header_id = c_order_id
9530: and o.sold_to_contact_id = r.cust_account_role_id
9531: and r.party_id = l.party_id
9532: and l.subject_id = p.party_id

Line 9543: hz_parties p

9539: p.person_last_name,
9540: p.person_title,
9541: p.party_type
9542: from hz_relationships l,
9543: hz_parties p
9544: where l.party_id = pPartyId
9545: and l.subject_id = p.party_id
9546: and l.subject_type = 'PERSON'
9547: and l.object_type = 'ORGANIZATION';

Line 9557: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9553: l_party_id := c_quote_rec.party_id;
9554: l_order_id := c_quote_rec.order_id;
9555: END LOOP;
9556:
9557: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9558: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9559: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9560: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9561: End Loop;

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

9554: l_order_id := c_quote_rec.order_id;
9555: END LOOP;
9556:
9557: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9558: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9559: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9560: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9561: End Loop;
9562: Else

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

9559: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9560: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9561: End Loop;
9562: Else
9563: l_first_name := upper(rtrim(c_hz_parties_rec.person_first_name));
9564: End If;
9565: END LOOP;
9566:
9567: --bug 2299210

Line 9569: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9565: END LOOP;
9566:
9567: --bug 2299210
9568: IF l_first_name IS NULL THEN
9569: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9570: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9571: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9572: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9573: END LOOP;

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

9566:
9567: --bug 2299210
9568: IF l_first_name IS NULL THEN
9569: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9570: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9571: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9572: l_first_name := upper(rtrim(c_b2b_contact_rec.person_first_name));
9573: END LOOP;
9574: END IF;

Line 9608: hz_parties p

9604: p.party_type
9605: from oe_order_headers_all o,
9606: hz_cust_Account_roles r,
9607: hz_relationships l,
9608: hz_parties p
9609: where o.header_id = c_Order_id
9610: and o.sold_to_contact_id = r.cust_account_role_id
9611: and r.party_id = l.party_id
9612: and l.subject_id = p.party_id

Line 9623: hz_parties p

9619: p.person_last_name,
9620: p.person_title,
9621: p.party_type
9622: from hz_relationships l,
9623: hz_parties p
9624: where l.party_id = pPartyId
9625: and l.subject_id = p.party_id
9626: and l.subject_type = 'PERSON'
9627: and l.object_type = 'ORGANIZATION';

Line 9637: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9633: l_party_id := c_quote_rec.party_id;
9634: l_order_id := c_quote_rec.order_id;
9635: END LOOP;
9636:
9637: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9638: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9639: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9640: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9641: End Loop;

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

9634: l_order_id := c_quote_rec.order_id;
9635: END LOOP;
9636:
9637: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9638: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9639: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9640: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9641: End Loop;
9642: Else

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

9639: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9640: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9641: End Loop;
9642: Else
9643: l_last_name := upper(rtrim(c_hz_parties_rec.person_last_name));
9644: End If;
9645: END LOOP;
9646:
9647: --bug 2299210

Line 9649: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9645: END LOOP;
9646:
9647: --bug 2299210
9648: IF l_last_name IS NULL THEN
9649: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9650: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9651: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9652: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9653: END LOOP;

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

9646:
9647: --bug 2299210
9648: IF l_last_name IS NULL THEN
9649: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9650: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9651: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9652: l_last_name := upper(rtrim(c_b2b_contact_rec.person_last_name));
9653: END LOOP;
9654: END IF;

Line 9678: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;

9674: ) IS
9675:
9676: l_party_id number;
9677: l_order_id number;
9678: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;
9679:
9680: Cursor c_b2b_contact(c_Order_id Number) IS
9681: Select p.party_id Person_Party_id,
9682: l.party_id contact_party_id,

Line 9690: hz_parties p

9686: p.person_title
9687: from oe_order_headers_all o,
9688: hz_cust_Account_roles r,
9689: hz_relationships l,
9690: hz_parties p
9691: where o.header_id = c_order_id
9692: and o.sold_to_contact_id = r.cust_account_role_id
9693: and r.party_id = l.party_id
9694: and l.subject_id = p.party_id

Line 9705: hz_parties p

9701: p.person_last_name,
9702: p.person_title,
9703: p.party_type
9704: from hz_relationships l,
9705: hz_parties p
9706: where l.party_id = pPartyId
9707: and l.subject_id = p.party_id
9708: and l.subject_type = 'PERSON'
9709: and l.object_type = 'ORGANIZATION';

Line 9719: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9715: l_party_id := c_quote_rec.party_id;
9716: l_order_id := c_quote_rec.order_id;
9717: END LOOP;
9718:
9719: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9720: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9721: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9722: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9723: End Loop;

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

9716: l_order_id := c_quote_rec.order_id;
9717: END LOOP;
9718:
9719: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9720: If c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' Then
9721: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9722: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9723: End Loop;
9724: Else

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

9721: For c_b2b_contact_rec in c_b2b_contact(l_order_id) Loop
9722: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9723: End Loop;
9724: Else
9725: l_person_title := upper(rtrim(c_hz_parties_rec.person_title));
9726: End If;
9727: END LOOP;
9728:
9729: --bug 2299210

Line 9731: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP

9727: END LOOP;
9728:
9729: --bug 2299210
9730: IF l_person_title IS NULL THEN
9731: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9732: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9733: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9734: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9735: END LOOP;

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

9728:
9729: --bug 2299210
9730: IF l_person_title IS NULL THEN
9731: FOR c_hz_parties_rec IN c_hz_parties(l_party_id) LOOP
9732: IF c_hz_parties_rec.Party_type = 'PARTY_RELATIONSHIP' THEN
9733: FOR c_b2b_contact_rec in c_b2b_contact_new(l_party_id) LOOP
9734: l_person_title := upper(rtrim(c_b2b_contact_rec.person_title));
9735: END LOOP;
9736: END IF;