APPS.IGF_DB_CL_DISB_RESP_PKG dependencies on IGF_DB_CL_DISB_RESP_ALL

Line 5: old_references igf_db_cl_disb_resp_all%ROWTYPE;

1: PACKAGE BODY igf_db_cl_disb_resp_pkg AS
2: /* $Header: IGFDI04B.pls 120.1 2006/08/08 06:28:49 ridas noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_cl_disb_resp_all%ROWTYPE;
6: new_references igf_db_cl_disb_resp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_db_cl_disb_resp_all%ROWTYPE;

2: /* $Header: IGFDI04B.pls 120.1 2006/08/08 06:28:49 ridas noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_db_cl_disb_resp_all%ROWTYPE;
6: new_references igf_db_cl_disb_resp_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 95: FROM igf_db_cl_disb_resp_all

91: */
92:
93: CURSOR cur_old_ref_values IS
94: SELECT *
95: FROM igf_db_cl_disb_resp_all
96: WHERE rowid = x_rowid;
97:
98: BEGIN
99:

Line 239: FROM igf_db_cl_disb_resp_all

235: || (reverse chronological order - newest change first)
236: */
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM igf_db_cl_disb_resp_all
240: WHERE cdbr_id = x_cdbr_id
241: FOR UPDATE NOWAIT;
242:
243: lv_rowid cur_rowid%RowType;

Line 274: FROM igf_db_cl_disb_resp_all

270: || (reverse chronological order - newest change first)
271: */
272: CURSOR cur_rowid IS
273: SELECT rowid
274: FROM igf_db_cl_disb_resp_all
275: WHERE ((cbth_id = x_cbth_id));
276:
277: lv_rowid cur_rowid%RowType;
278:

Line 568: FROM igf_db_cl_disb_resp_all

564: || (reverse chronological order - newest change first)
565: */
566: CURSOR c IS
567: SELECT rowid
568: FROM igf_db_cl_disb_resp_all
569: WHERE cdbr_id = x_cdbr_id;
570:
571: x_last_update_date DATE;
572: x_last_updated_by NUMBER;

Line 578: l_org_id igf_db_cl_disb_resp_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

574: x_request_id NUMBER;
575: x_program_id NUMBER;
576: x_program_application_id NUMBER;
577: x_program_update_date DATE;
578: l_org_id igf_db_cl_disb_resp_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
579:
580: BEGIN
581:
582: x_last_update_date := SYSDATE;

Line 693: INSERT INTO igf_db_cl_disb_resp_all (

689: x_esign_src_typ_cd => x_esign_src_typ_cd,
690: x_direct_to_borr_flag => x_direct_to_borr_flag
691: );
692:
693: INSERT INTO igf_db_cl_disb_resp_all (
694: cdbr_id,
695: cbth_id,
696: record_type,
697: loan_number,

Line 1006: FROM igf_db_cl_disb_resp_all

1002: status,
1003: org_id,
1004: esign_src_typ_cd,
1005: direct_to_borr_flag
1006: FROM igf_db_cl_disb_resp_all
1007: WHERE rowid = x_rowid
1008: FOR UPDATE NOWAIT;
1009:
1010: tlinfo c1%ROWTYPE;

Line 1302: UPDATE igf_db_cl_disb_resp_all

1298: x_program_update_date := SYSDATE;
1299: END IF;
1300: END IF;
1301:
1302: UPDATE igf_db_cl_disb_resp_all
1303: SET
1304: cbth_id = new_references.cbth_id,
1305: record_type = new_references.record_type,
1306: loan_number = new_references.loan_number,

Line 1466: FROM igf_db_cl_disb_resp_all

1462: || (reverse chronological order - newest change first)
1463: */
1464: CURSOR c1 IS
1465: SELECT rowid
1466: FROM igf_db_cl_disb_resp_all
1467: WHERE cdbr_id = x_cdbr_id;
1468:
1469: BEGIN
1470:

Line 1643: DELETE FROM igf_db_cl_disb_resp_all

1639: p_action => 'DELETE',
1640: x_rowid => x_rowid
1641: );
1642:
1643: DELETE FROM igf_db_cl_disb_resp_all
1644: WHERE rowid = x_rowid;
1645:
1646: IF (SQL%NOTFOUND) THEN
1647: RAISE NO_DATA_FOUND;