13: -- then get the first "valid" address (SHIP_TO or any other site-use-type)
14:
15: PROCEDURE GetPartySiteId(
16: p_api_version_number IN NUMBER := 1,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_party_id IN NUMBER,
20: p_site_use_type IN VARCHAR2,
21: x_party_site_id OUT NOCOPY NUMBER,
14:
15: PROCEDURE GetPartySiteId(
16: p_api_version_number IN NUMBER := 1,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_party_id IN NUMBER,
20: p_site_use_type IN VARCHAR2,
21: x_party_site_id OUT NOCOPY NUMBER,
22: x_return_status OUT NOCOPY VARCHAR2,
25:
26: /*
27: PROCEDURE Create_Party_Site_Use(
28: p_api_version_number IN NUMBER := 1,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_party_site_id IN NUMBER,
32: p_party_site_use_type IN VARCHAR2,
33: x_party_site_use_id OUT NOCOPY NUMBER,
26: /*
27: PROCEDURE Create_Party_Site_Use(
28: p_api_version_number IN NUMBER := 1,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_party_site_id IN NUMBER,
32: p_party_site_use_type IN VARCHAR2,
33: x_party_site_use_id OUT NOCOPY NUMBER,
34: x_return_status OUT NOCOPY VARCHAR2,
37: */
38:
39: PROCEDURE create_cust_account_role(
40: p_api_version_number IN NUMBER := 1,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_party_id IN NUMBER,
44: p_cust_acct_id IN NUMBER,
45: p_cust_acct_site_id IN NUMBER,
38:
39: PROCEDURE create_cust_account_role(
40: p_api_version_number IN NUMBER := 1,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_party_id IN NUMBER,
44: p_cust_acct_id IN NUMBER,
45: p_cust_acct_site_id IN NUMBER,
46: p_role_type IN VARCHAR2,
51:
52:
53: PROCEDURE Create_Cust_Acct_Site(
54: p_api_version_number IN NUMBER := 1
55: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
56: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
57: ,p_partysite_id IN NUMBER
58: ,p_custacct_id IN NUMBER
59: ,p_custacct_type IN VARCHAR2
52:
53: PROCEDURE Create_Cust_Acct_Site(
54: p_api_version_number IN NUMBER := 1
55: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
56: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
57: ,p_partysite_id IN NUMBER
58: ,p_custacct_id IN NUMBER
59: ,p_custacct_type IN VARCHAR2
60: ,x_custacct_site_id OUT NOCOPY NUMBER
65:
66:
67: PROCEDURE Create_Cust_Acct_Site_Use(
68: p_api_version_number IN NUMBER := 1
69: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
70: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
71: ,p_cust_account_Id IN NUMBER
72: ,p_party_site_Id IN NUMBER
73: ,p_cust_acct_site_id IN NUMBER
66:
67: PROCEDURE Create_Cust_Acct_Site_Use(
68: p_api_version_number IN NUMBER := 1
69: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
70: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
71: ,p_cust_account_Id IN NUMBER
72: ,p_party_site_Id IN NUMBER
73: ,p_cust_acct_site_id IN NUMBER
74: ,p_acct_site_type IN VARCHAR2
83: -- for the Order.
84:
85: PROCEDURE Get_Cust_Account_Site_Use(
86: p_api_version_number IN NUMBER := 1
87: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
88: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
89: ,p_cust_acct_id IN NUMBER
90: ,p_party_id IN NUMBER
91: ,p_siteuse_type IN VARCHAR2
84:
85: PROCEDURE Get_Cust_Account_Site_Use(
86: p_api_version_number IN NUMBER := 1
87: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
88: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
89: ,p_cust_acct_id IN NUMBER
90: ,p_party_id IN NUMBER
91: ,p_siteuse_type IN VARCHAR2
92: ,p_partysite_id IN NUMBER := FND_API.G_MISS_NUM
88: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
89: ,p_cust_acct_id IN NUMBER
90: ,p_party_id IN NUMBER
91: ,p_siteuse_type IN VARCHAR2
92: ,p_partysite_id IN NUMBER := FND_API.G_MISS_NUM
93: ,x_siteuse_id OUT NOCOPY NUMBER
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER
96: ,x_msg_data OUT NOCOPY VARCHAR2);
102: -- invoice_to_contact_id would be maintained as null.
103:
104: PROCEDURE Get_Cust_Acct_Role(
105: p_api_version_number IN NUMBER := 1
106: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
107: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
108: ,p_party_id IN NUMBER
109: ,p_acctsite_type IN VARCHAR2
110: ,p_sold_to_orgid IN NUMBER
103:
104: PROCEDURE Get_Cust_Acct_Role(
105: p_api_version_number IN NUMBER := 1
106: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
107: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
108: ,p_party_id IN NUMBER
109: ,p_acctsite_type IN VARCHAR2
110: ,p_sold_to_orgid IN NUMBER
111: ,p_custacct_siteuse_id IN NUMBER := FND_API.G_MISS_NUM
107: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
108: ,p_party_id IN NUMBER
109: ,p_acctsite_type IN VARCHAR2
110: ,p_sold_to_orgid IN NUMBER
111: ,p_custacct_siteuse_id IN NUMBER := FND_API.G_MISS_NUM
112: ,x_cust_acct_role_id OUT NOCOPY NUMBER
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_count OUT NOCOPY NUMBER
115: ,x_msg_data OUT NOCOPY VARCHAR2);
120: -- IN parameters for this API.
121:
122: PROCEDURE GetCustomerAcctData(
123: p_api_version_number IN NUMBER := 1
124: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_invoice_to_org_id IN NUMBER := FND_API.G_MISS_NUM
127: ,p_invoice_to_contact_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_contact_party_id IN NUMBER := FND_API.G_MISS_NUM
121:
122: PROCEDURE GetCustomerAcctData(
123: p_api_version_number IN NUMBER := 1
124: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_invoice_to_org_id IN NUMBER := FND_API.G_MISS_NUM
127: ,p_invoice_to_contact_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_contact_party_id IN NUMBER := FND_API.G_MISS_NUM
129: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
122: PROCEDURE GetCustomerAcctData(
123: p_api_version_number IN NUMBER := 1
124: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_invoice_to_org_id IN NUMBER := FND_API.G_MISS_NUM
127: ,p_invoice_to_contact_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_contact_party_id IN NUMBER := FND_API.G_MISS_NUM
129: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
130: ,x_cust_account_id OUT NOCOPY NUMBER
123: p_api_version_number IN NUMBER := 1
124: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_invoice_to_org_id IN NUMBER := FND_API.G_MISS_NUM
127: ,p_invoice_to_contact_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_contact_party_id IN NUMBER := FND_API.G_MISS_NUM
129: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
130: ,x_cust_account_id OUT NOCOPY NUMBER
131: ,x_cust_party_name OUT NOCOPY VARCHAR2
124: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_invoice_to_org_id IN NUMBER := FND_API.G_MISS_NUM
127: ,p_invoice_to_contact_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_contact_party_id IN NUMBER := FND_API.G_MISS_NUM
129: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
130: ,x_cust_account_id OUT NOCOPY NUMBER
131: ,x_cust_party_name OUT NOCOPY VARCHAR2
132: ,x_cust_party_id OUT NOCOPY NUMBER
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_invoice_to_org_id IN NUMBER := FND_API.G_MISS_NUM
127: ,p_invoice_to_contact_id IN NUMBER := FND_API.G_MISS_NUM
128: ,p_contact_party_id IN NUMBER := FND_API.G_MISS_NUM
129: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
130: ,x_cust_account_id OUT NOCOPY NUMBER
131: ,x_cust_party_name OUT NOCOPY VARCHAR2
132: ,x_cust_party_id OUT NOCOPY NUMBER
133: ,x_cust_party_type OUT NOCOPY VARCHAR2