APPS.IGF_SL_CL_SETUP_PKG dependencies on IGF_SL_CL_SETUP_ALL

Line 5: old_references igf_sl_cl_setup_all%ROWTYPE;

1: PACKAGE BODY igf_sl_cl_setup_pkg AS
2: /* $Header: IGFLI08B.pls 120.0 2005/06/01 14:00:57 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_setup_all%ROWTYPE;
6: new_references igf_sl_cl_setup_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_cl_setup_all%ROWTYPE;

2: /* $Header: IGFLI08B.pls 120.0 2005/06/01 14:00:57 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_setup_all%ROWTYPE;
6: new_references igf_sl_cl_setup_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 62: FROM IGF_SL_CL_SETUP_ALL

58: */
59:
60: CURSOR cur_old_ref_values IS
61: SELECT *
62: FROM IGF_SL_CL_SETUP_ALL
63: WHERE rowid = x_rowid;
64:
65: BEGIN
66:

Line 203: FROM igf_sl_cl_setup_all

199: || (reverse chronological order - newest change first)
200: */
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM igf_sl_cl_setup_all
204: WHERE clset_id = x_clset_id
205: FOR UPDATE NOWAIT;
206:
207: lv_rowid cur_rowid%RowType;

Line 242: FROM igf_sl_cl_setup_all

238: || (reverse chronological order - newest change first)
239: */
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM igf_sl_cl_setup_all
243: WHERE ci_cal_type = x_ci_cal_type
244: AND ci_sequence_number = x_ci_sequence_number
245: AND relationship_cd = x_relationship_cd
246: AND NVL(party_id,-100) = NVL(x_party_id,-100)

Line 281: FROM igf_sl_cl_setup_all

277: || (reverse chronological order - newest change first)
278: */
279: CURSOR cur_rowid IS
280: SELECT rowid
281: FROM igf_sl_cl_setup_all
282: WHERE ((ci_cal_type = x_cal_type) AND
283: (ci_sequence_number = x_sequence_number));
284:
285: lv_rowid cur_rowid%RowType;

Line 318: FROM igf_sl_cl_setup_all

314: || (reverse chronological order - newest change first)
315: */
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM igf_sl_cl_setup_all
319: WHERE ((relationship_cd = x_relationship_cd ));
320:
321: lv_rowid cur_rowid%RowType;
322:

Line 516: FROM igf_sl_cl_setup_all

512: || (reverse chronological order - newest change first)
513: */
514: CURSOR c IS
515: SELECT rowid
516: FROM igf_sl_cl_setup_all
517: WHERE clset_id = x_clset_id;
518:
519: x_last_update_date DATE;
520: x_last_updated_by NUMBER;

Line 522: l_org_id igf_sl_cl_setup_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

518:
519: x_last_update_date DATE;
520: x_last_updated_by NUMBER;
521: x_last_update_login NUMBER;
522: l_org_id igf_sl_cl_setup_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
523:
524: BEGIN
525:
526: x_last_update_date := SYSDATE;

Line 591: INSERT INTO igf_sl_cl_setup_all(

587: x_fund_return_method_code => x_fund_return_method_code
588: );
589:
590:
591: INSERT INTO igf_sl_cl_setup_all(
592: clset_id,
593: ci_cal_type,
594: ci_sequence_number,
595: borw_interest_ind,

Line 728: FROM igf_sl_cl_setup_all

724: party_id,
725: cl_version,
726: plus_processing_type_code,
727: fund_return_method_code
728: FROM igf_sl_cl_setup_all
729: WHERE rowid = x_rowid
730: FOR UPDATE NOWAIT;
731:
732: tlinfo c1%ROWTYPE;

Line 892: UPDATE igf_sl_cl_setup_all

888: x_plus_processing_type_code => x_plus_processing_type_code,
889: x_fund_return_method_code => x_fund_return_method_code
890: );
891:
892: UPDATE igf_sl_cl_setup_all
893: SET
894: ci_cal_type = new_references.ci_cal_type,
895: ci_sequence_number = new_references.ci_sequence_number,
896: borw_interest_ind = new_references.borw_interest_ind,

Line 973: FROM igf_sl_cl_setup_all

969: || (reverse chronological order - newest change first)
970: */
971: CURSOR c1 IS
972: SELECT rowid
973: FROM igf_sl_cl_setup_all
974: WHERE clset_id = x_clset_id;
975:
976: BEGIN
977:

Line 1082: DELETE FROM igf_sl_cl_setup_all

1078: p_action => 'DELETE',
1079: x_rowid => x_rowid
1080: );
1081:
1082: DELETE FROM igf_sl_cl_setup_all
1083: WHERE rowid = x_rowid;
1084:
1085: IF (SQL%NOTFOUND) THEN
1086: RAISE NO_DATA_FOUND;