APPS.JTF_DSP_SECTION_ITEM_PVT dependencies on JTF_DSP_SECTION_ITEMS

Line 61: CURSOR c IS SELECT rowid FROM jtf_dsp_section_items

57: x_rowid OUT VARCHAR2,
58: x_section_item_id OUT NUMBER
59: )
60: IS
61: CURSOR c IS SELECT rowid FROM jtf_dsp_section_items
62: WHERE section_item_id = x_section_item_id;
63: CURSOR c2 IS SELECT jtf_dsp_section_items_s1.nextval FROM dual;
64:
65: BEGIN

Line 63: CURSOR c2 IS SELECT jtf_dsp_section_items_s1.nextval FROM dual;

59: )
60: IS
61: CURSOR c IS SELECT rowid FROM jtf_dsp_section_items
62: WHERE section_item_id = x_section_item_id;
63: CURSOR c2 IS SELECT jtf_dsp_section_items_s1.nextval FROM dual;
64:
65: BEGIN
66:
67: -- Primary key validation check

Line 78: INSERT INTO jtf_dsp_section_items

74: CLOSE c2;
75: END IF;
76:
77: -- insert base
78: INSERT INTO jtf_dsp_section_items
79: (
80: section_item_id,
81: object_version_number,
82: section_id,

Line 150: UPDATE jtf_dsp_section_items SET

146: IS
147: BEGIN
148:
149: -- update base
150: UPDATE jtf_dsp_section_items SET
151: object_version_number = object_version_number + 1,
152: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
153: sort_order, p_sort_order),
154: association_reason_code =

Line 193: DELETE FROM jtf_dsp_section_items

189: )
190: IS
191: BEGIN
192:
193: DELETE FROM jtf_dsp_section_items
194: WHERE section_item_id = p_section_item_id;
195:
196: IF (sql%NOTFOUND) THEN
197: RAISE NO_DATA_FOUND;

Line 254: FROM jtf_dsp_section_items

250: -- Check duplicate entry
251: BEGIN
252:
253: SELECT section_item_id INTO l_tmp_section_item_id
254: FROM jtf_dsp_section_items
255: WHERE section_id = p_section_id
256: AND inventory_item_id = p_inventory_item_id
257: AND organization_id = p_organization_id;
258:

Line 877: FROM jtf_dsp_section_items

873: -- is specified, then query for section_item_id
874: BEGIN
875:
876: SELECT section_item_id INTO l_section_item_id
877: FROM jtf_dsp_section_items
878: WHERE section_id = p_section_id
879: AND inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881:

Line 1032: FROM jtf_dsp_section_items

1028: WHERE section_item_id = l_c_section_item_id;
1029:
1030: CURSOR c2(l_c_section_item_id IN NUMBER)
1031: IS SELECT section_id, inventory_item_id, organization_id
1032: FROM jtf_dsp_section_items
1033: WHERE section_item_id = l_c_section_item_id;
1034:
1035: BEGIN
1036:

Line 1100: FROM jtf_dsp_section_items

1096:
1097: BEGIN
1098:
1099: SELECT section_item_id INTO l_section_item_id
1100: FROM jtf_dsp_section_items
1101: WHERE section_id = p_section_id
1102: AND inventory_item_id = p_inventory_item_id
1103: AND organization_id = p_organization_id;
1104:

Line 1221: SELECT section_item_id FROM jtf_dsp_section_items

1217: l_msg_data VARCHAR2(2000);
1218: l_return_status VARCHAR2(1);
1219:
1220: CURSOR c1(l_c_inventory_item_id IN NUMBER, l_c_organization_id IN NUMBER) IS
1221: SELECT section_item_id FROM jtf_dsp_section_items
1222: WHERE inventory_item_id = l_c_inventory_item_id AND
1223: organization_id = l_c_organization_id;
1224: BEGIN
1225: