APPS.SO_ATT dependencies on FND_DOCUMENT_CATEGORIES

Line 226: FROM fnd_document_categories fdc,

222: BEGIN
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:

Line 255: FROM fnd_document_categories fdc,

251: IS
252: x_category_application NUMBER;
253: CURSOR get_doc_cat_app IS
254: SELECT fdc.application_id
255: FROM fnd_document_categories fdc,
256: fnd_documents fd
257: WHERE fd.category_id = fdc.category_id
258: AND fd.document_id = p_document_id;
259: BEGIN

Line 278: FROM fnd_document_categories

274: IS
275: x_application_id NUMBER;
276: CURSOR get_app IS
277: SELECT application_id
278: FROM fnd_document_categories
279: WHERE category_id = p_category_id;
280: BEGIN
281: -- get category_application based on category_id
282: OPEN get_app;

Line 307: FROM fnd_document_categories fdc,

303: x_application_id NUMBER;
304: CURSOR c1 IS
305: SELECT fd.document_id, fd.category_id,
306: fd.usage_type, fdc.application_id
307: FROM fnd_document_categories fdc,
308: fnd_documents_tl fdt,
309: fnd_documents fd
310: WHERE fdt.media_id = p_media_id
311: AND fdt.document_id = fd.document_id

Line 917: SELECT fnd_document_categories_s.nextval

913: ) IS
914: attach_function_id NUMBER;
915: BEGIN
916:
917: SELECT fnd_document_categories_s.nextval
918: INTO p_category_id
919: FROM dual;
920:
921: INSERT INTO fnd_document_categories (

Line 921: INSERT INTO fnd_document_categories (

917: SELECT fnd_document_categories_s.nextval
918: INTO p_category_id
919: FROM dual;
920:
921: INSERT INTO fnd_document_categories (
922: category_id,
923: application_id, creation_date,
924: created_by, last_update_date,
925: last_updated_by, last_update_login,

Line 957: INSERT INTO fnd_document_categories_tl (

953: p_attribute13, p_attribute14,
954: p_attribute15
955: FROM dual;
956:
957: INSERT INTO fnd_document_categories_tl (
958: category_id, language,
959: name, user_name,
960: creation_date,
961: created_by, last_update_date,

Line 1030: UPDATE fnd_document_categories

1026: ) IS
1027:
1028: BEGIN
1029:
1030: UPDATE fnd_document_categories
1031: SET last_update_date = p_last_update_date,
1032: last_updated_by = p_last_updated_by,
1033: last_update_login = p_last_update_login,
1034: name = p_name,

Line 1055: UPDATE fnd_document_categories_tl

1051: attribute14 = p_attribute14,
1052: attribute15 = p_attribute15
1053: WHERE category_id = p_category_id;
1054:
1055: UPDATE fnd_document_categories_tl
1056: SET last_update_date = p_last_update_date,
1057: last_updated_by = p_last_updated_by,
1058: last_update_login = p_last_update_login,
1059: name = p_name,

Line 1134: FROM fnd_document_categories fdc

1130: fdc.attribute11, fdc.attribute12,
1131: fdc.attribute13, fdc.attribute14,
1132: fdc.attribute15,
1133: p_category_id, p_app_source_version
1134: FROM fnd_document_categories fdc
1135: WHERE category_id = p_category_id;
1136:
1137:
1138: END;

Line 1210: FROM fnd_document_categories

1206: x_attribute9, x_attribute10,
1207: x_attribute11, x_attribute12,
1208: x_attribute13, x_attribute14,
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,