APPS.BNE_PARAM_GROUP_ITEMS_PKG dependencies on BNE_PARAM_GROUP_ITEMS

Line 1: package body BNE_PARAM_GROUP_ITEMS_PKG as

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

Line 18: cursor C is select ROWID from BNE_PARAM_GROUP_ITEMS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from BNE_PARAM_GROUP_ITEMS
19: where APPLICATION_ID = X_APPLICATION_ID
20: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
21: and GROUP_SEQ_NUM = X_GROUP_SEQ_NUM
22: and SEQUENCE_NUM = X_SEQUENCE_NUM

Line 25: insert into BNE_PARAM_GROUP_ITEMS (

21: and GROUP_SEQ_NUM = X_GROUP_SEQ_NUM
22: and SEQUENCE_NUM = X_SEQUENCE_NUM
23: ;
24: begin
25: insert into BNE_PARAM_GROUP_ITEMS (
26: APPLICATION_ID,
27: PARAM_LIST_CODE,
28: GROUP_SEQ_NUM,
29: SEQUENCE_NUM,

Line 72: from BNE_PARAM_GROUP_ITEMS

68: ) is
69: cursor c1 is select
70: OBJECT_VERSION_NUMBER,
71: PARAM_SEQ_NUM
72: from BNE_PARAM_GROUP_ITEMS
73: where APPLICATION_ID = X_APPLICATION_ID
74: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
75: and GROUP_SEQ_NUM = X_GROUP_SEQ_NUM
76: and SEQUENCE_NUM = X_SEQUENCE_NUM

Line 104: update BNE_PARAM_GROUP_ITEMS set

100: X_LAST_UPDATED_BY in NUMBER,
101: X_LAST_UPDATE_LOGIN in NUMBER
102: ) is
103: begin
104: update BNE_PARAM_GROUP_ITEMS set
105: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
106: PARAM_SEQ_NUM = X_PARAM_SEQ_NUM,
107: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
108: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 128: delete from BNE_PARAM_GROUP_ITEMS

124: X_GROUP_SEQ_NUM in NUMBER,
125: X_SEQUENCE_NUM in NUMBER
126: ) is
127: begin
128: delete from BNE_PARAM_GROUP_ITEMS
129: where APPLICATION_ID = X_APPLICATION_ID
130: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
131: and GROUP_SEQ_NUM = X_GROUP_SEQ_NUM
132: and SEQUENCE_NUM = X_SEQUENCE_NUM;

Line 150: -- DESCRIPTION: Load a row into the BNE_PARAM_GROUP_ITEMS entity. --

146:
147: --------------------------------------------------------------------------------
148: -- PROCEDURE: LOAD_ROW --
149: -- --
150: -- DESCRIPTION: Load a row into the BNE_PARAM_GROUP_ITEMS entity. --
151: -- This proc is called from the apps loader. --
152: -- --
153: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
154: -- --

Line 190: from BNE_PARAM_GROUP_ITEMS

186: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
187: begin
188: select LAST_UPDATED_BY, LAST_UPDATE_DATE
189: into db_luby, db_ludate
190: from BNE_PARAM_GROUP_ITEMS
191: where APPLICATION_ID = l_app_id
192: and PARAM_LIST_CODE = x_param_list_code
193: and GROUP_SEQ_NUM = x_group_seq_num
194: and SEQUENCE_NUM = x_sequence_num;

Line 200: BNE_PARAM_GROUP_ITEMS_PKG.Update_Row(

196: -- Test for customization and version
197: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
198: db_ludate, x_custom_mode)) then
199: -- Update existing row
200: BNE_PARAM_GROUP_ITEMS_PKG.Update_Row(
201: X_APPLICATION_ID => l_app_id,
202: X_PARAM_LIST_CODE => x_param_list_code,
203: X_GROUP_SEQ_NUM => x_group_seq_num,
204: X_SEQUENCE_NUM => x_sequence_num,

Line 215: BNE_PARAM_GROUP_ITEMS_PKG.Insert_Row(

211: end if;
212: exception
213: when no_data_found then
214: -- Record doesn't exist - insert in all cases
215: BNE_PARAM_GROUP_ITEMS_PKG.Insert_Row(
216: X_ROWID => l_row_id,
217: X_APPLICATION_ID => l_app_id,
218: X_PARAM_LIST_CODE => x_param_list_code,
219: X_GROUP_SEQ_NUM => x_group_seq_num,

Line 233: end BNE_PARAM_GROUP_ITEMS_PKG;

229: end;
230: end LOAD_ROW;
231:
232:
233: end BNE_PARAM_GROUP_ITEMS_PKG;