APPS.IBE_DSP_SECTION_ITEM_PVT dependencies on IBE_DSP_SECTION_ITEMS

Line 64: CURSOR c IS SELECT rowid FROM ibe_dsp_section_items

60: x_rowid OUT NOCOPY VARCHAR2,
61: x_section_item_id OUT NOCOPY NUMBER
62: )
63: IS
64: CURSOR c IS SELECT rowid FROM ibe_dsp_section_items
65: WHERE section_item_id = x_section_item_id;
66: CURSOR c2 IS SELECT ibe_dsp_section_items_s1.nextval FROM dual;
67:
68: BEGIN

Line 66: CURSOR c2 IS SELECT ibe_dsp_section_items_s1.nextval FROM dual;

62: )
63: IS
64: CURSOR c IS SELECT rowid FROM ibe_dsp_section_items
65: WHERE section_item_id = x_section_item_id;
66: CURSOR c2 IS SELECT ibe_dsp_section_items_s1.nextval FROM dual;
67:
68: BEGIN
69:
70: -- Primary key validation check

Line 81: INSERT INTO ibe_dsp_section_items

77: CLOSE c2;
78: END IF;
79:
80: -- insert base
81: INSERT INTO ibe_dsp_section_items
82: (
83: section_item_id,
84: object_version_number,
85: section_id,

Line 156: UPDATE ibe_dsp_section_items SET

152: IS
153: BEGIN
154:
155: -- update base
156: UPDATE ibe_dsp_section_items SET
157: object_version_number = object_version_number + 1,
158: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
159: sort_order, p_sort_order),
160: association_reason_code =

Line 200: DELETE FROM ibe_dsp_section_items

196: )
197: IS
198: BEGIN
199:
200: DELETE FROM ibe_dsp_section_items
201: WHERE section_item_id = p_section_item_id;
202:
203: IF (sql%NOTFOUND) THEN
204: RAISE NO_DATA_FOUND;

Line 261: FROM ibe_dsp_section_items

257: -- Check duplicate entry
258: BEGIN
259:
260: SELECT section_item_id INTO l_tmp_section_item_id
261: FROM ibe_dsp_section_items
262: WHERE section_id = p_section_id
263: AND inventory_item_id = p_inventory_item_id
264: AND organization_id = p_organization_id;
265:

Line 947: FROM ibe_dsp_section_items

943: -- is specified, then query for section_item_id
944: BEGIN
945:
946: SELECT section_item_id INTO l_section_item_id
947: FROM ibe_dsp_section_items
948: WHERE section_id = p_section_id
949: AND inventory_item_id = p_inventory_item_id
950: AND organization_id = p_organization_id;
951:

Line 1124: FROM ibe_dsp_section_items

1120: WHERE section_item_id = l_c_section_item_id;
1121:
1122: CURSOR c2(l_c_section_item_id IN NUMBER)
1123: IS SELECT section_id, inventory_item_id, organization_id
1124: FROM ibe_dsp_section_items
1125: WHERE section_item_id = l_c_section_item_id;
1126:
1127: BEGIN
1128: -- Call savepoint only when not called from trigger

Line 1191: FROM ibe_dsp_section_items

1187:
1188: BEGIN
1189:
1190: SELECT section_item_id INTO l_section_item_id
1191: FROM ibe_dsp_section_items
1192: WHERE section_id = p_section_id
1193: AND inventory_item_id = p_inventory_item_id
1194: AND organization_id = p_organization_id;
1195:

Line 1324: SELECT section_item_id FROM ibe_dsp_section_items

1320: l_msg_data VARCHAR2(2000);
1321: l_return_status VARCHAR2(1);
1322:
1323: CURSOR c1(l_c_inventory_item_id IN NUMBER, l_c_organization_id IN NUMBER) IS
1324: SELECT section_item_id FROM ibe_dsp_section_items
1325: WHERE inventory_item_id = l_c_inventory_item_id AND
1326: organization_id = l_c_organization_id;
1327: BEGIN
1328: