DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_EXPOSURE_PVT

Line 3238: AND bucket_duration = OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH ;

3234: CURSOR party_txn_cur IS
3235: SELECT distinct ( currency_code) user_code
3236: FROM oe_credit_summaries
3237: WHERE party_id = p_entity_id
3238: AND bucket_duration = OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH ;
3239:
3240:
3241: CURSOR party_h_txn_cur IS
3242: SELECT distinct ( oes.currency_code) user_code

Line 3254: AND oes.bucket_duration = OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH ;

3250: and hn.effective_end_date >= SYSDATE
3251: and hn.hierarchy_type
3252: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
3253: AND oes.party_id = hn.child_id
3254: AND oes.bucket_duration = OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH ;
3255:
3256:
3257: include_all_rec include_all_csr%rowtype;
3258: l_credit_limit_exist VARCHAR2(1) ;

Line 5739: OE_CREDIT_EXPOSURE_PVT.get_invoices_over_duedate

5735: THEN
5736: oe_debug_pub.add('calling get_invoices_over_duedate ');
5737: END IF;
5738:
5739: OE_CREDIT_EXPOSURE_PVT.get_invoices_over_duedate
5740: ( p_customer_id => p_customer_id
5741: , p_site_use_id => p_site_use_id
5742: , p_party_id => p_party_id
5743: , p_credit_check_rule_rec => p_credit_check_rule_rec