APPS.PSB_RULE_WITHIN_SEGMENT_PVT dependencies on PSB_RULE_WITHIN_SEGMENT

Line 1: PACKAGE BODY PSB_RULE_WITHIN_SEGMENT_PVT AS

1: PACKAGE BODY PSB_RULE_WITHIN_SEGMENT_PVT AS
2: /* $Header: PSBVWSPB.pls 120.2 2005/07/13 11:31:26 shtripat noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_RULE_WITHIN_SEGMENT_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_RULE_WITHIN_SEGMENT_PVT';

1: PACKAGE BODY PSB_RULE_WITHIN_SEGMENT_PVT AS
2: /* $Header: PSBVWSPB.pls 120.2 2005/07/13 11:31:26 shtripat noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_RULE_WITHIN_SEGMENT_PVT';
6:
7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 32: from PSB_RULE_WITHIN_SEGMENT

28: l_api_version CONSTANT NUMBER := 1.0;
29: --
30: cursor C is
31: select ROWID
32: from PSB_RULE_WITHIN_SEGMENT
33: where RULE_ID = P_RULE_ID;
34:
35: BEGIN
36: --

Line 55: insert into PSB_RULE_WITHIN_SEGMENT (

51: --
52: p_return_status := FND_API.G_RET_STS_SUCCESS ;
53: --
54:
55: insert into PSB_RULE_WITHIN_SEGMENT (
56: RULE_ID,
57: SEGMENT_NAME,
58: APPLICATION_COLUMN_NAME,
59: CREATION_DATE,

Line 143: from PSB_RULE_WITHIN_SEGMENT

139: --
140: Counter NUMBER;
141: cursor c1 is select
142: SEGMENT_NAME, APPLICATION_COLUMN_NAME
143: from PSB_RULE_WITHIN_SEGMENT
144: where RULE_ID = P_RULE_ID
145: for update of RULE_ID nowait;
146: tlinfo c1%rowtype;
147:

Line 274: update PSB_RULE_WITHIN_SEGMENT set

270: END IF;
271: --
272: p_return_status := FND_API.G_RET_STS_SUCCESS ;
273: --
274: update PSB_RULE_WITHIN_SEGMENT set
275: SEGMENT_NAME = P_SEGMENT_NAME,
276: APPLICATION_COLUMN_NAME = P_APPLICATION_COLUMN_NAME,
277: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
278: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 360: delete from PSB_RULE_WITHIN_SEGMENT

356: END IF;
357: --
358: p_return_status := FND_API.G_RET_STS_SUCCESS ;
359: --
360: delete from PSB_RULE_WITHIN_SEGMENT
361: where RULE_ID = P_RULE_ID
362: and APPLICATION_COLUMN_NAME = P_APPLICATION_COLUMN_NAME;
363: if (sql%notfound) then
364: raise no_data_found;

Line 511: end PSB_RULE_WITHIN_SEGMENT_PVT;

507:
508: END Validate_Account_Segment;
509:
510:
511: end PSB_RULE_WITHIN_SEGMENT_PVT;