PACKAGE: APPS.CSI_T_PARTY_ACCOUNTS_PKG

Source

1 PACKAGE CSI_T_PARTY_ACCOUNTS_PKG AUTHID CURRENT_USER as
2 /* $Header: csittpas.pls 115.4 2002/11/12 00:24:55 rmamidip noship $ */
3 -- Package name     : CSI_T_PARTY_ACCOUNTS_PKG
4 -- Purpose          : Table Handler for csi_t_party_accounts
5 -- History          : brmanesh created 12-MAY-2001
6 -- NOTE             :
7 
8 PROCEDURE Insert_Row(
9           px_TXN_ACCOUNT_DETAIL_ID   IN OUT NOCOPY NUMBER,
10           p_TXN_PARTY_DETAIL_ID    NUMBER,
11           p_IP_ACCOUNT_ID    NUMBER,
12           p_ACCOUNT_ID    NUMBER,
13           p_RELATIONSHIP_TYPE_CODE    VARCHAR2,
14           p_BILL_TO_ADDRESS_ID    NUMBER,
15           p_SHIP_TO_ADDRESS_ID    NUMBER,
16           p_ACTIVE_START_DATE    DATE,
17           p_ACTIVE_END_DATE    DATE,
18           p_PRESERVE_DETAIL_FLAG    VARCHAR2,
19           p_ATTRIBUTE1    VARCHAR2,
20           p_ATTRIBUTE2    VARCHAR2,
21           p_ATTRIBUTE3    VARCHAR2,
22           p_ATTRIBUTE4    VARCHAR2,
23           p_ATTRIBUTE5    VARCHAR2,
24           p_ATTRIBUTE6    VARCHAR2,
25           p_ATTRIBUTE7    VARCHAR2,
26           p_ATTRIBUTE8    VARCHAR2,
27           p_ATTRIBUTE9    VARCHAR2,
28           p_ATTRIBUTE10    VARCHAR2,
29           p_ATTRIBUTE11    VARCHAR2,
30           p_ATTRIBUTE12    VARCHAR2,
31           p_ATTRIBUTE13    VARCHAR2,
32           p_ATTRIBUTE14    VARCHAR2,
33           p_ATTRIBUTE15    VARCHAR2,
34           p_CREATED_BY    NUMBER,
35           p_CREATION_DATE    DATE,
36           p_LAST_UPDATED_BY    NUMBER,
37           p_LAST_UPDATE_DATE    DATE,
38           p_LAST_UPDATE_LOGIN    NUMBER,
39           p_OBJECT_VERSION_NUMBER    NUMBER,
40           p_CONTEXT    VARCHAR2);
41 
42 PROCEDURE Update_Row(
43           p_TXN_ACCOUNT_DETAIL_ID    NUMBER,
44           p_TXN_PARTY_DETAIL_ID    NUMBER,
45           p_IP_ACCOUNT_ID    NUMBER,
46           p_ACCOUNT_ID    NUMBER,
47           p_RELATIONSHIP_TYPE_CODE    VARCHAR2,
48           p_BILL_TO_ADDRESS_ID    NUMBER,
49           p_SHIP_TO_ADDRESS_ID    NUMBER,
50           p_ACTIVE_START_DATE    DATE,
51           p_ACTIVE_END_DATE    DATE,
52           p_PRESERVE_DETAIL_FLAG    VARCHAR2,
53           p_ATTRIBUTE1    VARCHAR2,
54           p_ATTRIBUTE2    VARCHAR2,
55           p_ATTRIBUTE3    VARCHAR2,
56           p_ATTRIBUTE4    VARCHAR2,
57           p_ATTRIBUTE5    VARCHAR2,
58           p_ATTRIBUTE6    VARCHAR2,
59           p_ATTRIBUTE7    VARCHAR2,
60           p_ATTRIBUTE8    VARCHAR2,
61           p_ATTRIBUTE9    VARCHAR2,
62           p_ATTRIBUTE10    VARCHAR2,
63           p_ATTRIBUTE11    VARCHAR2,
64           p_ATTRIBUTE12    VARCHAR2,
65           p_ATTRIBUTE13    VARCHAR2,
66           p_ATTRIBUTE14    VARCHAR2,
67           p_ATTRIBUTE15    VARCHAR2,
68           p_CREATED_BY    NUMBER,
69           p_CREATION_DATE    DATE,
70           p_LAST_UPDATED_BY    NUMBER,
71           p_LAST_UPDATE_DATE    DATE,
72           p_LAST_UPDATE_LOGIN    NUMBER,
73           p_OBJECT_VERSION_NUMBER    NUMBER,
74           p_CONTEXT    VARCHAR2);
75 
76 PROCEDURE Lock_Row(
77           p_TXN_ACCOUNT_DETAIL_ID    NUMBER,
78           p_TXN_PARTY_DETAIL_ID    NUMBER,
79           p_IP_ACCOUNT_ID    NUMBER,
80           p_ACCOUNT_ID    NUMBER,
81           p_RELATIONSHIP_TYPE_CODE    VARCHAR2,
82           p_BILL_TO_ADDRESS_ID    NUMBER,
83           p_SHIP_TO_ADDRESS_ID    NUMBER,
84           p_ACTIVE_START_DATE    DATE,
85           p_ACTIVE_END_DATE    DATE,
86           p_PRESERVE_DETAIL_FLAG    VARCHAR2,
87           p_ATTRIBUTE1    VARCHAR2,
88           p_ATTRIBUTE2    VARCHAR2,
89           p_ATTRIBUTE3    VARCHAR2,
90           p_ATTRIBUTE4    VARCHAR2,
91           p_ATTRIBUTE5    VARCHAR2,
92           p_ATTRIBUTE6    VARCHAR2,
93           p_ATTRIBUTE7    VARCHAR2,
94           p_ATTRIBUTE8    VARCHAR2,
95           p_ATTRIBUTE9    VARCHAR2,
96           p_ATTRIBUTE10    VARCHAR2,
97           p_ATTRIBUTE11    VARCHAR2,
98           p_ATTRIBUTE12    VARCHAR2,
99           p_ATTRIBUTE13    VARCHAR2,
100           p_ATTRIBUTE14    VARCHAR2,
101           p_ATTRIBUTE15    VARCHAR2,
102           p_CREATED_BY    NUMBER,
103           p_CREATION_DATE    DATE,
104           p_LAST_UPDATED_BY    NUMBER,
105           p_LAST_UPDATE_DATE    DATE,
106           p_LAST_UPDATE_LOGIN    NUMBER,
107           p_OBJECT_VERSION_NUMBER    NUMBER,
108           p_CONTEXT    VARCHAR2);
109 
110 PROCEDURE Delete_Row(
111     p_TXN_ACCOUNT_DETAIL_ID  NUMBER);
112 End CSI_T_PARTY_ACCOUNTS_PKG;