35: -- This procedure create or updates the Master source type view.
36:
37: PROCEDURE master_source_type_view(
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
40: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
36:
37: PROCEDURE master_source_type_view(
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
40: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_list_source_type_id IN NUMBER
46:
47:
48: PROCEDURE update_all_master_views(
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
51: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
47:
48: PROCEDURE update_all_master_views(
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
51: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
55: p_list_source_type_id IN NUMBER
56: );
57:
58: PROCEDURE process_views(
59: p_api_version_number IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63:
64: x_return_status OUT NOCOPY VARCHAR2,
57:
58: PROCEDURE process_views(
59: p_api_version_number IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63:
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
58: PROCEDURE process_views(
59: p_api_version_number IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63:
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,