APPS.IGF_GR_COD_DTLS_PKG dependencies on IGF_GR_COD_DTLS

Line 1: PACKAGE BODY igf_gr_cod_dtls_pkg AS

1: PACKAGE BODY igf_gr_cod_dtls_pkg AS
2: /* $Header: IGFGI22B.pls 120.0 2005/06/01 14:51:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_cod_dtls%ROWTYPE;

Line 5: old_references igf_gr_cod_dtls%ROWTYPE;

1: PACKAGE BODY igf_gr_cod_dtls_pkg AS
2: /* $Header: IGFGI22B.pls 120.0 2005/06/01 14:51:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_cod_dtls%ROWTYPE;
6: new_references igf_gr_cod_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_gr_cod_dtls%ROWTYPE;

2: /* $Header: IGFGI22B.pls 120.0 2005/06/01 14:51:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_gr_cod_dtls%ROWTYPE;
6: new_references igf_gr_cod_dtls%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 80: FROM igf_gr_cod_dtls

76: */
77:
78: CURSOR cur_old_ref_values IS
79: SELECT *
80: FROM igf_gr_cod_dtls
81: WHERE rowid = x_rowid;
82:
83: BEGIN
84:

Line 208: FROM igf_gr_cod_dtls

204: || (reverse chronological order - newest change first)
205: */
206: CURSOR cur_rowid IS
207: SELECT rowid
208: FROM igf_gr_cod_dtls
209: WHERE origination_id = x_origination_id
210: FOR UPDATE NOWAIT;
211:
212: lv_rowid cur_rowid%RowType;

Line 243: FROM igf_gr_cod_dtls

239: || (reverse chronological order - newest change first)
240: */
241: CURSOR cur_rowid IS
242: SELECT rowid
243: FROM igf_gr_cod_dtls
244: WHERE ((award_id = x_award_id));
245:
246: lv_rowid cur_rowid%RowType;
247:

Line 499: FROM igf_gr_cod_dtls

495: */
496:
497: CURSOR c IS
498: SELECT rowid
499: FROM igf_gr_cod_dtls
500: WHERE origination_id = x_origination_id;
501:
502: x_last_update_date DATE;
503: x_last_updated_by NUMBER;

Line 541: fnd_message.set_token ('ROUTINE', 'IGF_GR_COD_DTLS_PKG.INSERT_ROW');

537: x_program_update_date := SYSDATE;
538: END IF;
539: ELSE
540: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
541: fnd_message.set_token ('ROUTINE', 'IGF_GR_COD_DTLS_PKG.INSERT_ROW');
542: igs_ge_msg_stack.add;
543: app_exception.raise_exception;
544: END IF;
545:

Line 607: INSERT INTO igf_gr_cod_dtls (

603: x_last_updated_by => x_last_updated_by,
604: x_last_update_login => x_last_update_login
605: );
606:
607: INSERT INTO igf_gr_cod_dtls (
608: origination_id,
609: award_id,
610: document_id_txt,
611: base_id,

Line 916: FROM igf_gr_cod_dtls

912: phone_number_2,
913: phone_number_3,
914: email_address,
915: citzn_status_code
916: FROM igf_gr_cod_dtls
917: WHERE rowid = x_rowid
918: FOR UPDATE NOWAIT;
919:
920: tlinfo c1%ROWTYPE;

Line 1091: fnd_message.set_token ('ROUTINE', 'IGF_GR_COD_DTLS_PKG.UPDATE_ROW');

1087: x_last_update_login := -1;
1088: END IF;
1089: ELSE
1090: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1091: fnd_message.set_token ('ROUTINE', 'IGF_GR_COD_DTLS_PKG.UPDATE_ROW');
1092: igs_ge_msg_stack.add;
1093: app_exception.raise_exception;
1094: END IF;
1095:

Line 1171: UPDATE igf_gr_cod_dtls

1167: x_program_update_date := SYSDATE;
1168: END IF;
1169: END IF;
1170:
1171: UPDATE igf_gr_cod_dtls
1172: SET
1173: award_id = new_references.award_id,
1174: document_id_txt = new_references.document_id_txt,
1175: base_id = new_references.base_id,

Line 1365: FROM igf_gr_cod_dtls

1361: || (reverse chronological order - newest change first)
1362: */
1363: CURSOR c1 IS
1364: SELECT rowid
1365: FROM igf_gr_cod_dtls
1366: WHERE origination_id = x_origination_id;
1367:
1368: BEGIN
1369:

Line 1512: DELETE FROM igf_gr_cod_dtls

1508: p_action => 'DELETE',
1509: x_rowid => x_rowid
1510: );
1511:
1512: DELETE FROM igf_gr_cod_dtls
1513: WHERE rowid = x_rowid;
1514:
1515: IF (SQL%NOTFOUND) THEN
1516: RAISE NO_DATA_FOUND;

Line 1522: END igf_gr_cod_dtls_pkg;

1518:
1519: END delete_row;
1520:
1521:
1522: END igf_gr_cod_dtls_pkg;