APPS.CSI_T_PARTY_DETAILS_PKG dependencies on CSI_T_PARTY_DETAILS

Line 1: PACKAGE BODY CSI_T_PARTY_DETAILS_PKG as

1: PACKAGE BODY CSI_T_PARTY_DETAILS_PKG as
2: /* $Header: csittptb.pls 120.1 2005/06/17 01:52:35 appldev $ */
3: -- Package name : CSI_T_PARTY_DETAILS_PKG
4: -- Purpose : Table Handler for csi_t_party_details
5: -- History : brmanesh created 12-MAY-2001

Line 3: -- Package name : CSI_T_PARTY_DETAILS_PKG

1: PACKAGE BODY CSI_T_PARTY_DETAILS_PKG as
2: /* $Header: csittptb.pls 120.1 2005/06/17 01:52:35 appldev $ */
3: -- Package name : CSI_T_PARTY_DETAILS_PKG
4: -- Purpose : Table Handler for csi_t_party_details
5: -- History : brmanesh created 12-MAY-2001
6: -- NOTE :
7:

Line 4: -- Purpose : Table Handler for csi_t_party_details

1: PACKAGE BODY CSI_T_PARTY_DETAILS_PKG as
2: /* $Header: csittptb.pls 120.1 2005/06/17 01:52:35 appldev $ */
3: -- Package name : CSI_T_PARTY_DETAILS_PKG
4: -- Purpose : Table Handler for csi_t_party_details
5: -- History : brmanesh created 12-MAY-2001
6: -- NOTE :
7:
8:

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_PARTY_DETAILS_PKG';

5: -- History : brmanesh created 12-MAY-2001
6: -- NOTE :
7:
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_PARTY_DETAILS_PKG';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csittptb.pls';
11:
12: PROCEDURE Insert_Row(
13: px_TXN_PARTY_DETAIL_ID IN OUT NOCOPY NUMBER,

Line 50: CURSOR C2 IS SELECT CSI_T_PARTY_DETAILS_S.nextval FROM sys.dual;

46: p_PRIMARY_FLAG VARCHAR2,
47: p_PREFERRED_FLAG VARCHAR2)
48:
49: IS
50: CURSOR C2 IS SELECT CSI_T_PARTY_DETAILS_S.nextval FROM sys.dual;
51: BEGIN
52: If (px_TXN_PARTY_DETAIL_ID IS NULL) OR (px_TXN_PARTY_DETAIL_ID = FND_API.G_MISS_NUM) then
53: OPEN C2;
54: FETCH C2 INTO px_TXN_PARTY_DETAIL_ID;

Line 57: INSERT INTO CSI_T_PARTY_DETAILS(

53: OPEN C2;
54: FETCH C2 INTO px_TXN_PARTY_DETAIL_ID;
55: CLOSE C2;
56: End If;
57: INSERT INTO CSI_T_PARTY_DETAILS(
58: TXN_PARTY_DETAIL_ID,
59: TXN_LINE_DETAIL_ID,
60: PARTY_SOURCE_TABLE,
61: PARTY_SOURCE_ID,

Line 170: Update CSI_T_PARTY_DETAILS

166: p_PREFERRED_FLAG VARCHAR2)
167:
168: IS
169: BEGIN
170: Update CSI_T_PARTY_DETAILS
171: SET
172: TXN_LINE_DETAIL_ID = decode( p_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, TXN_LINE_DETAIL_ID, p_TXN_LINE_DETAIL_ID),
173: PARTY_SOURCE_TABLE = decode( p_PARTY_SOURCE_TABLE, FND_API.G_MISS_CHAR, PARTY_SOURCE_TABLE, p_PARTY_SOURCE_TABLE),
174: PARTY_SOURCE_ID = decode( p_PARTY_SOURCE_ID, FND_API.G_MISS_NUM, PARTY_SOURCE_ID, p_PARTY_SOURCE_ID),

Line 217: DELETE FROM CSI_T_PARTY_DETAILS

213: PROCEDURE Delete_Row(
214: p_TXN_PARTY_DETAIL_ID NUMBER)
215: IS
216: BEGIN
217: DELETE FROM CSI_T_PARTY_DETAILS
218: WHERE TXN_PARTY_DETAIL_ID = p_TXN_PARTY_DETAIL_ID;
219: If (SQL%NOTFOUND) then
220: RAISE NO_DATA_FOUND;
221: End If;

Line 264: FROM CSI_T_PARTY_DETAILS

260:
261: IS
262: CURSOR C IS
263: SELECT *
264: FROM CSI_T_PARTY_DETAILS
265: WHERE TXN_PARTY_DETAIL_ID = p_TXN_PARTY_DETAIL_ID
266: FOR UPDATE of TXN_PARTY_DETAIL_ID NOWAIT;
267: Recinfo C%ROWTYPE;
268: BEGIN

Line 389: End CSI_T_PARTY_DETAILS_PKG;

385: APP_EXCEPTION.RAISE_EXCEPTION;
386: End If;
387: END Lock_Row;
388:
389: End CSI_T_PARTY_DETAILS_PKG;