APPS.OZF_SETTLEMENT_DOC_PVT dependencies on RA_CUST_TRX_TYPES

Line 79: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS

75: SELECT claim_class
76: FROM ozf_claims_all
77: WHERE claim_id = cv_claim_id;
78:
79: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
80: SELECT name
81: FROM ra_cust_trx_types
82: WHERE cust_trx_type_id = cv_settlement_type_id;
83:

Line 81: FROM ra_cust_trx_types

77: WHERE claim_id = cv_claim_id;
78:
79: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
80: SELECT name
81: FROM ra_cust_trx_types
82: WHERE cust_trx_type_id = cv_settlement_type_id;
83:
84: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
85: SELECT trx_number

Line 142: OPEN csr_ra_cust_trx_types (p_settlement_type_id);

138: OR(l_claim_class = 'DEDUCTION' AND (p_payment_method = 'CREDIT_MEMO' OR p_payment_method = 'REG_CREDIT_MEMO'
139: OR p_payment_method = 'RMA' OR p_payment_method = 'CHARGEBACK'))
140: OR(l_claim_class = 'OVERPAYMENT' AND p_payment_method = 'DEBIT_MEMO')) THEN
141:
142: OPEN csr_ra_cust_trx_types (p_settlement_type_id);
143: FETCH csr_ra_cust_trx_types INTO x_settlement_type;
144: CLOSE csr_ra_cust_trx_types;
145:
146: ELSIF(l_claim_class IN ('DEDUCTION','OVERPAYMENT') AND p_payment_method IN ('WRITE_OFF','ON_ACCT_CREDIT','ADJUSTMENT')) THEN

Line 143: FETCH csr_ra_cust_trx_types INTO x_settlement_type;

139: OR p_payment_method = 'RMA' OR p_payment_method = 'CHARGEBACK'))
140: OR(l_claim_class = 'OVERPAYMENT' AND p_payment_method = 'DEBIT_MEMO')) THEN
141:
142: OPEN csr_ra_cust_trx_types (p_settlement_type_id);
143: FETCH csr_ra_cust_trx_types INTO x_settlement_type;
144: CLOSE csr_ra_cust_trx_types;
145:
146: ELSIF(l_claim_class IN ('DEDUCTION','OVERPAYMENT') AND p_payment_method IN ('WRITE_OFF','ON_ACCT_CREDIT','ADJUSTMENT')) THEN
147: IF((l_claim_class = 'DEDUCTION' AND p_payment_method ='WRITE_OFF' AND

Line 144: CLOSE csr_ra_cust_trx_types;

140: OR(l_claim_class = 'OVERPAYMENT' AND p_payment_method = 'DEBIT_MEMO')) THEN
141:
142: OPEN csr_ra_cust_trx_types (p_settlement_type_id);
143: FETCH csr_ra_cust_trx_types INTO x_settlement_type;
144: CLOSE csr_ra_cust_trx_types;
145:
146: ELSIF(l_claim_class IN ('DEDUCTION','OVERPAYMENT') AND p_payment_method IN ('WRITE_OFF','ON_ACCT_CREDIT','ADJUSTMENT')) THEN
147: IF((l_claim_class = 'DEDUCTION' AND p_payment_method ='WRITE_OFF' AND
148: p_settlement_type_id is not null AND p_settlement_type_id = -3)

Line 423: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS

419: SELECT claim_class
420: FROM ozf_claims_all
421: WHERE claim_id = cv_claim_id;
422:
423: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
424: SELECT name
425: FROM ra_cust_trx_types
426: WHERE cust_trx_type_id = cv_settlement_type_id;
427:

Line 425: FROM ra_cust_trx_types

421: WHERE claim_id = cv_claim_id;
422:
423: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
424: SELECT name
425: FROM ra_cust_trx_types
426: WHERE cust_trx_type_id = cv_settlement_type_id;
427:
428: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
429: SELECT trx_number

Line 1659: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS

1655: SELECT claim_class, payment_method
1656: FROM ozf_claims_all
1657: WHERE claim_id = cv_claim_id;
1658:
1659: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
1660: SELECT name
1661: FROM ra_cust_trx_types
1662: WHERE cust_trx_type_id = cv_settlement_type_id;
1663:

Line 1661: FROM ra_cust_trx_types

1657: WHERE claim_id = cv_claim_id;
1658:
1659: CURSOR csr_ra_cust_trx_types(cv_settlement_type_id IN NUMBER) IS
1660: SELECT name
1661: FROM ra_cust_trx_types
1662: WHERE cust_trx_type_id = cv_settlement_type_id;
1663:
1664: CURSOR csr_ar_payment_schedules(cv_settlement_type_id IN NUMBER) IS
1665: SELECT trx_number