APPS.SO_ATT dependencies on SO_NOTES

Line 78: FROM so_notes

74: CURSOR check_unique IS
75: SELECT 1
76: FROM sys.dual
77: WHERE EXISTS (SELECT 1
78: FROM so_notes
79: WHERE name = x_doc_desc);
80: BEGIN
81:
82: x_language := fnd_global.current_language;

Line 93: -- determine if description is already used in so_notes

89: OPEN doc;
90: FETCH doc INTO x_doc_desc;
91: CLOSE doc;
92:
93: -- determine if description is already used in so_notes
94: -- so_notes has a non-unique index on name, but the
95: -- form enforces uniqueness on name
96: OPEN check_unique;
97: FETCH check_unique INTO x_check;

Line 94: -- so_notes has a non-unique index on name, but the

90: FETCH doc INTO x_doc_desc;
91: CLOSE doc;
92:
93: -- determine if description is already used in so_notes
94: -- so_notes has a non-unique index on name, but the
95: -- form enforces uniqueness on name
96: OPEN check_unique;
97: FETCH check_unique INTO x_check;
98: IF (check_unique%NOTFOUND) THEN

Line 149: FROM so_notes

145: */
146:
147: SELECT NOTE_TYPE_CODE, OVERRIDE_ALLOWED_FLAG
148: INTO x_note_type_code, x_override_flag
149: FROM so_notes
150: WHERE note_id = p_note_id;
151:
152: If (x_note_type_code = 'SN') Then
153: If (x_override_flag = 'Y') Then

Line 436: FROM so_notes

432: x_attribute8, x_attribute9,
433: x_attribute10, x_attribute11,
434: x_attribute12, x_attribute13,
435: x_attribute14, x_attribute15
436: FROM so_notes
437: WHERE document_id = p_document_id;
438:
439: x_document_usage_type := get_document_usage_type (x_note_id);
440:

Line 444: FROM so_notes

440:
441: BEGIN
442: SELECT note
443: INTO x_note
444: FROM so_notes
445: WHERE document_id = p_document_id;
446:
447: x_datatype_id := 1; -- default is short text;
448:

Line 615: FROM so_notes

611: x_attribute10, x_attribute11,
612: x_attribute12, x_attribute13,
613: x_attribute14, x_attribute15,
614: x_override_flag
615: FROM so_notes
616: WHERE
617: document_id = p_document_id;
618:
619: x_document_usage_type := get_document_usage_type (x_note_id);

Line 624: FROM so_notes

620:
621: BEGIN
622: SELECT note
623: INTO x_note
624: FROM so_notes
625: WHERE document_id = p_document_id;
626:
627: EXCEPTION
628: WHEN VALUE_ERROR THEN -- long exceeds 32760

Line 756: FROM so_notes

752: BEGIN
753:
754: SELECT document_id
755: INTO x_document_id
756: FROM so_notes
757: WHERE note_id = p_note_id;
758:
759: x_entity_name := get_entity_name(p_header_id, p_line_id);
760:

Line 844: FROM so_notes

840: BEGIN
841:
842: SELECT document_id
843: INTO x_document_id
844: FROM so_notes
845: WHERE note_id = p_note_id;
846:
847: -- you can only update flex fields and sequence number.
848: UPDATE fnd_attached_documents