620: p_api_version IN NUMBER,
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
622: p_commit IN VARCHAR2 := FND_API.G_FALSE,
623:
624: p_ca_comp_id OUT NOCOPY jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
625: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
626: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
627: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
628: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
622: p_commit IN VARCHAR2 := FND_API.G_FALSE,
623:
624: p_ca_comp_id OUT NOCOPY jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
625: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
626: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
627: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
628: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
629: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
622: p_commit IN VARCHAR2 := FND_API.G_FALSE,
623:
624: p_ca_comp_id OUT NOCOPY jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
625: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
626: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
627: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
628: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
629: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
630: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
624: p_ca_comp_id OUT NOCOPY jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
625: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
626: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
627: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
628: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
629: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
630: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
631: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
625: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
626: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
627: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
628: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
629: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
630: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
631: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
626: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
627: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
628: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
629: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
630: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
631: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
634: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
627: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
628: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
629: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
630: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
631: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
634: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
635: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
628: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
629: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
630: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
631: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
634: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
635: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
636: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
629: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
630: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
631: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
634: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
635: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
636: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
637: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
630: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
631: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
634: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
635: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
636: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
637: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
638:
631: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
634: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
635: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
636: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
637: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
638:
639: p_object_version_number OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
632: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
634: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
635: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
636: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
637: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
638:
639: p_object_version_number OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
640:
633: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
634: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
635: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
636: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
637: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
638:
639: p_object_version_number OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
640:
641: x_return_status OUT NOCOPY VARCHAR2,
635: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
636: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
637: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
638:
639: p_object_version_number OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
640:
641: x_return_status OUT NOCOPY VARCHAR2,
642: x_msg_count OUT NOCOPY NUMBER,
643: x_msg_data OUT NOCOPY VARCHAR2
647: l_api_version NUMBER := p_api_version;
648: l_row_id VARCHAR2(255) := NULL;
649:
650: CURSOR sequence_cursor IS
651: SELECT jtf_prefab_ca_comps_b_s.NEXTVAL from dual;
652: CURSOR host_apps_cursor IS
653: SELECT host_app_id
654: FROM jtf_prefab_host_apps
655: WHERE application_id = p_application_id;
854: p_api_version IN NUMBER,
855: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
856: p_commit IN VARCHAR2 := FND_API.G_FALSE,
857:
858: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
859: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
860: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
861: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
862: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
855: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
856: p_commit IN VARCHAR2 := FND_API.G_FALSE,
857:
858: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
859: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
860: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
861: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
862: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
863: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
856: p_commit IN VARCHAR2 := FND_API.G_FALSE,
857:
858: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
859: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
860: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
861: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
862: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
863: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
864: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
858: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
859: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
860: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
861: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
862: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
863: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
864: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
865: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
859: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
860: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
861: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
862: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
863: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
864: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
865: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
860: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,
861: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
862: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
863: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
864: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
865: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
868: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
861: p_description IN jtf_prefab_ca_comps_tl.description%TYPE,
862: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
863: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
864: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
865: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
868: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
869: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
862: p_component_key IN jtf_prefab_ca_comps_b.component_key%TYPE,
863: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
864: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
865: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
868: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
869: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
870: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
863: p_loader_class_name IN jtf_prefab_ca_comps_b.loader_class_name%TYPE,
864: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
865: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
868: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
869: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
870: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
871: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
864: p_timeout_type IN jtf_prefab_ca_comps_b.timeout_type%TYPE,
865: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
868: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
869: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
870: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
871: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
872:
865: p_timeout IN jtf_prefab_ca_comps_b.timeout%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
868: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
869: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
870: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
871: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
872:
873: p_object_version_number IN OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
866: p_timeout_unit IN jtf_prefab_ca_comps_b.timeout_unit%TYPE,
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
868: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
869: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
870: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
871: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
872:
873: p_object_version_number IN OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
874:
867: p_sgid_enabled_flag IN jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
868: p_stat_enabled_flag IN jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
869: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
870: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
871: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
872:
873: p_object_version_number IN OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
874:
875: x_return_status OUT NOCOPY VARCHAR2,
869: p_distributed_flag IN jtf_prefab_ca_comps_b.distributed_flag%TYPE,
870: p_cache_generic_flag IN jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
871: p_business_event_name IN jtf_prefab_ca_comps_b.business_event_name%TYPE,
872:
873: p_object_version_number IN OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
874:
875: x_return_status OUT NOCOPY VARCHAR2,
876: x_msg_count OUT NOCOPY NUMBER,
877: x_msg_data OUT NOCOPY VARCHAR2
992: p_api_version IN NUMBER,
993: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
994: p_commit IN VARCHAR2 := FND_API.G_FALSE,
995:
996: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
997:
998: -- p_object_version_number IN OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
999:
1000: x_return_status OUT NOCOPY VARCHAR2,
994: p_commit IN VARCHAR2 := FND_API.G_FALSE,
995:
996: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
997:
998: -- p_object_version_number IN OUT NOCOPY jtf_prefab_ca_comps_b.object_version_number%TYPE,
999:
1000: x_return_status OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2
1082: p_api_version IN NUMBER,
1083: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1084: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1085:
1086: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
1087:
1088: p_object_version_number IN jtf_prefab_ca_comps_b.object_version_number%TYPE,
1089:
1090: x_return_status OUT NOCOPY VARCHAR2,
1084: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1085:
1086: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
1087:
1088: p_object_version_number IN jtf_prefab_ca_comps_b.object_version_number%TYPE,
1089:
1090: x_return_status OUT NOCOPY VARCHAR2,
1091: x_msg_count OUT NOCOPY NUMBER,
1092: x_msg_data OUT NOCOPY VARCHAR2