eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_AW_AWD_CERT_RESPS_PKG dependencies on IGF_AW_AWD_CERT_RESPS

Line 1: PACKAGE BODY igf_aw_awd_cert_resps_pkg AS

1: PACKAGE BODY igf_aw_awd_cert_resps_pkg AS
2: /* $Header: IGFWI75B.pls 120.0 2005/09/09 17:13:40 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_cert_resps%ROWTYPE;

Line 5: old_references igf_aw_awd_cert_resps%ROWTYPE;

1: PACKAGE BODY igf_aw_awd_cert_resps_pkg AS
2: /* $Header: IGFWI75B.pls 120.0 2005/09/09 17:13:40 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_cert_resps%ROWTYPE;
6: new_references igf_aw_awd_cert_resps%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_awd_cert_resps%ROWTYPE;

2: /* $Header: IGFWI75B.pls 120.0 2005/09/09 17:13:40 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_cert_resps%ROWTYPE;
6: new_references igf_aw_awd_cert_resps%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM igf_aw_awd_cert_resps

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM igf_aw_awd_cert_resps
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 98: FROM igf_aw_awd_cert_resps

94: || (reverse chronological order - newest change first)
95: */
96: CURSOR cur_rowid IS
97: SELECT rowid
98: FROM igf_aw_awd_cert_resps
99: WHERE ci_cal_type = x_ci_cal_type
100: AND ci_sequence_number = x_ci_sequence_number
101: AND award_prd_cd = x_award_prd_cd
102: AND base_id = x_base_id

Line 137: cp_ci_cal_type igf_aw_awd_cert_resps.ci_cal_type%TYPE,

133: || (reverse chronological order - newest change first)
134: */
135:
136: CURSOR c_update_funds_auth(
137: cp_ci_cal_type igf_aw_awd_cert_resps.ci_cal_type%TYPE,
138: cp_ci_sequence_number igf_aw_awd_cert_resps.ci_sequence_number%TYPE,
139: cp_award_prd_cd igf_aw_awd_cert_resps.award_prd_cd%TYPE,
140: cp_awd_cert_code igf_aw_awd_cert_resps.awd_cert_code%TYPE
141: ) IS

Line 138: cp_ci_sequence_number igf_aw_awd_cert_resps.ci_sequence_number%TYPE,

134: */
135:
136: CURSOR c_update_funds_auth(
137: cp_ci_cal_type igf_aw_awd_cert_resps.ci_cal_type%TYPE,
138: cp_ci_sequence_number igf_aw_awd_cert_resps.ci_sequence_number%TYPE,
139: cp_award_prd_cd igf_aw_awd_cert_resps.award_prd_cd%TYPE,
140: cp_awd_cert_code igf_aw_awd_cert_resps.awd_cert_code%TYPE
141: ) IS
142: SELECT update_funds_auth_flag

Line 139: cp_award_prd_cd igf_aw_awd_cert_resps.award_prd_cd%TYPE,

135:
136: CURSOR c_update_funds_auth(
137: cp_ci_cal_type igf_aw_awd_cert_resps.ci_cal_type%TYPE,
138: cp_ci_sequence_number igf_aw_awd_cert_resps.ci_sequence_number%TYPE,
139: cp_award_prd_cd igf_aw_awd_cert_resps.award_prd_cd%TYPE,
140: cp_awd_cert_code igf_aw_awd_cert_resps.awd_cert_code%TYPE
141: ) IS
142: SELECT update_funds_auth_flag
143: FROM igf_aw_award_certs

Line 140: cp_awd_cert_code igf_aw_awd_cert_resps.awd_cert_code%TYPE

136: CURSOR c_update_funds_auth(
137: cp_ci_cal_type igf_aw_awd_cert_resps.ci_cal_type%TYPE,
138: cp_ci_sequence_number igf_aw_awd_cert_resps.ci_sequence_number%TYPE,
139: cp_award_prd_cd igf_aw_awd_cert_resps.award_prd_cd%TYPE,
140: cp_awd_cert_code igf_aw_awd_cert_resps.awd_cert_code%TYPE
141: ) IS
142: SELECT update_funds_auth_flag
143: FROM igf_aw_award_certs
144: WHERE ci_cal_type = cp_ci_cal_type

Line 421: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_CERT_RESPS_PKG.INSERT_ROW');

417: x_last_update_login := -1;
418: END IF;
419: ELSE
420: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
421: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_CERT_RESPS_PKG.INSERT_ROW');
422: igs_ge_msg_stack.add;
423: app_exception.raise_exception;
424: END IF;
425:

Line 443: INSERT INTO igf_aw_awd_cert_resps (

439: x_last_updated_by => x_last_updated_by,
440: x_last_update_login => x_last_update_login
441: );
442:
443: INSERT INTO igf_aw_awd_cert_resps (
444: ci_cal_type,
445: ci_sequence_number,
446: award_prd_cd,
447: base_id,

Line 500: FROM igf_aw_awd_cert_resps

496: CURSOR c1 IS
497: SELECT
498: response_txt,
499: object_version_number
500: FROM igf_aw_awd_cert_resps
501: WHERE rowid = x_rowid
502: FOR UPDATE NOWAIT;
503:
504: tlinfo c1%ROWTYPE;

Line 576: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_CERT_RESPS_PKG.UPDATE_ROW');

572: x_last_update_login := -1;
573: END IF;
574: ELSE
575: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
576: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWD_CERT_RESPS_PKG.UPDATE_ROW');
577: igs_ge_msg_stack.add;
578: app_exception.raise_exception;
579: END IF;
580:

Line 598: UPDATE igf_aw_awd_cert_resps

594: x_last_updated_by => x_last_updated_by,
595: x_last_update_login => x_last_update_login
596: );
597:
598: UPDATE igf_aw_awd_cert_resps
599: SET
600: response_txt = new_references.response_txt,
601: object_version_number = new_references.object_version_number,
602: last_update_date = x_last_update_date,

Line 640: FROM igf_aw_awd_cert_resps

636: || (reverse chronological order - newest change first)
637: */
638: CURSOR c1 IS
639: SELECT rowid
640: FROM igf_aw_awd_cert_resps
641: WHERE ci_cal_type = x_ci_cal_type
642: AND ci_sequence_number = x_ci_sequence_number
643: AND award_prd_cd = x_award_prd_cd
644: AND base_id = x_base_id

Line 703: DELETE FROM igf_aw_awd_cert_resps

699: p_action => 'DELETE',
700: x_rowid => x_rowid
701: );
702:
703: DELETE FROM igf_aw_awd_cert_resps
704: WHERE rowid = x_rowid;
705:
706: IF (SQL%NOTFOUND) THEN
707: RAISE NO_DATA_FOUND;

Line 713: END igf_aw_awd_cert_resps_pkg;

709:
710: END delete_row;
711:
712:
713: END igf_aw_awd_cert_resps_pkg;