APPS.GR_DOCUMENT_STRUCTURES_PKG dependencies on GR_DOCUMENT_STRUCTURES

Line 1: PACKAGE BODY GR_DOCUMENT_STRUCTURES_PKG AS

1: PACKAGE BODY GR_DOCUMENT_STRUCTURES_PKG AS
2: /*$Header: GRHIDSB.pls 115.9 2002/10/28 23:07:04 mgrosser ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 147: INSERT INTO gr_document_structures

143: IF FND_API.To_Boolean(l_key_exists) THEN
144: RAISE Label_Exists_Error;
145: END IF;
146:
147: INSERT INTO gr_document_structures
148: (document_structures_seqno,
149: document_headings_seqno,
150: label_code,
151: phrase_group_code,

Line 193: (gr_document_structures_s.nextval,

189: last_updated_by,
190: last_update_date,
191: last_update_login)
192: VALUES
193: (gr_document_structures_s.nextval,
194: p_document_headings_seqno,
195: p_label_code,
196: p_phrase_group_code,
197: p_phrase_code,

Line 240: SELECT gr_document_structures_s.currval

236: p_last_update_login);
237:
238: /* Get the assigned sequence number */
239:
240: SELECT gr_document_structures_s.currval
241: INTO l_current_seq
242: FROM dual;
243:
244: /* Now get the row id of the inserted record */

Line 457: UPDATE gr_document_structures

453:
454: IF l_return_status <> 'S' THEN
455: RAISE Foreign_Key_Error;
456: ELSE
457: UPDATE gr_document_structures
458: SET document_structures_seqno = p_document_structures_seqno,
459: document_headings_seqno = p_document_headings_seqno,
460: label_code = p_label_code,
461: phrase_group_code = p_phrase_group_code,

Line 606: UPDATE gr_document_structures

602: x_msg_data := NULL;
603:
604: /* Update the table */
605:
606: UPDATE gr_document_structures
607: SET display_order = p_display_order,
608: last_updated_by = p_last_updated_by,
609: last_update_date = p_last_update_date,
610: last_update_login = p_last_update_login

Line 732: FROM gr_document_structures

728:
729: CURSOR c_lock_document
730: IS
731: SELECT *
732: FROM gr_document_structures
733: WHERE rowid = p_rowid
734: FOR UPDATE NOWAIT;
735: LockDocumentRcd c_lock_document%ROWTYPE;
736:

Line 937: DELETE FROM gr_document_structures

933: IF l_return_status <> 'S' THEN
934: RAISE Check_Integrity_Error;
935: END IF;
936:
937: DELETE FROM gr_document_structures
938: -- WHERE rowid = p_rowid;
939: WHERE document_structures_seqno = p_document_structures_seqno;
940:
941: /* Check the commit flag and if set, then commit the work. */

Line 1284: FROM gr_document_structures ds

1280:
1281: CURSOR c_get_structures_rowid
1282: IS
1283: SELECT ds.rowid
1284: FROM gr_document_structures ds
1285: WHERE ds.document_structures_seqno = p_document_structures_seqno
1286: AND ds.document_headings_seqno = p_document_headings_seqno;
1287: StructureRecord c_get_structures_rowid%ROWTYPE;
1288:

Line 1318: END GR_DOCUMENT_STRUCTURES_PKG;

1314: END IF;
1315:
1316: END Check_Primary_Key;
1317:
1318: END GR_DOCUMENT_STRUCTURES_PKG;