APPS.IGF_SL_CL_ORIG dependencies on IGS_CA_INST

Line 399: lv_ci_cal_type igs_ca_inst.cal_type%TYPE;

395: to p_base_id if it is not null.
396: mesriniv 23-APR-2002 Added code to display the Parameters Passed
397: ***************************************************************************************/
398:
399: lv_ci_cal_type igs_ca_inst.cal_type%TYPE;
400: lv_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
401: lv_recipient_id_found BOOLEAN;
402:
403: lv_request_id NUMBER(10);

Line 400: lv_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

396: mesriniv 23-APR-2002 Added code to display the Parameters Passed
397: ***************************************************************************************/
398:
399: lv_ci_cal_type igs_ca_inst.cal_type%TYPE;
400: lv_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
401: lv_recipient_id_found BOOLEAN;
402:
403: lv_request_id NUMBER(10);
404: lv_request_status BOOLEAN;

Line 406: l_alternate_code igs_ca_inst.alternate_code%TYPE;

402:
403: lv_request_id NUMBER(10);
404: lv_request_status BOOLEAN;
405: l_i NUMBER(1);
406: l_alternate_code igs_ca_inst.alternate_code%TYPE;
407: l_lookup_type igf_lookups_view.lookup_type%TYPE;
408:
409: TYPE l_parameters IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
410: l_para_rec l_parameters;

Line 476: FROM igs_ca_inst ca

472: --Bug No:2332668
473: CURSOR cur_alternate_code
474: IS
475: SELECT ca.alternate_code
476: FROM igs_ca_inst ca
477: WHERE ca.cal_type = lv_ci_cal_type
478: AND ca.sequence_number = lv_ci_sequence_number;
479:
480:

Line 1200: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,

1196: -- It returns the Request id and Based on the value data is committed
1197:
1198: PROCEDURE sub_cl_originate( errbuf OUT NOCOPY VARCHAR2,
1199: retcode OUT NOCOPY NUMBER,
1200: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
1201: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1202: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
1203: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
1204: p_org_id IN NUMBER,

Line 1201: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

1197:
1198: PROCEDURE sub_cl_originate( errbuf OUT NOCOPY VARCHAR2,
1199: retcode OUT NOCOPY NUMBER,
1200: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
1201: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1202: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
1203: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
1204: p_org_id IN NUMBER,
1205: p_relationship_cd IN VARCHAR2,