APPS.IGS_HE_POOUS_OU_CC_PKG dependencies on IGS_HE_POOUS_OU_CC

Line 1: PACKAGE BODY igs_he_poous_ou_cc_pkg AS

1: PACKAGE BODY igs_he_poous_ou_cc_pkg AS
2: /* $Header: IGSWI48B.pls 120.0 2005/06/01 21:52:32 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_poous_ou_cc%ROWTYPE;

Line 5: old_references igs_he_poous_ou_cc%ROWTYPE;

1: PACKAGE BODY igs_he_poous_ou_cc_pkg AS
2: /* $Header: IGSWI48B.pls 120.0 2005/06/01 21:52:32 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_poous_ou_cc%ROWTYPE;
6: new_references igs_he_poous_ou_cc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_poous_ou_cc%ROWTYPE;

2: /* $Header: IGSWI48B.pls 120.0 2005/06/01 21:52:32 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_poous_ou_cc%ROWTYPE;
6: new_references igs_he_poous_ou_cc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_he_poous_ou_cc

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igs_he_poous_ou_cc
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 142: FROM igs_he_poous_ou_cc

138: || (reverse chronological order - newest change first)
139: */
140: CURSOR cur_rowid IS
141: SELECT rowid
142: FROM igs_he_poous_ou_cc
143: WHERE hesa_poous_cc_id = x_hesa_poous_cc_id
144: FOR UPDATE NOWAIT;
145:
146: lv_rowid cur_rowid%RowType;

Line 179: FROM igs_he_poous_ou_cc

175: || (reverse chronological order - newest change first)
176: */
177: CURSOR cur_rowid IS
178: SELECT rowid
179: FROM igs_he_poous_ou_cc
180: WHERE hesa_poous_ou_id = x_hesa_poous_ou_id
181: AND cost_centre = x_cost_centre
182: AND subject = x_subject
183: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 216: FROM igs_he_poous_ou_cc

212: || (reverse chronological order - newest change first)
213: */
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM igs_he_poous_ou_cc
217: WHERE ((hesa_poous_ou_id = x_hesa_poous_ou_id));
218:
219: lv_rowid cur_rowid%RowType;
220:

Line 352: fnd_message.set_token ('ROUTINE', 'IGS_HE_POOUS_OU_CC_PKG.INSERT_ROW');

348: x_last_update_login := -1;
349: END IF;
350: ELSE
351: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
352: fnd_message.set_token ('ROUTINE', 'IGS_HE_POOUS_OU_CC_PKG.INSERT_ROW');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END IF;
356:

Line 374: INSERT INTO igs_he_poous_ou_cc (

370: x_last_updated_by => x_last_updated_by,
371: x_last_update_login => x_last_update_login
372: );
373:
374: INSERT INTO igs_he_poous_ou_cc (
375: hesa_poous_cc_id,
376: hesa_poous_ou_id,
377: cost_centre,
378: subject,

Line 386: igs_he_poous_ou_cc_s.NEXTVAL,

382: last_update_date,
383: last_updated_by,
384: last_update_login
385: ) VALUES (
386: igs_he_poous_ou_cc_s.NEXTVAL,
387: new_references.hesa_poous_ou_id,
388: new_references.cost_centre,
389: new_references.subject,
390: new_references.proportion,

Line 424: FROM igs_he_poous_ou_cc

420: hesa_poous_ou_id,
421: cost_centre,
422: subject,
423: proportion
424: FROM igs_he_poous_ou_cc
425: WHERE rowid = x_rowid
426: FOR UPDATE NOWAIT;
427:
428: tlinfo c1%ROWTYPE;

Line 500: fnd_message.set_token ('ROUTINE', 'IGS_HE_POOUS_OU_CC_PKG.UPDATE_ROW');

496: x_last_update_login := -1;
497: END IF;
498: ELSE
499: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
500: fnd_message.set_token ('ROUTINE', 'IGS_HE_POOUS_OU_CC_PKG.UPDATE_ROW');
501: igs_ge_msg_stack.add;
502: app_exception.raise_exception;
503: END IF;
504:

Line 520: UPDATE igs_he_poous_ou_cc

516: x_last_updated_by => x_last_updated_by,
517: x_last_update_login => x_last_update_login
518: );
519:
520: UPDATE igs_he_poous_ou_cc
521: SET
522: hesa_poous_ou_id = new_references.hesa_poous_ou_id,
523: cost_centre = new_references.cost_centre,
524: subject = new_references.subject,

Line 558: FROM igs_he_poous_ou_cc

554: || (reverse chronological order - newest change first)
555: */
556: CURSOR c1 IS
557: SELECT rowid
558: FROM igs_he_poous_ou_cc
559: WHERE hesa_poous_cc_id = x_hesa_poous_cc_id;
560:
561: BEGIN
562:

Line 613: DELETE FROM igs_he_poous_ou_cc

609: p_action => 'DELETE',
610: x_rowid => x_rowid
611: );
612:
613: DELETE FROM igs_he_poous_ou_cc
614: WHERE rowid = x_rowid;
615:
616: IF (SQL%NOTFOUND) THEN
617: RAISE NO_DATA_FOUND;

Line 623: END igs_he_poous_ou_cc_pkg;

619:
620: END delete_row;
621:
622:
623: END igs_he_poous_ou_cc_pkg;