DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_CREDIT_EXPOSURE_PVT

Line 3237: AND bucket_duration = OE_CREDIT_EXPOSURE_PVT.G_MAX_BUCKET_LENGTH ;

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

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

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

Line 5533: OE_CREDIT_EXPOSURE_PVT.get_invoices_over_duedate

5529: THEN
5530: oe_debug_pub.add('calling get_invoices_over_duedate ');
5531: END IF;
5532:
5533: OE_CREDIT_EXPOSURE_PVT.get_invoices_over_duedate
5534: ( p_customer_id => p_customer_id
5535: , p_site_use_id => p_site_use_id
5536: , p_party_id => p_party_id
5537: , p_credit_check_rule_rec => p_credit_check_rule_rec