APPS.OTA_TPL_BUS dependencies on OTA_TPL_SHD

Line 266: p_rec in ota_tpl_shd.g_rec_type

262: --==============================================================================
263: --==============================================================================
264: procedure check_table_constraints
265: (
266: p_rec in ota_tpl_shd.g_rec_type
267: )
268: is
269: -------------
270: begin

Line 709: p_rec in ota_tpl_shd.g_rec_type

705: -- GENERAL VALIDATION PROCEDURES
706: --***************************************************************************************
707: procedure insert_and_update_validate
708: (
709: p_rec in ota_tpl_shd.g_rec_type
710: )
711: is
712: ---------------------
713: begin

Line 731: p_rec in ota_tpl_shd.g_rec_type

727: --=======================================================================================
728: --=======================================================================================
729: procedure insert_validate2
730: (
731: p_rec in ota_tpl_shd.g_rec_type
732: )
733: is
734: ---------------------
735: begin

Line 744: p_rec in ota_tpl_shd.g_rec_type

740: --=======================================================================================
741: --=======================================================================================
742: procedure update_validate2
743: (
744: p_rec in ota_tpl_shd.g_rec_type
745: )
746: is
747: ---------------------
748: begin

Line 762: p_rec in ota_tpl_shd.g_rec_type

758: --=======================================================================================
759: --=======================================================================================
760: procedure delete_validate2
761: (
762: p_rec in ota_tpl_shd.g_rec_type
763: )
764: is
765: ---------------------
766: begin

Line 816: l_tplrec ota_tpl_shd.g_rec_type;

812: --*** end date will be updated after the price list update.
813: --*** If start date < old start date, Entries starting at the same
814: --*** old start date will be updated as well.
815: --
816: l_tplrec ota_tpl_shd.g_rec_type;
817: --
818: cursor csr_tplrec is
819: select
820: price_list_id,

Line 1015: Procedure insert_validate(p_rec in ota_tpl_shd.g_rec_type) is

1011: end change_price_list_dates;
1012: -- ----------------------------------------------------------------------------
1013: -- |---------------------------< insert_validate >----------------------------|
1014: -- ----------------------------------------------------------------------------
1015: Procedure insert_validate(p_rec in ota_tpl_shd.g_rec_type) is
1016: --
1017: l_proc varchar2(72) := g_package||'insert_validate';
1018: --
1019: Begin

Line 1033: Procedure update_validate(p_rec in ota_tpl_shd.g_rec_type) is

1029: --
1030: -- ----------------------------------------------------------------------------
1031: -- |---------------------------< update_validate >----------------------------|
1032: -- ----------------------------------------------------------------------------
1033: Procedure update_validate(p_rec in ota_tpl_shd.g_rec_type) is
1034: --
1035: l_proc varchar2(72) := g_package||'update_validate';
1036: --
1037: Begin

Line 1051: Procedure delete_validate(p_rec in ota_tpl_shd.g_rec_type) is

1047: --
1048: -- ----------------------------------------------------------------------------
1049: -- |---------------------------< delete_validate >----------------------------|
1050: -- ----------------------------------------------------------------------------
1051: Procedure delete_validate(p_rec in ota_tpl_shd.g_rec_type) is
1052: --
1053: l_proc varchar2(72) := g_package||'delete_validate';
1054: --
1055: Begin