APPS.CSP_USG_TRANSACTION_TYPES_PKG dependencies on CSP_USG_TRANSACTION_TYPES

Line 1: PACKAGE BODY CSP_USG_TRANSACTION_TYPES_PKG as

1: PACKAGE BODY CSP_USG_TRANSACTION_TYPES_PKG as
2: /* $Header: csptuttb.pls 115.1 2003/10/03 19:03:28 sunarasi noship $ */
3: -- Start of Comments
4: -- Package name : CSP_USG_TRANSACTION_TYPES_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_USG_TRANSACTION_TYPES_PKG

1: PACKAGE BODY CSP_USG_TRANSACTION_TYPES_PKG as
2: /* $Header: csptuttb.pls 115.1 2003/10/03 19:03:28 sunarasi noship $ */
3: -- Start of Comments
4: -- Package name : CSP_USG_TRANSACTION_TYPES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_USG_TRANSACTION_TYPES_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_USG_TRANSACTION_TYPES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptbrub.pls';
13:
14: PROCEDURE Insert_Row(
15: px_USG_TRANSACTION_TYPE_ID IN OUT NOCOPY NUMBER

Line 24: CURSOR C2 IS SELECT CSP_USG_TRANSACTION_TYPES_S1.nextval FROM sys.dual;

20: ,p_LAST_UPDATE_LOGIN NUMBER
21: ,p_FORECAST_RULE_ID NUMBER
22: ,p_TRANSACTION_TYPE_ID NUMBER)
23: IS
24: CURSOR C2 IS SELECT CSP_USG_TRANSACTION_TYPES_S1.nextval FROM sys.dual;
25: BEGIN
26: If px_USG_TRANSACTION_TYPE_ID IS NULL Then
27: OPEN C2;
28: FETCH C2 INTO px_USG_TRANSACTION_TYPE_ID;

Line 31: INSERT INTO CSP_USG_TRANSACTION_TYPES(

27: OPEN C2;
28: FETCH C2 INTO px_USG_TRANSACTION_TYPE_ID;
29: CLOSE C2;
30: End If;
31: INSERT INTO CSP_USG_TRANSACTION_TYPES(
32: USG_TRANSACTION_TYPE_ID
33: ,LAST_UPDATE_DATE
34: ,LAST_UPDATED_BY
35: ,CREATION_DATE

Line 62: Update CSP_USG_TRANSACTION_TYPES

58: ,p_FORECAST_RULE_ID NUMBER
59: ,p_TRANSACTION_TYPE_ID NUMBER)
60: IS
61: BEGIN
62: Update CSP_USG_TRANSACTION_TYPES
63: SET
64: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
65: ,LAST_UPDATED_BY = p_LAST_UPDATED_BY
66: ,CREATION_DATE = p_CREATION_DATE

Line 82: DELETE FROM CSP_USG_TRANSACTION_TYPES

78: PROCEDURE Delete_Row(
79: p_USG_TRANSACTION_TYPE_ID NUMBER)
80: IS
81: BEGIN
82: DELETE FROM CSP_USG_TRANSACTION_TYPES
83: WHERE USG_TRANSACTION_TYPE_ID = p_USG_TRANSACTION_TYPE_ID;
84: If (SQL%NOTFOUND) then
85: RAISE NO_DATA_FOUND;
86: End If;

Line 101: FROM CSP_USG_TRANSACTION_TYPES

97: ,p_TRANSACTION_TYPE_ID NUMBER)
98: IS
99: CURSOR C IS
100: SELECT *
101: FROM CSP_USG_TRANSACTION_TYPES
102: WHERE USG_TRANSACTION_TYPE_ID = p_USG_TRANSACTION_TYPE_ID
103: FOR UPDATE of USG_TRANSACTION_TYPE_ID NOWAIT;
104: Recinfo C%ROWTYPE;
105: BEGIN

Line 145: End CSP_USG_TRANSACTION_TYPES_PKG;

141: APP_EXCEPTION.RAISE_EXCEPTION;
142: End If;
143: END Lock_Row;
144:
145: End CSP_USG_TRANSACTION_TYPES_PKG;