1 PACKAGE PO_CUSTOMERS_SV as
2 /* $Header: POXRQCUS.pls 120.1 2006/02/14 12:24:59 dreddy noship $ */
3 /*===========================================================================
4 PACKAGE NAME: po_customers_sv
5
6 DESCRIPTION: Contains all server side procedures that
7 access po_location_associations entity.
8
9 CLIENT/SERVER: Server
10
11 OWNER: RMULPURTY
12
13 PROCEDURE NAMES: get_cust_details()
14 val_cust_details()
15 ===========================================================================*/
16
17 /*===========================================================================
18 PROCEDURE NAME: get_cust_details
19
20 DESCRIPTION: Obtain the customer details associated with
21 a destination location
22 Bug 5028505: Added source org parameter
23
24 PARAMETERS: x_deliver_to_location_id IN NUMBER
25 x_customer_id IN OUT NUMBER
26 x_address_id IN OUT NUMBER
27 x_site_use_id IN OUT NUMBER
28 x_source_org_id IN OUT NUMBER
29
30 DESIGN REFERENCES: POXRQERQ.doc
31
32 ALGORITHM:
33
34 NOTES:
35
36 OPEN ISSUES:
37
38 CLOSED ISSUES:
39
40 CHANGE HISTORY:
41 ===========================================================================*/
42
43 PROCEDURE get_cust_details(x_deliver_to_location_id IN NUMBER,
44 x_customer_id IN OUT NOCOPY NUMBER,
45 x_address_id IN OUT NOCOPY NUMBER,
46 x_site_use_id IN OUT NOCOPY NUMBER,
47 x_source_org_id IN NUMBER DEFAULT NULL);
48
49
50 END po_customers_sv;