APPS.OTA_PLE_BUS dependencies on OTA_PLE_SHD

Line 289: p_rec in OTA_PLE_SHD.g_rec_type

285: --============================================================================
286: --============================================================================
287: procedure check_table_constraints
288: (
289: p_rec in OTA_PLE_SHD.g_rec_type
290: )
291: is
292: -------------
293: begin

Line 704: p_rec in OTA_PLE_SHD.g_rec_type

700: -- GENERAL VALIDATION PROCEDURES
701: --********************************************************************************
702: procedure insert_and_update_validate
703: (
704: p_rec in OTA_PLE_SHD.g_rec_type
705: )
706: is
707: ---------------------
708: l_tav_id ota_activity_versions.activity_version_id%type;

Line 738: p_rec in OTA_PLE_SHD.g_rec_type

734: --==============================================================================
735: --==============================================================================
736: procedure insert_validate2
737: (
738: p_rec in OTA_PLE_SHD.g_rec_type
739: )
740: is
741: ---------------------
742: begin

Line 751: p_rec in OTA_PLE_SHD.g_rec_type

747: --==============================================================================
748: --==============================================================================
749: procedure update_validate2
750: (
751: p_rec in OTA_PLE_SHD.g_rec_type
752: )
753: is
754: ---------------------
755: begin

Line 763: p_rec in OTA_PLE_SHD.g_rec_type

759: end update_validate2;
760: --==============================================================================
761: procedure delete_validate2
762: (
763: p_rec in OTA_PLE_SHD.g_rec_type
764: )
765: is
766: ---------------------
767: begin

Line 846: l_plerec ota_ple_shd.g_rec_type;

842: -----------------
843: --*** Create new entries based on existing Entries
844: --*** with new dates and a price increase.
845: --
846: l_plerec ota_ple_shd.g_rec_type;
847: l_plerec2 ota_ple_shd.g_rec_type;
848: l_activity_version_id number;
849: l_activity_start_date date;
850: l_activity_end_date date;

Line 847: l_plerec2 ota_ple_shd.g_rec_type;

843: --*** Create new entries based on existing Entries
844: --*** with new dates and a price increase.
845: --
846: l_plerec ota_ple_shd.g_rec_type;
847: l_plerec2 ota_ple_shd.g_rec_type;
848: l_activity_version_id number;
849: l_activity_start_date date;
850: l_activity_end_date date;
851: l_start_date date;

Line 1413: Procedure insert_validate(p_rec in ota_ple_shd.g_rec_type) is

1409: --******************************************************************************
1410: -- ----------------------------------------------------------------------------
1411: -- |---------------------------< insert_validate >----------------------------|
1412: -- ----------------------------------------------------------------------------
1413: Procedure insert_validate(p_rec in ota_ple_shd.g_rec_type) is
1414: --
1415: l_proc varchar2(72) := g_package||'insert_validate';
1416: --
1417: Begin

Line 1521: Procedure update_validate(p_rec in ota_ple_shd.g_rec_type) is

1517: --
1518: -- ----------------------------------------------------------------------------
1519: -- |---------------------------< update_validate >----------------------------|
1520: -- ----------------------------------------------------------------------------
1521: Procedure update_validate(p_rec in ota_ple_shd.g_rec_type) is
1522: --
1523: l_proc varchar2(72) := g_package||'update_validate';
1524: --
1525: Begin

Line 1539: Procedure delete_validate(p_rec in ota_ple_shd.g_rec_type) is

1535: --
1536: -- ----------------------------------------------------------------------------
1537: -- |---------------------------< delete_validate >----------------------------|
1538: -- ----------------------------------------------------------------------------
1539: Procedure delete_validate(p_rec in ota_ple_shd.g_rec_type) is
1540: --
1541: l_proc varchar2(72) := g_package||'delete_validate';
1542: --
1543: Begin