APPS.SO_ATT dependencies on SO_NOTE_USAGES

Line 208: FROM so_note_usages snu

204: BEGIN
205:
206: SELECT snu.category_id
207: INTO p_category_id
208: FROM so_note_usages snu
209: WHERE snu.usage_id = p_usage_id;
210:
211:
212: EXCEPTION

Line 227: so_note_usages snu

223:
224: SELECT snu.usage_id
225: INTO p_usage_id
226: FROM fnd_document_categories fdc,
227: so_note_usages snu
228: WHERE fdc.category_id = snu.category_id
229: AND fdc.category_id = p_category_id;
230:
231: END;

Line 1080: FROM so_note_usages

1076: p_usage_id IN OUT NUMBER
1077: ) IS
1078: CURSOR c IS
1079: SELECT 1
1080: FROM so_note_usages
1081: WHERE name = substr(p_user_name,1,15);
1082: dummy number;
1083: BEGIN
1084:

Line 1085: -- so_note_usages.name is enforced to be unique

1081: WHERE name = substr(p_user_name,1,15);
1082: dummy number;
1083: BEGIN
1084:
1085: -- so_note_usages.name is enforced to be unique
1086: -- by R10
1087: OPEN C;
1088: FETCH C INTO dummy;
1089: IF (C%FOUND) THEN

Line 1096: SELECT so_note_usages_s.nextval

1092: RETURN;
1093: END IF;
1094:
1095: CLOSE C;
1096: SELECT so_note_usages_s.nextval
1097: INTO p_usage_id
1098: FROM dual;
1099:
1100:

Line 1102: INSERT INTO so_note_usages (

1098: FROM dual;
1099:
1100:
1101:
1102: INSERT INTO so_note_usages (
1103: usage_id, creation_date,
1104: created_by, last_update_date,
1105: last_updated_by, last_update_login,
1106: name, description,

Line 1171: FROM so_note_usages

1167: x_attribute14 VARCHAR2(150);
1168: x_attribute15 VARCHAR2(150);
1169: CURSOR C IS
1170: SELECT 1
1171: FROM so_note_usages
1172: WHERE name = substr(p_user_name,1,15)
1173: AND category_id <> p_category_id;
1174: dummy number;
1175: BEGIN

Line 1213: UPDATE so_note_usages

1209: x_attribute15
1210: FROM fnd_document_categories
1211: WHERE category_id = p_category_id;
1212:
1213: UPDATE so_note_usages
1214: SET last_update_date = p_last_update_date,
1215: last_updated_by = p_last_updated_by,
1216: last_update_login = p_last_update_login,
1217: name = SUBSTR(p_user_name,1,15),