DBA Data[Home] [Help]

APPS.OTA_TEA_BUS dependencies on OTA_TEA_SHD

Line 804: Procedure insert_validate(p_rec in ota_tea_shd.g_rec_type

800: end new_price_list_hit;
801: -- ----------------------------------------------------------------------------
802: -- |---------------------------< insert_validate >----------------------------|
803: -- ----------------------------------------------------------------------------
804: Procedure insert_validate(p_rec in ota_tea_shd.g_rec_type
805: ,p_association_type in varchar2) is
806: --
807: l_proc varchar2(72) := g_package||'insert_validate';
808: l_price_basis ota_events.price_basis%type; /* bug no 3476078 */

Line 845: Procedure update_validate(p_rec in ota_tea_shd.g_rec_type

841: --
842: -- ----------------------------------------------------------------------------
843: -- |---------------------------< update_validate >----------------------------|
844: -- ----------------------------------------------------------------------------
845: Procedure update_validate(p_rec in ota_tea_shd.g_rec_type
846: ,p_association_type in varchar2) is
847: --
848: l_proc varchar2(72) := g_package||'update_validate';
849: l_price_basis ota_events.price_basis%type; /* bug no 3476078 */

Line 852: ota_general.value_changed( ota_tea_shd.g_old_rec.customer_id

848: l_proc varchar2(72) := g_package||'update_validate';
849: l_price_basis ota_events.price_basis%type; /* bug no 3476078 */
850: --
851: l_customer_changed boolean :=
852: ota_general.value_changed( ota_tea_shd.g_old_rec.customer_id
853: , p_rec.customer_id );
854: l_organization_changed boolean :=
855: ota_general.value_changed( ota_tea_shd.g_old_rec.organization_id
856: , p_rec.organization_id );

Line 855: ota_general.value_changed( ota_tea_shd.g_old_rec.organization_id

851: l_customer_changed boolean :=
852: ota_general.value_changed( ota_tea_shd.g_old_rec.customer_id
853: , p_rec.customer_id );
854: l_organization_changed boolean :=
855: ota_general.value_changed( ota_tea_shd.g_old_rec.organization_id
856: , p_rec.organization_id );
857: l_job_changed boolean :=
858: ota_general.value_changed( ota_tea_shd.g_old_rec.job_id
859: , p_rec.job_id );

Line 858: ota_general.value_changed( ota_tea_shd.g_old_rec.job_id

854: l_organization_changed boolean :=
855: ota_general.value_changed( ota_tea_shd.g_old_rec.organization_id
856: , p_rec.organization_id );
857: l_job_changed boolean :=
858: ota_general.value_changed( ota_tea_shd.g_old_rec.job_id
859: , p_rec.job_id );
860: l_position_changed boolean :=
861: ota_general.value_changed( ota_tea_shd.g_old_rec.position_id
862: , p_rec.position_id );

Line 861: ota_general.value_changed( ota_tea_shd.g_old_rec.position_id

857: l_job_changed boolean :=
858: ota_general.value_changed( ota_tea_shd.g_old_rec.job_id
859: , p_rec.job_id );
860: l_position_changed boolean :=
861: ota_general.value_changed( ota_tea_shd.g_old_rec.position_id
862: , p_rec.position_id );
863: --
864: Begin
865: hr_utility.set_location('Entering:'||l_proc, 5);

Line 913: Procedure delete_validate(p_rec in ota_tea_shd.g_rec_type) is

909: --
910: -- ----------------------------------------------------------------------------
911: -- |---------------------------< delete_validate >----------------------------|
912: -- ----------------------------------------------------------------------------
913: Procedure delete_validate(p_rec in ota_tea_shd.g_rec_type) is
914: --
915: l_proc varchar2(72) := g_package||'delete_validate';
916: --
917: Begin