[Home] [Help]
1: PACKAGE BODY GR_DOCUMENT_DETAILS_PKG AS
2: /*$Header: GRHIDDB.pls 115.6 2002/10/28 19:40:44 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,
75: IF FND_API.To_Boolean(l_key_exists) THEN
76: RAISE Label_Exists_Error;
77: END IF;
78:
79: INSERT INTO gr_document_details
80: (text_line_number,
81: document_text_id,
82: print_font,
83: print_size,
245:
246: IF l_return_status <> 'S' THEN
247: RAISE Foreign_Key_Error;
248: ELSE
249: UPDATE gr_document_details
250: SET text_line_number = p_text_line_number,
251: document_text_id = p_document_text_id,
252: print_font = p_print_font,
253: print_size = p_print_size,
359:
360: CURSOR c_lock_document_details
361: IS
362: SELECT *
363: FROM gr_document_details
364: WHERE rowid = p_rowid
365: FOR UPDATE NOWAIT;
366: LockDetailRcd c_lock_document_details%ROWTYPE;
367:
497: IF l_return_status <> 'S' THEN
498: RAISE Check_Integrity_Error;
499: END IF;
500:
501: DELETE FROM gr_document_details
502: WHERE rowid = p_rowid;
503:
504: /* Check the commit flag and if set, then commit the work. */
505:
583: x_return_status := 'S';
584: x_oracle_error := 0;
585: x_msg_data := NULL;
586:
587: DELETE FROM gr_document_details
588: WHERE document_text_id = p_document_text_id;
589:
590: IF FND_API.To_Boolean(p_commit) THEN
591: COMMIT WORK;
774:
775: CURSOR c_get_print_rowid
776: IS
777: SELECT dd.rowid
778: FROM gr_document_details dd
779: WHERE dd.document_text_id = p_document_text_id
780: AND dd.text_line_number = p_text_line_number;
781: PrintRecord c_get_print_rowid%ROWTYPE;
782:
808: END IF;
809:
810: END Check_Primary_Key;
811:
812: END GR_DOCUMENT_DETAILS_PKG;