APPS.RG_ROW_SEGMENT_SEQUENCES_PKG dependencies on RG_ROW_SEGMENT_SEQUENCES

Line 1: PACKAGE BODY RG_ROW_SEGMENT_SEQUENCES_PKG AS

1: PACKAGE BODY RG_ROW_SEGMENT_SEQUENCES_PKG AS
2: /* $Header: rgirssqb.pls 120.3 2005/02/14 23:53:35 ticheng ship $ */
3: --
4: --
5: -- PUBLIC FUNCTIONS

Line 14: SELECT rg_row_segment_sequences_s.nextval

10: RETURN NUMBER
11: IS
12: new_sequence_number NUMBER;
13: BEGIN
14: SELECT rg_row_segment_sequences_s.nextval
15: INTO new_sequence_number
16: FROM dual;
17:
18: RETURN(new_sequence_number);

Line 30: FROM rg_row_segment_sequences

26: rec_returned NUMBER;
27: BEGIN
28: SELECT count(*)
29: INTO rec_returned
30: FROM rg_row_segment_sequences
31: WHERE row_order_id = cur_row_order_id
32: AND row_segment_sequence_id <> cur_row_segment_sequence_id
33: AND segment_sequence = new_sequence;
34:

Line 52: FROM rg_row_segment_sequences

48: rec_returned NUMBER;
49: BEGIN
50: SELECT count(*)
51: INTO rec_returned
52: FROM rg_row_segment_sequences
53: WHERE row_order_id = cur_row_order_id
54: AND row_segment_sequence_id <> cur_row_segment_sequence_id
55: AND application_column_name = new_application_column_name;
56:

Line 99: CURSOR C IS SELECT rowid FROM rg_row_segment_sequences

95: X_attribute13 VARCHAR2,
96: X_attribute14 VARCHAR2,
97: X_attribute15 VARCHAR2
98: ) IS
99: CURSOR C IS SELECT rowid FROM rg_row_segment_sequences
100: WHERE row_segment_sequence_id = X_row_segment_sequence_id;
101: BEGIN
102: INSERT INTO rg_row_segment_sequences
103: (application_id ,

Line 102: INSERT INTO rg_row_segment_sequences

98: ) IS
99: CURSOR C IS SELECT rowid FROM rg_row_segment_sequences
100: WHERE row_segment_sequence_id = X_row_segment_sequence_id;
101: BEGIN
102: INSERT INTO rg_row_segment_sequences
103: (application_id ,
104: row_order_id ,
105: row_segment_sequence_id ,
106: segment_sequence ,

Line 205: UPDATE rg_row_segment_sequences

201: X_attribute14 VARCHAR2,
202: X_attribute15 VARCHAR2
203: ) IS
204: BEGIN
205: UPDATE rg_row_segment_sequences
206: SET application_id = X_application_id ,
207: row_order_id = X_row_order_id ,
208: row_segment_sequence_id = X_row_segment_sequence_id ,
209: segment_sequence = X_segment_sequence ,

Line 270: FROM rg_row_segment_sequences

266: X_attribute15 VARCHAR2
267: ) IS
268: CURSOR C IS
269: SELECT *
270: FROM rg_row_segment_sequences
271: WHERE rowid = X_rowid
272: FOR UPDATE OF segment_sequence NOWAIT;
273: Recinfo C%ROWTYPE;
274: BEGIN

Line 370: DELETE FROM rg_row_segment_sequences

366: END lock_row;
367:
368: PROCEDURE delete_row(X_rowid VARCHAR2) IS
369: BEGIN
370: DELETE FROM rg_row_segment_sequences
371: WHERE rowid = X_rowid;
372:
373: IF (SQL%NOTFOUND) THEN
374: RAISE NO_DATA_FOUND;

Line 378: END RG_ROW_SEGMENT_SEQUENCES_PKG;

374: RAISE NO_DATA_FOUND;
375: END IF;
376: END delete_row;
377:
378: END RG_ROW_SEGMENT_SEQUENCES_PKG;