APPS.GR_DOCUMENT_RTK_PKG dependencies on GR_DOCUMENT_RTK

Line 1: PACKAGE BODY GR_DOCUMENT_RTK_PKG AS

1: PACKAGE BODY GR_DOCUMENT_RTK_PKG AS
2: /*$Header: GRHIDRKB.pls 120.1 2006/01/10 11:45:37 methomas noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 75: INSERT INTO gr_document_rtk

71: IF FND_API.To_Boolean(l_key_exists) THEN
72: RAISE Label_Exists_Error;
73: END IF;
74:
75: INSERT INTO gr_document_rtk
76: (document_code,
77: location_segment_qualifier,
78: location_segment_value,
79: parent_segment_id,

Line 236: UPDATE gr_document_rtk

232:
233: IF l_return_status <> 'S' THEN
234: RAISE Foreign_Key_Error;
235: ELSE
236: UPDATE gr_document_rtk
237: SET document_code = p_document_code,
238: location_segment_qualifier = p_location_segment_qualifier,
239: location_segment_value = p_location_segment_value,
240: parent_segment_id = p_parent_segment_id,

Line 346: FROM gr_document_rtk

342:
343: CURSOR c_lock_document
344: IS
345: SELECT *
346: FROM gr_document_rtk
347: WHERE rowid = p_rowid
348: FOR UPDATE NOWAIT;
349: LockDocumentRcd c_lock_document%ROWTYPE;
350:

Line 480: DELETE FROM gr_document_rtk

476: IF l_return_status <> 'S' THEN
477: RAISE Check_Integrity_Error;
478: END IF;
479:
480: DELETE FROM gr_document_rtk
481: WHERE rowid = p_rowid;
482:
483: /* Check the commit flag and if set, then commit the work. */
484:

Line 566: DELETE FROM gr_document_rtk

562: x_oracle_error := 0;
563: x_msg_data := NULL;
564: l_msg_token := p_document_code;
565:
566: DELETE FROM gr_document_rtk
567: WHERE document_code = p_document_code;
568:
569: IF FND_API.To_Boolean(p_commit) THEN
570: COMMIT WORK;

Line 760: FROM gr_document_rtk dr

756:
757: CURSOR c_get_document_rowid
758: IS
759: SELECT dr.rowid
760: FROM gr_document_rtk dr
761: WHERE dr.document_code = p_document_code;
762: DocumentRecord c_get_document_rowid%ROWTYPE;
763:
764: BEGIN

Line 793: END GR_DOCUMENT_RTK_PKG;

789: END IF;
790:
791: END Check_Primary_Key;
792:
793: END GR_DOCUMENT_RTK_PKG;