APPS.CSI_I_PRICING_ATTRIBS_PKG dependencies on CSI_I_PRICING_ATTRIBS

Line 1: PACKAGE BODY CSI_I_PRICING_ATTRIBS_PKG as

1: PACKAGE BODY CSI_I_PRICING_ATTRIBS_PKG as
2: /* $Header: csitipab.pls 115.12 2003/09/04 00:20:16 sguthiva ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_PRICING_ATTRIBS_PKG';

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

1: PACKAGE BODY CSI_I_PRICING_ATTRIBS_PKG as
2: /* $Header: csitipab.pls 115.12 2003/09/04 00:20:16 sguthiva ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_I_PRICING_ATTRIBS_PKG';
6:
7: PROCEDURE Insert_Row(
8: px_PRICING_ATTRIBUTE_ID IN OUT NOCOPY NUMBER,
9: p_INSTANCE_ID NUMBER,

Line 136: CURSOR C2 IS SELECT CSI_I_PRICING_ATTRIBS_S.nextval FROM sys.dual;

132: p_PRICING_ATTRIBUTE98 VARCHAR2,
133: p_PRICING_ATTRIBUTE99 VARCHAR2,
134: p_PRICING_ATTRIBUTE100 VARCHAR2)
135: IS
136: CURSOR C2 IS SELECT CSI_I_PRICING_ATTRIBS_S.nextval FROM sys.dual;
137: BEGIN
138: If (px_PRICING_ATTRIBUTE_ID IS NULL) OR (px_PRICING_ATTRIBUTE_ID = FND_API.G_MISS_NUM) then
139: OPEN C2;
140: FETCH C2 INTO px_PRICING_ATTRIBUTE_ID;

Line 143: INSERT INTO CSI_I_PRICING_ATTRIBS(

139: OPEN C2;
140: FETCH C2 INTO px_PRICING_ATTRIBUTE_ID;
141: CLOSE C2;
142: End If;
143: INSERT INTO CSI_I_PRICING_ATTRIBS(
144: PRICING_ATTRIBUTE_ID,
145: INSTANCE_ID,
146: ACTIVE_START_DATE,
147: ACTIVE_END_DATE,

Line 532: Update CSI_I_PRICING_ATTRIBS

528: p_PRICING_ATTRIBUTE100 VARCHAR2)
529:
530: IS
531: BEGIN
532: Update CSI_I_PRICING_ATTRIBS
533: SET
534: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
535: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
536: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),

Line 671: DELETE FROM CSI_I_PRICING_ATTRIBS

667: PROCEDURE Delete_Row(
668: p_PRICING_ATTRIBUTE_ID NUMBER)
669: IS
670: BEGIN
671: DELETE FROM CSI_I_PRICING_ATTRIBS
672: WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTRIBUTE_ID;
673: If (SQL%NOTFOUND) then
674: RAISE NO_DATA_FOUND;
675: End If;

Line 810: FROM CSI_I_PRICING_ATTRIBS

806:
807: IS
808: CURSOR C IS
809: SELECT *
810: FROM CSI_I_PRICING_ATTRIBS
811: WHERE PRICING_ATTRIBUTE_ID = p_PRICING_ATTRIBUTE_ID
812: FOR UPDATE of PRICING_ATTRIBUTE_ID NOWAIT;
813: Recinfo C%ROWTYPE;
814: BEGIN

Line 1211: End CSI_I_PRICING_ATTRIBS_PKG;

1207: APP_EXCEPTION.RAISE_EXCEPTION;
1208: End If;
1209: END Lock_Row;
1210:
1211: End CSI_I_PRICING_ATTRIBS_PKG;