APPS.BNE_PERF_SET_ITEMS_PKG dependencies on BNE_PERF_SET_ITEMS

Line 1: package body BNE_PERF_SET_ITEMS_PKG as

1: package body BNE_PERF_SET_ITEMS_PKG as
2: /* $Header: bneperfsetitemb.pls 120.2 2005/06/29 03:40:43 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 15: cursor C is select ROWID from BNE_PERF_SET_ITEMS

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from BNE_PERF_SET_ITEMS
16: where SET_CODE = X_SET_CODE
17: and STATISTIC_CODE = X_STATISTIC_CODE
18: ;
19: begin

Line 20: insert into BNE_PERF_SET_ITEMS (

16: where SET_CODE = X_SET_CODE
17: and STATISTIC_CODE = X_STATISTIC_CODE
18: ;
19: begin
20: insert into BNE_PERF_SET_ITEMS (
21: SET_CODE,
22: STATISTIC_CODE,
23: OBJECT_VERSION_NUMBER,
24: CREATED_BY,

Line 57: from BNE_PERF_SET_ITEMS

53: X_OBJECT_VERSION_NUMBER in NUMBER
54: ) is
55: cursor c1 is select
56: OBJECT_VERSION_NUMBER
57: from BNE_PERF_SET_ITEMS
58: where SET_CODE = X_SET_CODE
59: and STATISTIC_CODE = X_STATISTIC_CODE
60: for update of SET_CODE nowait;
61: begin

Line 83: update BNE_PERF_SET_ITEMS set

79: X_LAST_UPDATED_BY in NUMBER,
80: X_LAST_UPDATE_LOGIN in NUMBER
81: ) is
82: begin
83: update BNE_PERF_SET_ITEMS set
84: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
85: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
86: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
87: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 102: delete from BNE_PERF_SET_ITEMS

98: X_SET_CODE in VARCHAR2,
99: X_STATISTIC_CODE in VARCHAR2
100: ) is
101: begin
102: delete from BNE_PERF_SET_ITEMS
103: where SET_CODE = X_SET_CODE
104: and STATISTIC_CODE = X_STATISTIC_CODE;
105:
106: if (sql%notfound) then

Line 121: -- DESCRIPTION: Load a row into the BNE_PERF_SET_ITEMS entity. --

117:
118: --------------------------------------------------------------------------------
119: -- PROCEDURE: LOAD_ROW --
120: -- --
121: -- DESCRIPTION: Load a row into the BNE_PERF_SET_ITEMS entity. --
122: -- This proc is called from the apps loader. --
123: -- --
124: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
125: -- --

Line 154: from BNE_PERF_SET_ITEMS

150: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
151: begin
152: select LAST_UPDATED_BY, LAST_UPDATE_DATE
153: into db_luby, db_ludate
154: from BNE_PERF_SET_ITEMS
155: where SET_CODE = x_set_code
156: and STATISTIC_CODE = x_statistic_code
157: ;
158:

Line 163: BNE_PERF_SET_ITEMS_PKG.Update_Row(

159: -- Test for customization and version
160: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
161: db_ludate, x_custom_mode)) then
162: -- Update existing row
163: BNE_PERF_SET_ITEMS_PKG.Update_Row(
164: X_SET_CODE => x_set_code,
165: X_STATISTIC_CODE => x_statistic_code,
166: X_OBJECT_VERSION_NUMBER => x_object_version_number,
167: X_LAST_UPDATE_DATE => f_ludate,

Line 175: BNE_PERF_SET_ITEMS_PKG.Insert_Row(

171: end if;
172: exception
173: when no_data_found then
174: -- Record doesn't exist - insert in all cases
175: BNE_PERF_SET_ITEMS_PKG.Insert_Row(
176: X_ROWID => l_row_id,
177: X_SET_CODE => x_set_code,
178: X_STATISTIC_CODE => x_statistic_code,
179: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 190: end BNE_PERF_SET_ITEMS_PKG;

186: end;
187: end LOAD_ROW;
188:
189:
190: end BNE_PERF_SET_ITEMS_PKG;