APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on OE_CREDIT_SUMMARIES

Line 901: --DESCRIPTION: This procedure delete/insert row into OE_CREDIT_SUMMARIES

897:
898: --=====================================================================
899: --NAME: Insert_Exposure
900: --TYPE: PRIVATE
901: --DESCRIPTION: This procedure delete/insert row into OE_CREDIT_SUMMARIES
902: -- table.
903: --Parameters:
904: --IN
905: --OUT

Line 913: FROM oe_credit_summaries

909: )
910: IS
911: CURSOR c_summary_row IS
912: SELECT rowid
913: FROM oe_credit_summaries
914: WHERE cust_account_id = p_exposure_rec.bill_to_customer_id
915: AND org_id = p_exposure_rec.org_id
916: AND site_use_id = p_exposure_rec.bill_to_site_use_id
917: AND currency_code = p_exposure_rec.currency_code

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 970: --DESCRIPTION: This procedure insert/update row into OE_CREDIT_SUMMARIES

966:
967: --=====================================================================
968: --NAME: Update_Exposure
969: --TYPE: PRIVATE
970: --DESCRIPTION: This procedure insert/update row into OE_CREDIT_SUMMARIES
971: -- table.
972: --Parameters:
973: --IN
974: --OUT

Line 982: FROM oe_credit_summaries

978: )
979: IS
980: CURSOR c_summary_exposure IS
981: SELECT rowid, balance
982: FROM oe_credit_summaries
983: WHERE cust_account_id = p_exposure_rec.bill_to_customer_id
984: AND org_id = p_exposure_rec.org_id
985: AND site_use_id = p_exposure_rec.bill_to_site_use_id
986: AND 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

Line 1391: DELETE FROM oe_credit_summaries

1387:
1388: IF l_org_id IS NOT NULL THEN
1389: MO_GLOBAL.set_policy_context('S', l_org_id);
1390:
1391: DELETE FROM oe_credit_summaries
1392: WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1393: AND balance_type = 18
1394: AND NVL(org_id, -99) = NVL(l_org_id, -99);
1395:

Line 1414: DELETE FROM oe_credit_summaries

1410: END IF;
1411:
1412: MO_GLOBAL.set_policy_context('S', l_org_id);
1413:
1414: DELETE FROM oe_credit_summaries
1415: WHERE exposure_source_code = NVL(p_exposure_source_code, exposure_source_code)
1416: AND balance_type = 18
1417: AND NVL(org_id, -99) = NVL(l_org_id, -99);
1418: