APPS.IGS_FI_INVLN_INT_PKG dependencies on IGS_FI_INVLN_INT_ALL

Line 4: old_references igs_fi_invln_int_all%RowType;

1: PACKAGE BODY igs_fi_invln_int_pkg AS
2: /* $Header: IGSSI74B.pls 120.3 2005/07/08 05:25:19 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_invln_int_all%RowType;
5: new_references igs_fi_invln_int_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_fi_invln_int_all%RowType;

1: PACKAGE BODY igs_fi_invln_int_pkg AS
2: /* $Header: IGSSI74B.pls 120.3 2005/07/08 05:25:19 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_fi_invln_int_all%RowType;
5: new_references igs_fi_invln_int_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 81: FROM IGS_FI_INVLN_INT_ALL

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

Line 239: FROM igs_fi_invln_int_all

235: ***************************************************************/
236:
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM igs_fi_invln_int_all
240: WHERE invoice_lines_id = x_invoice_lines_id
241: FOR UPDATE NOWAIT;
242:
243: lv_rowid cur_rowid%RowType;

Line 355: FROM igs_fi_invln_int_all

351: ***************************************************************/
352:
353: CURSOR cur_rowid IS
354: SELECT rowid
355: FROM igs_fi_invln_int_all
356: WHERE invoice_id = x_invoice_id
357: AND line_number = x_line_number and ((l_rowid is null) or (rowid <> l_rowid))
358:
359: ;

Line 390: FROM igs_fi_invln_int_all

386: || (reverse chronological order - newest change first)
387: */
388: CURSOR cur_rowid IS
389: SELECT rowid
390: FROM igs_fi_invln_int_all
391: WHERE ((posting_id = x_posting_id));
392:
393: lv_rowid cur_rowid%RowType;
394:

Line 425: FROM igs_fi_invln_int_all

421: || (reverse chronological order - newest change first)
422: */
423: CURSOR cur_rowid IS
424: SELECT rowid
425: FROM igs_fi_invln_int_all
426: WHERE ((UOO_ID = x_UOO_ID ));
427:
428: lv_rowid cur_rowid%RowType;
429:

Line 709: cursor C is select ROWID from IGS_FI_INVLN_INT_ALL

705: msrinivi 17 Jul,2001 Added 2 new cols : error_string, error_account
706: (reverse chronological order - newest change first)
707: ***************************************************************/
708:
709: cursor C is select ROWID from IGS_FI_INVLN_INT_ALL
710: where INVOICE_LINES_ID= X_INVOICE_LINES_ID;
711:
712: X_LAST_UPDATE_DATE DATE ;
713: X_LAST_UPDATED_BY NUMBER ;

Line 815: INSERT INTO IGS_FI_INVLN_INT_ALL (

811: x_unit_type_id => x_unit_type_id,
812: x_unit_level => x_unit_level
813: );
814:
815: INSERT INTO IGS_FI_INVLN_INT_ALL (
816: INVOICE_ID
817: ,LINE_NUMBER
818: ,INVOICE_LINES_ID
819: ,ATTRIBUTE2

Line 1055: from IGS_FI_INVLN_INT_ALL

1051: , posting_control_id
1052: , unit_type_id
1053: , unit_level
1054:
1055: from IGS_FI_INVLN_INT_ALL
1056: where ROWID = X_ROWID
1057: for update nowait;
1058: tlinfo c1%rowtype;
1059: begin

Line 1364: update IGS_FI_INVLN_INT_ALL set

1360: x_unit_type_id => x_unit_type_id,
1361: x_unit_level => x_unit_level
1362: );
1363:
1364: update IGS_FI_INVLN_INT_ALL set
1365: INVOICE_ID = NEW_REFERENCES.INVOICE_ID,
1366: LINE_NUMBER = NEW_REFERENCES.LINE_NUMBER,
1367: ATTRIBUTE2 = NEW_REFERENCES.ATTRIBUTE2,
1368: CHG_ELEMENTS = NEW_REFERENCES.CHG_ELEMENTS,

Line 1494: cursor c1 is select ROWID from IGS_FI_INVLN_INT_ALL

1490: msrinivi 17 Jul,2001 Added 2 new cols : error_string, error_account
1491: (reverse chronological order - newest change first)
1492: ***************************************************************/
1493:
1494: cursor c1 is select ROWID from IGS_FI_INVLN_INT_ALL
1495: where INVOICE_LINES_ID= X_INVOICE_LINES_ID
1496: ;
1497: begin
1498: open c1;

Line 1627: delete from IGS_FI_INVLN_INT_ALL

1623: Before_DML (
1624: p_action => 'DELETE',
1625: x_rowid => X_ROWID
1626: );
1627: delete from IGS_FI_INVLN_INT_ALL
1628: where ROWID = X_ROWID;
1629: if (sql%notfound) then
1630: raise no_data_found;
1631: end if;