APPS.IGF_SE_AUTH_PKG dependencies on IGF_SE_AUTH

Line 1: PACKAGE BODY igf_se_auth_pkg AS

1: PACKAGE BODY igf_se_auth_pkg AS
2: /* $Header: IGFSI04B.pls 120.0 2005/06/03 14:28:02 appldev noship $ */
3: /*=======================================================================+
4: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
5: | All rights reserved. |

Line 9: | PL/SQL body for package: igf_se_auth_PKG

5: | All rights reserved. |
6: +=======================================================================+
7: | |
8: | DESCRIPTION |
9: | PL/SQL body for package: igf_se_auth_PKG
10: | |
11: | NOTES |
12: | |
13: | This package has a flag on the end of some of the procedures called |

Line 36: old_references igf_se_auth%ROWTYPE;

32: | notification_date |
33: *=======================================================================*/
34:
35: l_rowid VARCHAR2(25);
36: old_references igf_se_auth%ROWTYPE;
37: new_references igf_se_auth%ROWTYPE;
38:
39: PROCEDURE set_column_values (
40: p_action IN VARCHAR2,

Line 37: new_references igf_se_auth%ROWTYPE;

33: *=======================================================================*/
34:
35: l_rowid VARCHAR2(25);
36: old_references igf_se_auth%ROWTYPE;
37: new_references igf_se_auth%ROWTYPE;
38:
39: PROCEDURE set_column_values (
40: p_action IN VARCHAR2,
41: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 93: FROM IGF_SE_AUTH

89: */
90:
91: CURSOR cur_old_ref_values IS
92: SELECT *
93: FROM IGF_SE_AUTH
94: WHERE rowid = x_rowid;
95:
96: BEGIN
97:

Line 210: FROM igf_se_auth

206: || (reverse chronological order - newest change first)
207: */
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM igf_se_auth
211: WHERE sequence_no = x_sequence_no
212: FOR UPDATE NOWAIT;
213:
214: lv_rowid cur_rowid%RowType;

Line 413: FROM igf_se_auth

409: || (reverse chronological order - newest change first)
410: */
411: CURSOR c IS
412: SELECT rowid
413: FROM igf_se_auth
414: WHERE sequence_no = x_sequence_no;
415:
416: x_last_update_date DATE;
417: x_last_updated_by NUMBER;

Line 457: SELECT igf_se_auth_s.NEXTVAL

453: igs_ge_msg_stack.add;
454: app_exception.raise_exception;
455: END IF;
456:
457: SELECT igf_se_auth_s.NEXTVAL
458: INTO x_sequence_no
459: FROM dual;
460:
461: before_dml(

Line 504: INSERT INTO igf_se_auth (

500: x_authorization_date => x_authorization_date,
501: x_notification_date => x_notification_date
502: );
503:
504: INSERT INTO igf_se_auth (
505: sequence_no,
506: auth_id,
507: flag,
508: person_id,

Line 682: FROM igf_se_auth

678: aw_sequence_number,
679: award_id,
680: authorization_date,
681: notification_date
682: FROM igf_se_auth
683: WHERE rowid = x_rowid
684: FOR UPDATE NOWAIT;
685:
686: tlinfo c1%ROWTYPE;

Line 879: UPDATE igf_se_auth

875: x_program_update_date := SYSDATE;
876: END IF;
877: END IF;
878:
879: UPDATE igf_se_auth
880: SET
881: auth_id = new_references.auth_id,
882: flag = new_references.flag,
883: person_id = new_references.person_id,

Line 976: FROM igf_se_auth

972: || (reverse chronological order - newest change first)
973: */
974: CURSOR c1 IS
975: SELECT rowid
976: FROM igf_se_auth
977: WHERE sequence_no = x_sequence_no;
978:
979: BEGIN
980:

Line 1087: DELETE FROM igf_se_auth

1083: p_action => 'DELETE',
1084: x_rowid => x_rowid
1085: );
1086:
1087: DELETE FROM igf_se_auth
1088: WHERE rowid = x_rowid;
1089:
1090: IF (SQL%NOTFOUND) THEN
1091: RAISE NO_DATA_FOUND;

Line 1097: END igf_se_auth_pkg;

1093:
1094: END delete_row;
1095:
1096:
1097: END igf_se_auth_pkg;