APPS.OTA_PLE_BUS dependencies on OTA_PRICE_LIST_ENTRIES

Line 413: --*** Activity version id may be null in ota_price_list_entries

409: )
410: return boolean is
411: --
412: --*** Price list entry's start date must be >= Activity version start date
413: --*** Activity version id may be null in ota_price_list_entries
414: ---------------------
415: cursor csr_tav_date is
416: select start_date
417: from ota_activity_versions

Line 521: --*** Activity version id may be null in ota_price_list_entries

517: )
518: return boolean is
519: --
520: --*** Price list entry's must be <= Activity version's end date
521: --*** Activity version id may be null in ota_price_list_entries
522: ---------------------
523: cursor csr_tav_date is
524: select end_date
525: from ota_activity_versions

Line 641: from ota_price_list_entries

637: --
638: ----------------
639: cursor csr_dple is
640: select 1
641: from ota_price_list_entries
642: where price_list_id = p_tpl_id
643: and nvl(activity_version_id,0) = nvl(p_tav_id,0)
644: and nvl(vendor_supply_id,0) = nvl(p_vsp_id,0)
645: and price_basis = p_price_basis

Line 652: from ota_price_list_entries

648: and (p_ple_id is null or price_list_entry_id <> p_ple_id);
649: --
650: cursor csr_cple is
651: select 1
652: from ota_price_list_entries
653: where price_list_id = p_tpl_id
654: and nvl(activity_version_id,0) = nvl(p_tav_id,0)
655: and nvl(vendor_supply_id,0) = nvl(p_vsp_id,0)
656: and price_basis = p_price_basis

Line 782: l_new_price OTA_PRICE_LIST_ENTRIES.price%TYPE;

778: p_rounding_factor number
779: )
780: return number is
781: ---------------------
782: l_new_price OTA_PRICE_LIST_ENTRIES.price%TYPE;
783: --
784: procedure chkp is
785: begin
786: hr_api.mandatory_arg_error(g_package,'old_price_list_price',p_old_price);

Line 889: from ota_price_list_entries ple

885: ple.ple_information17,
886: ple.ple_information18,
887: ple.ple_information19,
888: ple.ple_information20
889: from ota_price_list_entries ple
890: where ple.price_list_id = p_old_tpl_id
891: and ((p_proc_use = 2
892: and ple.start_date >= nvl(p_starting_from,hr_api.g_sot)
893: and not (ple.start_date > nvl(p_enddate,hr_api.g_eot)

Line 1343: l_rec ota_price_list_entries%rowtype;

1339: p_activity_version_from in number
1340: ,p_activity_version_to in number
1341: ) is
1342: --
1343: l_rec ota_price_list_entries%rowtype;
1344: v_proc varchar2(72) := g_package||'copy_price';
1345: --
1346: cursor sel_price is
1347: select *

Line 1348: from ota_price_list_entries ple

1344: v_proc varchar2(72) := g_package||'copy_price';
1345: --
1346: cursor sel_price is
1347: select *
1348: from ota_price_list_entries ple
1349: where ple.activity_version_id = p_activity_version_from;
1350: --
1351: Begin
1352: --