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.

APPS.IGS_FI_INV_WAV_DET_PKG dependencies on IGS_FI_INV_WAV_DET

Line 1: PACKAGE BODY igs_fi_inv_wav_det_pkg AS

1: PACKAGE BODY igs_fi_inv_wav_det_pkg AS
2: /* $Header: IGSSIB9B.pls 115.4 2002/11/29 04:05:58 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_inv_wav_det%ROWTYPE;

Line 5: old_references igs_fi_inv_wav_det%ROWTYPE;

1: PACKAGE BODY igs_fi_inv_wav_det_pkg AS
2: /* $Header: IGSSIB9B.pls 115.4 2002/11/29 04:05:58 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_inv_wav_det%ROWTYPE;
6: new_references igs_fi_inv_wav_det%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_inv_wav_det%ROWTYPE;

2: /* $Header: IGSSIB9B.pls 115.4 2002/11/29 04:05:58 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_inv_wav_det%ROWTYPE;
6: new_references igs_fi_inv_wav_det%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_FI_INV_WAV_DET

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

Line 74: FUNCTION validate_overlapping(p_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,

70:
71: END set_column_values;
72:
73:
74: FUNCTION validate_overlapping(p_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
75: p_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
76: p_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
77: p_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
78: p_row_id VARCHAR2)

Line 75: p_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,

71: END set_column_values;
72:
73:
74: FUNCTION validate_overlapping(p_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
75: p_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
76: p_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
77: p_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
78: p_row_id VARCHAR2)
79: RETURN BOOLEAN AS

Line 76: p_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,

72:
73:
74: FUNCTION validate_overlapping(p_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
75: p_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
76: p_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
77: p_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
78: p_row_id VARCHAR2)
79: RETURN BOOLEAN AS
80: /*

Line 77: p_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,

73:
74: FUNCTION validate_overlapping(p_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
75: p_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
76: p_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
77: p_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
78: p_row_id VARCHAR2)
79: RETURN BOOLEAN AS
80: /*
81: || Created By : sarakshi

Line 90: CURSOR cur_overlapping_u(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,

86: || Who When What
87: || (reverse chronological order - newest change first)
88: */
89:
90: CURSOR cur_overlapping_u(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
91: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
92: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
93: cp_row_id VARCHAR2 ) IS
94: SELECT 'X'

Line 91: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,

87: || (reverse chronological order - newest change first)
88: */
89:
90: CURSOR cur_overlapping_u(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
91: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
92: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
93: cp_row_id VARCHAR2 ) IS
94: SELECT 'X'
95: FROM igs_fi_inv_wav_det

Line 92: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,

88: */
89:
90: CURSOR cur_overlapping_u(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
91: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
92: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
93: cp_row_id VARCHAR2 ) IS
94: SELECT 'X'
95: FROM igs_fi_inv_wav_det
96: WHERE invoice_id = cp_invoice_id

Line 95: FROM igs_fi_inv_wav_det

91: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
92: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
93: cp_row_id VARCHAR2 ) IS
94: SELECT 'X'
95: FROM igs_fi_inv_wav_det
96: WHERE invoice_id = cp_invoice_id
97: AND balance_type = cp_balance_type
98: AND cp_start_dt >= start_dt AND cp_start_dt <= NVL(end_dt,cp_start_dt)
99: AND (rowid <> cp_row_id OR (cp_row_id IS NULL));

Line 101: CURSOR cur_overlapping_u1(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,

97: AND balance_type = cp_balance_type
98: AND cp_start_dt >= start_dt AND cp_start_dt <= NVL(end_dt,cp_start_dt)
99: AND (rowid <> cp_row_id OR (cp_row_id IS NULL));
100:
101: CURSOR cur_overlapping_u1(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
102: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
103: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
104: cp_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
105: cp_row_id VARCHAR2 ) IS

Line 102: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,

98: AND cp_start_dt >= start_dt AND cp_start_dt <= NVL(end_dt,cp_start_dt)
99: AND (rowid <> cp_row_id OR (cp_row_id IS NULL));
100:
101: CURSOR cur_overlapping_u1(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
102: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
103: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
104: cp_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
105: cp_row_id VARCHAR2 ) IS
106: SELECT 'X'

Line 103: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,

99: AND (rowid <> cp_row_id OR (cp_row_id IS NULL));
100:
101: CURSOR cur_overlapping_u1(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
102: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
103: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
104: cp_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
105: cp_row_id VARCHAR2 ) IS
106: SELECT 'X'
107: FROM igs_fi_inv_wav_det

Line 104: cp_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,

100:
101: CURSOR cur_overlapping_u1(cp_invoice_id IGS_FI_INV_WAV_DET.invoice_id%TYPE ,
102: cp_balance_type IGS_FI_INV_WAV_DET.balance_type%TYPE,
103: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
104: cp_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
105: cp_row_id VARCHAR2 ) IS
106: SELECT 'X'
107: FROM igs_fi_inv_wav_det
108: WHERE invoice_id = cp_invoice_id

Line 107: FROM igs_fi_inv_wav_det

103: cp_start_dt IGS_FI_INV_WAV_DET.start_dt%TYPE,
104: cp_end_dt IGS_FI_INV_WAV_DET.end_dt%TYPE,
105: cp_row_id VARCHAR2 ) IS
106: SELECT 'X'
107: FROM igs_fi_inv_wav_det
108: WHERE invoice_id = cp_invoice_id
109: AND balance_type = cp_balance_type
110: AND (cp_end_dt >= start_dt OR (cp_end_dt IS NULL)) AND cp_start_dt <= start_dt
111: AND (rowid <> cp_row_id OR (cp_row_id IS NULL));

Line 195: FROM igs_fi_inv_wav_det

191: || (reverse chronological order - newest change first)
192: */
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM igs_fi_inv_wav_det
196: WHERE invoice_id = x_invoice_id
197: AND balance_type = x_balance_type
198: AND start_dt = x_start_dt
199: FOR UPDATE NOWAIT;

Line 232: FROM igs_fi_inv_wav_det

228: || (reverse chronological order - newest change first)
229: */
230: CURSOR cur_rowid IS
231: SELECT rowid
232: FROM igs_fi_inv_wav_det
233: WHERE ((invoice_id = x_invoice_id));
234:
235: lv_rowid cur_rowid%RowType;
236:

Line 354: FROM igs_fi_inv_wav_det

350: || (reverse chronological order - newest change first)
351: */
352: CURSOR c IS
353: SELECT rowid
354: FROM igs_fi_inv_wav_det
355: WHERE invoice_id = x_invoice_id
356: AND balance_type = x_balance_type
357: AND start_dt = x_start_dt;
358:

Line 414: INSERT INTO igs_fi_inv_wav_det (

410: x_last_updated_by => x_last_updated_by,
411: x_last_update_login => x_last_update_login
412: );
413:
414: INSERT INTO igs_fi_inv_wav_det (
415: invoice_id,
416: balance_type,
417: start_dt,
418: end_dt,

Line 474: FROM igs_fi_inv_wav_det

470: */
471: CURSOR c1 IS
472: SELECT
473: end_dt
474: FROM igs_fi_inv_wav_det
475: WHERE rowid = x_rowid
476: FOR UPDATE NOWAIT;
477:
478: tlinfo c1%ROWTYPE;

Line 582: UPDATE igs_fi_inv_wav_det

578: x_program_update_date := SYSDATE;
579: END IF;
580: END IF;
581:
582: UPDATE igs_fi_inv_wav_det
583: SET
584: end_dt = new_references.end_dt,
585: last_update_date = x_last_update_date,
586: last_updated_by = x_last_updated_by,

Line 620: FROM igs_fi_inv_wav_det

616: || (reverse chronological order - newest change first)
617: */
618: CURSOR c1 IS
619: SELECT rowid
620: FROM igs_fi_inv_wav_det
621: WHERE invoice_id = x_invoice_id
622: AND balance_type = x_balance_type
623: AND start_dt = x_start_dt;
624:

Line 675: DELETE FROM igs_fi_inv_wav_det

671: p_action => 'DELETE',
672: x_rowid => x_rowid
673: );
674:
675: DELETE FROM igs_fi_inv_wav_det
676: WHERE rowid = x_rowid;
677:
678: IF (SQL%NOTFOUND) THEN
679: RAISE NO_DATA_FOUND;

Line 685: END igs_fi_inv_wav_det_pkg;

681:
682: END delete_row;
683:
684:
685: END igs_fi_inv_wav_det_pkg;