APPS.IGS_UC_APP_CLEARING_PKG dependencies on IGS_UC_APP_CLEARING

Line 1: PACKAGE BODY igs_uc_app_clearing_pkg AS

1: PACKAGE BODY igs_uc_app_clearing_pkg AS
2: /* $Header: IGSXI04B.pls 115.7 2003/06/11 10:28:02 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_clearing%ROWTYPE;

Line 5: old_references igs_uc_app_clearing%ROWTYPE;

1: PACKAGE BODY igs_uc_app_clearing_pkg AS
2: /* $Header: IGSXI04B.pls 115.7 2003/06/11 10:28:02 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_clearing%ROWTYPE;
6: new_references igs_uc_app_clearing%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_app_clearing%ROWTYPE;

2: /* $Header: IGSXI04B.pls 115.7 2003/06/11 10:28:02 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_clearing%ROWTYPE;
6: new_references igs_uc_app_clearing%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 47: FROM IGS_UC_APP_CLEARING

43: */
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM IGS_UC_APP_CLEARING
48: WHERE rowid = x_rowid;
49:
50: BEGIN
51:

Line 139: igs_uc_app_clr_rnd_pkg.get_fk_igs_uc_app_clearing (

135: || (reverse chronological order - newest change first)
136: */
137: BEGIN
138:
139: igs_uc_app_clr_rnd_pkg.get_fk_igs_uc_app_clearing (
140: old_references.clearing_app_id
141: );
142:
143: END check_child_existance;

Line 160: FROM igs_uc_app_clearing

156: || (reverse chronological order - newest change first)
157: */
158: CURSOR cur_rowid IS
159: SELECT rowid
160: FROM igs_uc_app_clearing
161: WHERE clearing_app_id = x_clearing_app_id ;
162:
163: lv_rowid cur_rowid%RowType;
164:

Line 196: FROM igs_uc_app_clearing

192: || message was replaced with IGS_UC_UCAPCL_UCAP_FK.
193: */
194: CURSOR cur_rowid IS
195: SELECT rowid
196: FROM igs_uc_app_clearing
197: WHERE ((app_id = x_app_id));
198:
199: lv_rowid cur_rowid%RowType;
200:

Line 350: FROM igs_uc_app_clearing

346: || (reverse chronological order - newest change first)
347: */
348: CURSOR c IS
349: SELECT rowid
350: FROM igs_uc_app_clearing
351: WHERE clearing_app_id = x_clearing_app_id;
352:
353: x_last_update_date DATE;
354: x_last_updated_by NUMBER;

Line 378: SELECT igs_uc_app_clearing_s.NEXTVAL

374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377:
378: SELECT igs_uc_app_clearing_s.NEXTVAL
379: INTO x_clearing_app_id
380: FROM dual;
381:
382: before_dml(

Line 409: INSERT INTO igs_uc_app_clearing (

405: x_last_updated_by => x_last_updated_by,
406: x_last_update_login => x_last_update_login
407: );
408:
409: INSERT INTO igs_uc_app_clearing (
410: clearing_app_id,
411: app_id,
412: enquiry_no,
413: app_no,

Line 516: FROM igs_uc_app_clearing

512: result,
513: cef_received,
514: clearing_app_source,
515: imported
516: FROM igs_uc_app_clearing
517: WHERE rowid = x_rowid
518: FOR UPDATE NOWAIT;
519:
520: tlinfo c1%ROWTYPE;

Line 648: UPDATE igs_uc_app_clearing

644: x_last_updated_by => x_last_updated_by,
645: x_last_update_login => x_last_update_login
646: );
647:
648: UPDATE igs_uc_app_clearing
649: SET
650: app_id = new_references.app_id,
651: enquiry_no = new_references.enquiry_no,
652: app_no = new_references.app_no,

Line 711: FROM igs_uc_app_clearing

707: || (reverse chronological order - newest change first)
708: */
709: CURSOR c1 IS
710: SELECT rowid
711: FROM igs_uc_app_clearing
712: WHERE clearing_app_id = x_clearing_app_id;
713:
714: BEGIN
715:

Line 790: DELETE FROM igs_uc_app_clearing

786: p_action => 'DELETE',
787: x_rowid => x_rowid
788: );
789:
790: DELETE FROM igs_uc_app_clearing
791: WHERE rowid = x_rowid;
792:
793: IF (SQL%NOTFOUND) THEN
794: RAISE NO_DATA_FOUND;

Line 800: END igs_uc_app_clearing_pkg;

796:
797: END delete_row;
798:
799:
800: END igs_uc_app_clearing_pkg;