DBA Data[Home] [Help]

APPS.JTF_PREFAB_POLICY_PUB dependencies on JTF_PREFAB_SYS_POLICIES

Line 725: p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,

721: p_api_version IN NUMBER,
722: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
723: p_commit IN VARCHAR2 := FND_API.G_FALSE,
724:
725: p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,
726: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
727: p_memory IN jtf_prefab_sys_policies.memory%TYPE,
728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,

Line 726: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,

722: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
723: p_commit IN VARCHAR2 := FND_API.G_FALSE,
724:
725: p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,
726: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
727: p_memory IN jtf_prefab_sys_policies.memory%TYPE,
728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,

Line 727: p_memory IN jtf_prefab_sys_policies.memory%TYPE,

723: p_commit IN VARCHAR2 := FND_API.G_FALSE,
724:
725: p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,
726: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
727: p_memory IN jtf_prefab_sys_policies.memory%TYPE,
728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,

Line 728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,

724:
725: p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,
726: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
727: p_memory IN jtf_prefab_sys_policies.memory%TYPE,
728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,
732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,

Line 729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,

725: p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,
726: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
727: p_memory IN jtf_prefab_sys_policies.memory%TYPE,
728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,
732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,
733: p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,

Line 730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,

726: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
727: p_memory IN jtf_prefab_sys_policies.memory%TYPE,
728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,
732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,
733: p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,
734: p_cache_memory IN jtf_prefab_sys_policies.cache_memory%TYPE,

Line 731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,

727: p_memory IN jtf_prefab_sys_policies.memory%TYPE,
728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,
732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,
733: p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,
734: p_cache_memory IN jtf_prefab_sys_policies.cache_memory%TYPE,
735:

Line 732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,

728: p_disk_location IN jtf_prefab_sys_policies.disk_location%TYPE,
729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,
732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,
733: p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,
734: p_cache_memory IN jtf_prefab_sys_policies.cache_memory%TYPE,
735:
736: p_object_version_number IN OUT NOCOPY jtf_prefab_sys_policies.object_version_number%TYPE,

Line 733: p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,

729: p_max_concurrency IN jtf_prefab_sys_policies.max_concurrency%TYPE,
730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,
732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,
733: p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,
734: p_cache_memory IN jtf_prefab_sys_policies.cache_memory%TYPE,
735:
736: p_object_version_number IN OUT NOCOPY jtf_prefab_sys_policies.object_version_number%TYPE,
737: x_return_status OUT NOCOPY VARCHAR2,

Line 734: p_cache_memory IN jtf_prefab_sys_policies.cache_memory%TYPE,

730: p_use_load_balancer_flag IN jtf_prefab_sys_policies.use_load_balancer_flag%TYPE,
731: p_load_balancer_url IN jtf_prefab_sys_policies.load_balancer_url%TYPE,
732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,
733: p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,
734: p_cache_memory IN jtf_prefab_sys_policies.cache_memory%TYPE,
735:
736: p_object_version_number IN OUT NOCOPY jtf_prefab_sys_policies.object_version_number%TYPE,
737: x_return_status OUT NOCOPY VARCHAR2,
738: x_msg_count OUT NOCOPY NUMBER,

Line 736: p_object_version_number IN OUT NOCOPY jtf_prefab_sys_policies.object_version_number%TYPE,

732: p_refresh_flag IN jtf_prefab_sys_policies.refresh_flag%TYPE,
733: p_interceptor_enabled_flag IN jtf_prefab_sys_policies.interceptor_enabled_flag%TYPE,
734: p_cache_memory IN jtf_prefab_sys_policies.cache_memory%TYPE,
735:
736: p_object_version_number IN OUT NOCOPY jtf_prefab_sys_policies.object_version_number%TYPE,
737: x_return_status OUT NOCOPY VARCHAR2,
738: x_msg_count OUT NOCOPY NUMBER,
739: x_msg_data OUT NOCOPY VARCHAR2
740: ) AS

Line 769: UPDATE jtf_prefab_sys_policies

765:
766: -- real logic --
767: ----------------
768:
769: UPDATE jtf_prefab_sys_policies
770: SET object_version_number = p_object_version_number,
771: last_updated_by = G_USER_ID,
772: last_update_date = SYSDATE,
773: last_update_login = G_LOGIN_ID,

Line 788: INSERT INTO jtf_prefab_sys_policies (sys_policy_id,

784:
785: IF SQL%NOTFOUND THEN
786: p_object_version_number := 1;
787:
788: INSERT INTO jtf_prefab_sys_policies (sys_policy_id,
789: object_version_number,
790: created_by,
791: creation_date,
792: last_updated_by,

Line 806: VALUES (jtf_prefab_sys_policies_s.NEXTVAL,

802: load_balancer_url,
803: refresh_flag,
804: interceptor_enabled_flag,
805: cache_memory)
806: VALUES (jtf_prefab_sys_policies_s.NEXTVAL,
807: p_object_version_number,
808: G_USER_ID,
809: SYSDATE,
810: G_USER_ID,