APPS.CSI_I_PRICING_ATTRIBS_H_PKG dependencies on CSI_I_PRICING_ATTRIBS_H

Line 1: PACKAGE BODY CSI_I_PRICING_ATTRIBS_H_PKG as

1: PACKAGE BODY CSI_I_PRICING_ATTRIBS_H_PKG as
2: /* $Header: csitpahb.pls 115.16 2003/09/04 00:21:55 sguthiva ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_PRICING_ATTRIBS_H_PKG';

Line 5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_PRICING_ATTRIBS_H_PKG';

1: PACKAGE BODY CSI_I_PRICING_ATTRIBS_H_PKG as
2: /* $Header: csitpahb.pls 115.16 2003/09/04 00:21:55 sguthiva ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_PRICING_ATTRIBS_H_PKG';
6:
7: PROCEDURE Insert_Row(
8: px_PRICE_ATTRIB_HISTORY_ID IN OUT NOCOPY NUMBER,
9: p_PRICING_ATTRIBUTE_ID NUMBER,

Line 257: CURSOR C2 IS SELECT CSI_I_PRICING_ATTRIBS_H_S.nextval FROM sys.dual;

253: p_LAST_UPDATE_DATE DATE,
254: p_LAST_UPDATE_LOGIN NUMBER,
255: p_OBJECT_VERSION_NUMBER NUMBER)
256: IS
257: CURSOR C2 IS SELECT CSI_I_PRICING_ATTRIBS_H_S.nextval FROM sys.dual;
258: BEGIN
259: If (px_PRICE_ATTRIB_HISTORY_ID IS NULL) OR (px_PRICE_ATTRIB_HISTORY_ID = FND_API.G_MISS_NUM) then
260: OPEN C2;
261: FETCH C2 INTO px_PRICE_ATTRIB_HISTORY_ID;

Line 264: INSERT INTO CSI_I_PRICING_ATTRIBS_H(

260: OPEN C2;
261: FETCH C2 INTO px_PRICE_ATTRIB_HISTORY_ID;
262: CLOSE C2;
263: End If;
264: INSERT INTO CSI_I_PRICING_ATTRIBS_H(
265: PRICE_ATTRIB_HISTORY_ID,
266: PRICING_ATTRIBUTE_ID,
267: TRANSACTION_ID,
268: OLD_PRICING_CONTEXT,

Line 1017: Update CSI_I_PRICING_ATTRIBS_H

1013: p_OBJECT_VERSION_NUMBER NUMBER)
1014: IS
1015: BEGIN
1016: NULL;
1017: Update CSI_I_PRICING_ATTRIBS_H
1018: SET
1019: PRICING_ATTRIBUTE_ID = decode( p_PRICING_ATTRIBUTE_ID, FND_API.G_MISS_NUM, PRICING_ATTRIBUTE_ID, p_PRICING_ATTRIBUTE_ID),
1020: TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
1021: OLD_PRICING_CONTEXT = decode( p_OLD_PRICING_CONTEXT, FND_API.G_MISS_CHAR, OLD_PRICING_CONTEXT, p_OLD_PRICING_CONTEXT),

Line 1277: DELETE FROM CSI_I_PRICING_ATTRIBS_H

1273: PROCEDURE Delete_Row(
1274: p_PRICE_ATTRIB_HISTORY_ID NUMBER)
1275: IS
1276: BEGIN
1277: DELETE FROM CSI_I_PRICING_ATTRIBS_H
1278: WHERE PRICE_ATTRIB_HISTORY_ID = p_PRICE_ATTRIB_HISTORY_ID;
1279: If (SQL%NOTFOUND) then
1280: RAISE NO_DATA_FOUND;
1281: End If;

Line 1536: FROM CSI_I_PRICING_ATTRIBS_H

1532: p_OBJECT_VERSION_NUMBER NUMBER)
1533: IS
1534: CURSOR C IS
1535: SELECT *
1536: FROM CSI_I_PRICING_ATTRIBS_H
1537: WHERE PRICE_ATTRIB_HISTORY_ID = p_PRICE_ATTRIB_HISTORY_ID
1538: FOR UPDATE of PRICE_ATTRIB_HISTORY_ID NOWAIT;
1539: Recinfo C%ROWTYPE;
1540: BEGIN

Line 2319: End CSI_I_PRICING_ATTRIBS_H_PKG;

2315: End If;
2316: NULL;
2317: END Lock_Row;
2318:
2319: End CSI_I_PRICING_ATTRIBS_H_PKG;