APPS.PSB_RULE_TRANSACTION_TYPE_PVT dependencies on PSB_RULE_TRANSACTION_TYPE

Line 1: PACKAGE BODY PSB_RULE_TRANSACTION_TYPE_PVT AS

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

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

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

Line 33: from PSB_RULE_TRANSACTION_TYPE

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

Line 56: insert into PSB_RULE_TRANSACTION_TYPE (

52: --
53: p_return_status := FND_API.G_RET_STS_SUCCESS ;
54: --
55:
56: insert into PSB_RULE_TRANSACTION_TYPE (
57: RULE_ID,
58: TRANSACTION_TYPE,
59: ENABLE_FLAG, --added for Bug # 2123930
60: CREATION_DATE,

Line 147: from PSB_RULE_TRANSACTION_TYPE

143: /* For Bug # 2123930 : Start */
144: /*
145: cursor c1 is select
146: TRANSACTION_TYPE
147: from PSB_RULE_TRANSACTION_TYPE
148: where RULE_ID = P_RULE_ID
149: for update of RULE_ID nowait;
150:
151: tlinfo c1%rowtype;

Line 156: from PSB_RULE_TRANSACTION_TYPE

152: */
153:
154: cursor c1 is
155: select 1
156: from PSB_RULE_TRANSACTION_TYPE
157: where RULE_ID = P_RULE_ID
158: for update of RULE_ID nowait;
159: /* For Bug # 2123930 : End */
160:

Line 300: /* update PSB_RULE_TRANSACTION_TYPE set

296: --
297: p_return_status := FND_API.G_RET_STS_SUCCESS ;
298: --
299: /* For Bug # 2123930 : Start */
300: /* update PSB_RULE_TRANSACTION_TYPE set
301: TRANSACTION_TYPE = P_TRANSACTION_TYPE,
302: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
303: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
304: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN

Line 308: update PSB_RULE_TRANSACTION_TYPE set

304: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
305: where RULE_ID = P_RULE_ID
306: ;
307: */
308: update PSB_RULE_TRANSACTION_TYPE set
309: ENABLE_FLAG = P_ENABLE_FLAG,
310: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
311: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
312: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN

Line 398: delete from PSB_RULE_TRANSACTION_TYPE

394: END IF;
395: --
396: p_return_status := FND_API.G_RET_STS_SUCCESS ;
397: --
398: delete from PSB_RULE_TRANSACTION_TYPE
399: where RULE_ID = P_RULE_ID
400: and TRANSACTION_TYPE = P_TRANSACTION_TYPE;
401: if (sql%notfound) then
402: raise no_data_found;

Line 444: end PSB_RULE_TRANSACTION_TYPE_PVT;

440: --
441: END Delete_Row;
442:
443:
444: end PSB_RULE_TRANSACTION_TYPE_PVT;