[Home] [Help]
148: -- P_location_id IN Location id.
149: -- P_location_code IN Location Code.
150: -- OUT:
151: -- x_party_site_id OUT NOCOPY Party Site Id.
152: -- x_return_status OUT NOCOPY Standard to output api status.
153: -- End of comments
154: PROCEDURE Create_HZ_Party_Site(
155: P_party_id IN NUMBER,
156: P_location_id IN NUMBER,
566: CLOSE get_code_assignments;
567:
568: IF (l_tmp IS NULL ) THEN
569: --No code assignment exists, create for party.
570: --These input values are standard for Vendor and Party as define
571: --by PO receiving team.
572: l_code_assignment_rec.owner_table_name := 'HZ_PARTIES';
573: l_code_assignment_rec.owner_table_id := l_party_id;
574: l_code_assignment_rec.class_category := 'POS_CLASSIFICATION';
669: -- P_Province IN Province.
670: -- P_county IN County.
671: -- p_country IN Country.
672: -- OUT:
673: -- x_return_status OUT NOCOPY Standard to output api status.
674: -- End of comments
675: PROCEDURE Update_Hz_Location(
676: P_location_id IN number,
677: P_address1 IN varchar2,
824: -- p_country IN Country.
825: -- OUT:
826: -- x_location_id OUT NOCOPY Location Id created.
827: -- x_party_site_id OUT NOCOPY Party Site Id created.
828: -- x_return_status OUT NOCOPY Standard to output api status.
829: -- End of comments
830: PROCEDURE Create_Hz_Location_Party_Site(
831: P_party_id IN number,
832: P_location_code IN varchar2,
1127: -- P_supplier_name IN Supplier Name.
1128: -- OUT:
1129: -- x_vendor_id vendor id.
1130: -- x_party_id Party Id.
1131: -- x_return_status Standard to output api status.
1132: -- End of comments
1133: PROCEDURE Validate_Supplier(
1134: p_in_param IN WSH_ROUTING_REQUEST.In_param_Rec_Type,
1135: P_supplier_name IN varchar2,
1239: -- IN:
1240: -- P_party_site_id IN Party Site Id.
1241: -- P_site_use_type IN Site uses type.
1242: -- OUT:
1243: -- x_return_status OUT NOCOPY Standard to output api status.
1244: -- End of comments
1245: FUNCTION Check_Hz_Party_site_Uses(
1246: P_party_site_id IN NUMBER,
1247: P_site_use_type IN VARCHAR2,
1321: -- P_party_site_id IN Party Site Id.
1322: -- P_site_use_type IN Site uses type.
1323: -- OUT:
1324: -- x_party_site_use_id OUT NOCOPY Party site use Id created.
1325: -- x_return_status OUT NOCOPY Standard to output api status.
1326: -- End of comments
1327: PROCEDURE Create_HZ_Party_Site_uses(
1328: P_party_site_id IN NUMBER,
1329: P_site_use_type IN VARCHAR2,
1442: -- Parameters :
1443: -- IN:
1444: -- P_phone IN Phone Number.
1445: -- OUT:
1446: -- x_return_status OUT NOCOPY Standard to output api status.
1447: -- End of comments
1448: PROCEDURE Create_hz_phone_contact(
1449: P_phone IN VARCHAR2,
1450: p_owner_table_id IN NUMBER,
1569: -- P_phone IN Phone Number.
1570: -- P_email_contact_point_id IN Email Contact point id.
1571: -- P_email IN Email.
1572: -- OUT:
1573: -- x_return_status OUT NOCOPY Standard to output api status.
1574: -- End of comments
1575: PROCEDURE Update_HZ_contact(
1576: P_person_id IN NUMBER,
1577: P_person_name IN VARCHAR2,
1849: -- P_person_name IN Person Name.
1850: -- P_phone IN Phone Number.
1851: -- P_email IN Email.
1852: -- OUT:
1853: -- x_return_status OUT NOCOPY Standard to output api status.
1854: -- End of comments
1855: PROCEDURE Create_HZ_contact(
1856: P_PARTY_ID IN NUMBER,
1857: P_PARTY_SITE_ID IN NUMBER,
2079: -- P_person_name IN Person Name.
2080: -- P_phone IN Phone Number.
2081: -- P_email IN Email.
2082: -- OUT:
2083: -- x_return_status OUT NOCOPY Standard to output api status.
2084: -- End of comments
2085: PROCEDURE Process_HZ_contact(
2086: P_PARTY_ID IN NUMBER,
2087: P_PARTY_SITE_ID IN NUMBER,
2342: -- p_shipper_name IN Shipper Name
2343: -- p_phone IN Phone Number.
2344: -- p_email IN Email Address.
2345: -- OUT:
2346: -- x_return_status OUT NOCOPY Standard to output api status.
2347: -- End of comments
2348: PROCEDURE Update_Address(
2349: P_location_id IN number,
2350: P_party_id IN number,
2519: -- p_email IN Email Address.
2520: -- OUT:
2521: -- x_location_id OUT NOCOPY Location id create.
2522: -- x_party_site_id OUT NOCOPY Party Site id created.
2523: -- x_return_status OUT NOCOPY OUT NOCOPY Standard to output api status.
2524: -- End of comments
2525: PROCEDURE Create_Address(
2526: P_vendor_id IN number,
2527: P_party_id IN number,
2784: -- p_Address IN Hold Supplier Address book record as passed by UI
2785: -- OUT:
2786: -- x_success_tbl OUT NOCOPY List of Success messages passed back to UI for display.
2787: -- x_error_tbl OUT NOCOPY List of Error messages passed back to UI for display.
2788: -- x_return_status OUT NOCOPY Standard to output api status.
2789: -- End of comments
2790: PROCEDURE Process_Address(
2791: p_in_param IN WSH_ROUTING_REQUEST.In_param_Rec_Type,
2792: p_Address IN WSH_ROUTING_REQUEST.Address_rec_type,