DBA Data[Home] [Help]

APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on OE_CREDIT_SUMMARIES_PKG

Line 930: oe_credit_summaries_pkg.Delete_Row(

926:
927: IF c_summary_row%FOUND THEN
928: -- Delete any rows first, then insert.
929: OE_DEBUG_PUB.Add('Row exist. Delete existing row', 5);
930: oe_credit_summaries_pkg.Delete_Row(
931: p_row_id => l_row_id
932: );
933: END IF;
934:

Line 938: oe_credit_summaries_pkg.insert_row(

934:
935: IF p_exposure_rec.exposure_amount <> 0 THEN
936: -- Insert row only if amount <> 0
937: OE_DEBUG_PUB.Add('Insert the new exposure row', 5);
938: oe_credit_summaries_pkg.insert_row(
939: p_cust_account_id => p_exposure_rec.bill_to_customer_id
940: , p_org_id => p_exposure_rec.org_id
941: , p_site_use_id => p_exposure_rec.bill_to_site_use_id
942: , p_currency_code => p_exposure_rec.currency_code

Line 1001: oe_credit_summaries_pkg.Update_Row(

997:
998: IF p_exposure_rec.exposure_amount <> 0 THEN
999: IF c_summary_exposure%FOUND THEN
1000: OE_DEBUG_PUB.Add('Updating exposure row', 5);
1001: oe_credit_summaries_pkg.Update_Row(
1002: p_row_id => l_row_id
1003: , p_balance => p_exposure_rec.exposure_amount + l_balance
1004: , p_last_update_date => p_exposure_rec.last_update_date
1005: , p_last_updated_by => p_exposure_rec.last_updated_by

Line 1014: oe_credit_summaries_pkg.Insert_Row(

1010: , p_request_id => p_exposure_rec.request_id
1011: );
1012: ELSE
1013: OE_DEBUG_PUB.Add('Inserting exposure row', 5);
1014: oe_credit_summaries_pkg.Insert_Row(
1015: p_cust_account_id => p_exposure_rec.bill_to_customer_id
1016: , p_org_id => p_exposure_rec.org_id
1017: , p_site_use_id => p_exposure_rec.bill_to_site_use_id
1018: , p_currency_code => p_exposure_rec.currency_code