[Home] [Help]
PACKAGE: APPS.ASO_CHECK_TCA_PVT
Source
1 PACKAGE ASO_CHECK_TCA_PVT AUTHID CURRENT_USER as
2 /* $Header: asovctcs.pls 120.4 2005/10/17 15:23:44 vtariker ship $ */
3 -- Package name : ASO_CHECK_TCA_PVT
4 -- Purpose :
5 -- History :
6 -- NOTE :
7 -- End of Comments
8
9 PROCEDURE check_tca(
10 p_api_version IN NUMBER,
11 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
12 P_Qte_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
13 P_Header_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
14 /* := ASO_QUOTE_PUB.G_MISS_shipment_TBL, */
15 P_Operation_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
16 p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
17 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
18 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
19 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 );
21
22
23 PROCEDURE check_header_account_info(
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
26 p_cust_account_id IN NUMBER,
27 P_Qte_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
28 /* := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC, */
29 P_Header_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
30 /* := ASO_QUOTE_PUB.G_MISS_shipment_TBL,*/
31 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
32 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
33 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
34
35 PROCEDURE check_line_account_info(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
38 p_cust_account_id IN NUMBER,
39 P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
40 /*:= ASO_QUOTE_PUB.G_MISS_qte_line_REC, */
41 P_Line_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
42 /*:= ASO_QUOTE_PUB.G_MISS_shipment_TBL,*/
43 p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
44 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
45 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
46 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
47
48
49 PROCEDURE Customer_Account(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
52 p_commit IN VARCHAR2 := FND_API.g_false,
53 p_Party_Id IN NUMBER,
54 p_error_ret IN VARCHAR2 := FND_API.G_TRUE,
55 p_calling_api_flag IN NUMBER := 0,
56 x_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
57 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
59 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
60
61
62 PROCEDURE Customer_Account_Site(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65 p_commit IN VARCHAR2 := FND_API.g_false,
66 p_party_site_id IN NUMBER,
67 p_acct_site_type IN VARCHAR2,
68 p_cust_account_id IN NUMBER,
69 x_cust_acct_site_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
70 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
71 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
72 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
73 x_site_use_id OUT NOCOPY /* file.sql.39 change */ NUMBER);
74
75
76 PROCEDURE Cust_Acct_Relationship(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
79 p_commit IN VARCHAR2 := FND_API.g_false,
80 p_sold_to_cust_account IN NUMBER,
81 p_related_cust_account IN NUMBER,
82 p_relationship_type IN VARCHAR2,
83 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
84 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
85 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
86
87
88 PROCEDURE Cust_Acct_Contact_Addr(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
91 p_commit IN VARCHAR2 := FND_API.g_false,
92 p_party_site_id IN NUMBER,
93 p_role_type IN VARCHAR2,
94 p_cust_account_id IN NUMBER,
95 p_party_id IN NUMBER,
96 p_cust_account_site IN NUMBER,
97 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
98 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
99 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
100 x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ number);
101
102
103 PROCEDURE Assign_Customer_Accounts(
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105 p_qte_header_id IN NUMBER,
106 p_calling_api_flag IN NUMBER := 0,
107 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
108 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
109 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
110
111
112 PROCEDURE Populate_Acct_Party (
113 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114 p_hdr_cust_acct_id IN NUMBER,
115 p_hdr_party_id IN NUMBER,
116 p_party_site_id IN NUMBER,
117 p_cust_account_id IN OUT NOCOPY NUMBER,
118 p_cust_party_id IN OUT NOCOPY NUMBER,
119 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
120 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
121 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
122
123
124 PROCEDURE Check_Customer_Accounts(
125 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126 p_qte_header_id IN NUMBER,
127 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
128 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
129 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
130
131
132 END ASO_CHECK_TCA_PVT;