APPS.AS_MC_REPORTING_CURR_PKG dependencies on AS_MC_REPORTING_CURR

Line 1: PACKAGE BODY AS_MC_REPORTING_CURR_PKG as

1: PACKAGE BODY AS_MC_REPORTING_CURR_PKG as
2: /* $Header: asxtmrcb.pls 115.3 2002/11/06 00:54:45 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_MC_REPORTING_CURR_PKG
5: -- Purpose :

Line 4: -- Package name : AS_MC_REPORTING_CURR_PKG

1: PACKAGE BODY AS_MC_REPORTING_CURR_PKG as
2: /* $Header: asxtmrcb.pls 115.3 2002/11/06 00:54:45 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_MC_REPORTING_CURR_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_MC_REPORTING_CURR_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtmrcb.pls';
13:
14: PROCEDURE Insert_Row(
15: p_CREATED_BY NUMBER,

Line 28: CURSOR C2 IS SELECT AS_MC_REPORTING_CURR_S.nextval FROM sys.dual;

24: px_SETUP_CURRENCY_ID IN OUT NUMBER,
25: p_SECURITY_GROUP_ID NUMBER)
26:
27: IS
28: CURSOR C2 IS SELECT AS_MC_REPORTING_CURR_S.nextval FROM sys.dual;
29: BEGIN
30: If (px_SETUP_CURRENCY_ID IS NULL) OR (px_SETUP_CURRENCY_ID = FND_API.G_MISS_NUM) then
31: OPEN C2;
32: FETCH C2 INTO px_SETUP_CURRENCY_ID;

Line 35: INSERT INTO AS_MC_REPORTING_CURR(

31: OPEN C2;
32: FETCH C2 INTO px_SETUP_CURRENCY_ID;
33: CLOSE C2;
34: End If;
35: INSERT INTO AS_MC_REPORTING_CURR(
36: SETUP_CURRENCY_ID,
37: CREATED_BY,
38: CREATION_DATE,
39: LAST_UPDATED_BY,

Line 76: Update AS_MC_REPORTING_CURR

72: p_SECURITY_GROUP_ID NUMBER)
73:
74: IS
75: BEGIN
76: Update AS_MC_REPORTING_CURR
77: SET
78: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
79: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
80: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 99: DELETE FROM AS_MC_REPORTING_CURR

95: PROCEDURE Delete_Row(
96: p_SETUP_CURRENCY_ID NUMBER)
97: IS
98: BEGIN
99: DELETE FROM AS_MC_REPORTING_CURR
100: WHERE SETUP_CURRENCY_ID = p_SETUP_CURRENCY_ID;
101: If (SQL%NOTFOUND) then
102: RAISE NO_DATA_FOUND;
103: End If;

Line 122: FROM AS_MC_REPORTING_CURR

118:
119: IS
120: CURSOR C IS
121: SELECT *
122: FROM AS_MC_REPORTING_CURR
123: WHERE SETUP_CURRENCY_ID = p_SETUP_CURRENCY_ID
124: FOR UPDATE of SETUP_CURRENCY_ID NOWAIT;
125: Recinfo C%ROWTYPE;
126: BEGIN

Line 175: End AS_MC_REPORTING_CURR_PKG;

171: APP_EXCEPTION.RAISE_EXCEPTION;
172: End If;
173: END Lock_Row;
174:
175: End AS_MC_REPORTING_CURR_PKG;