APPS.PO_ATT dependencies on PO_NOTES

Line 394: FROM po_notes

390: x_attribute8, x_attribute9,
391: x_attribute10, x_attribute11,
392: x_attribute12, x_attribute13,
393: x_attribute14, x_attribute15
394: FROM po_notes
395: WHERE po_note_id = p_note_id;
396:
397: BEGIN
398: SELECT note

Line 400: FROM po_notes

396:
397: BEGIN
398: SELECT note
399: INTO x_note
400: FROM po_notes
401: WHERE po_note_id = p_note_id;
402:
403: /* Mdas, 3/12/97, Bug#441412, make the default datatype as long text. */
404:

Line 409: x_note := 'R10-POXNOEEN.inp-#FND STORELONG PO_NOTES NOTE PO_NOTE_ID' ||

405: -- x_datatype_id := 1; -- default is short text; Commented out by Mdas
406: x_datatype_id := 2;
407:
408: IF x_note IS NULL THEN
409: x_note := 'R10-POXNOEEN.inp-#FND STORELONG PO_NOTES NOTE PO_NOTE_ID' ||
410: ' should update this text later';
411: ELSIF length (x_note) >= 1900 THEN -- leave 10 safe chars
412: x_datatype_id := 2; -- long text
413: END IF;

Line 418: 'Refer to po_notes. ' ||

414:
415: EXCEPTION
416: WHEN VALUE_ERROR THEN -- long exceeds 32760
417: x_note := 'This long text exceeds 32760. ' ||
418: 'Refer to po_notes. ' ||
419: 'note id = ' || to_char(p_note_id);
420: x_datatype_id := 2;
421: WHEN OTHERS THEN
422: RAISE;

Line 579: FROM po_notes

575: x_attribute8, x_attribute9,
576: x_attribute10, x_attribute11,
577: x_attribute12, x_attribute13,
578: x_attribute14, x_attribute15
579: FROM po_notes
580: WHERE
581: po_note_id = p_note_id;
582:
583: BEGIN

Line 586: FROM po_notes

582:
583: BEGIN
584: SELECT note
585: INTO x_note
586: FROM po_notes
587: WHERE po_note_id = p_note_id;
588:
589: EXCEPTION
590: WHEN VALUE_ERROR THEN -- long exceeds 32760

Line 592: 'Refer to po_notes. ' ||

588:
589: EXCEPTION
590: WHEN VALUE_ERROR THEN -- long exceeds 32760
591: x_note := 'This long text exceeds 32760. ' ||
592: 'Refer to po_notes. ' ||
593: 'note id = ' || to_char(p_note_id);
594: WHEN OTHERS THEN
595: RAISE;
596: END;

Line 710: FROM po_notes

706: BEGIN
707:
708: SELECT document_id
709: INTO x_document_id
710: FROM po_notes
711: WHERE po_note_id = p_po_note_id;
712:
713: x_entity_name := get_entity_name ( p_table_name );
714:

Line 789: FROM po_notes

785: BEGIN
786:
787: SELECT document_id
788: INTO x_document_id
789: FROM po_notes
790: WHERE po_note_id = p_po_note_id;
791:
792: x_entity_name := get_entity_name ( p_table_name );
793:

Line 883: FROM po_notes

879: BEGIN
880:
881: SELECT document_id
882: INTO x_document_id
883: FROM po_notes
884: WHERE po_note_id = p_po_note_id;
885:
886: -- you can only update flex fields and sequence number.
887: UPDATE fnd_attached_documents