APPS.IBE_DSP_MSITE_SCT_ITEM_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 63: CURSOR c IS SELECT rowid FROM ibe_dsp_msite_sct_items

59: x_mini_site_section_item_id OUT NOCOPY NUMBER
60: )
61: IS
62:
63: CURSOR c IS SELECT rowid FROM ibe_dsp_msite_sct_items
64: WHERE mini_site_section_item_id = x_mini_site_section_item_id;
65: CURSOR c2 IS SELECT ibe_dsp_msite_sct_items_s1.nextval FROM dual;
66:
67: BEGIN

Line 65: CURSOR c2 IS SELECT ibe_dsp_msite_sct_items_s1.nextval FROM dual;

61: IS
62:
63: CURSOR c IS SELECT rowid FROM ibe_dsp_msite_sct_items
64: WHERE mini_site_section_item_id = x_mini_site_section_item_id;
65: CURSOR c2 IS SELECT ibe_dsp_msite_sct_items_s1.nextval FROM dual;
66:
67: BEGIN
68:
69: -- Primary key validation check

Line 80: INSERT INTO ibe_dsp_msite_sct_items

76: CLOSE c2;
77: END IF;
78:
79: -- insert base
80: INSERT INTO ibe_dsp_msite_sct_items
81: (
82: mini_site_section_item_id,
83: object_version_number,
84: mini_site_id,

Line 143: UPDATE ibe_dsp_msite_sct_items SET

139: IS
140: BEGIN
141:
142: -- update base
143: UPDATE ibe_dsp_msite_sct_items SET
144: object_version_number = object_version_number + 1,
145: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
146: start_date_active, p_start_date_active),
147: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

Line 181: DELETE FROM ibe_dsp_msite_sct_items

177: )
178: IS
179: BEGIN
180:
181: DELETE FROM ibe_dsp_msite_sct_items
182: WHERE mini_site_section_item_id = p_mini_site_section_item_id;
183:
184: IF (sql%NOTFOUND) THEN
185: RAISE NO_DATA_FOUND;

Line 241: FROM ibe_dsp_msite_sct_items

237: -- Check duplicate entry
238: BEGIN
239:
240: SELECT mini_site_section_item_id INTO l_tmp_msite_sct_item_id
241: FROM ibe_dsp_msite_sct_items
242: WHERE mini_site_id = p_mini_site_id
243: AND section_item_id = p_section_item_id;
244:
245: EXCEPTION

Line 813: FROM ibe_dsp_msite_sct_items

809: -- is specified, then query for mini_site_section_item_id
810: BEGIN
811:
812: SELECT mini_site_section_item_id INTO l_msite_sct_item_id
813: FROM ibe_dsp_msite_sct_items
814: WHERE mini_site_id = p_mini_site_id
815: AND section_item_id = p_section_item_id;
816:
817: EXCEPTION

Line 1014: FROM ibe_dsp_msite_sct_items

1010: -- query for mini_site_section_item_id
1011: BEGIN
1012:
1013: SELECT mini_site_section_item_id INTO l_msite_sct_item_id
1014: FROM ibe_dsp_msite_sct_items
1015: WHERE mini_site_id = p_mini_site_id
1016: AND section_item_id = p_section_item_id;
1017:
1018: EXCEPTION