APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on FND_API

Line 18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

14:
15: PROCEDURE Create_Hierarchy_Section
16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 19: p_commit IN VARCHAR2 := FND_API.G_FALSE,

15: PROCEDURE Create_Hierarchy_Section
16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_start_date_active IN DATE,

Line 21: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_start_date_active IN DATE,
25: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 22: p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_start_date_active IN DATE,
25: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
26: p_section_type_code IN VARCHAR2,

Line 23: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_start_date_active IN DATE,
25: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
26: p_section_type_code IN VARCHAR2,
27: p_status_code IN VARCHAR2,

Line 25: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

21: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_start_date_active IN DATE,
25: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
26: p_section_type_code IN VARCHAR2,
27: p_status_code IN VARCHAR2,
28: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,

Line 28: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,

24: p_start_date_active IN DATE,
25: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
26: p_section_type_code IN VARCHAR2,
27: p_status_code IN VARCHAR2,
28: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 29: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,

25: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
26: p_section_type_code IN VARCHAR2,
27: p_status_code IN VARCHAR2,
28: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

Line 30: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

26: p_section_type_code IN VARCHAR2,
27: p_status_code IN VARCHAR2,
28: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
34: p_display_name IN VARCHAR2,

Line 31: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,

27: p_status_code IN VARCHAR2,
28: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
34: p_display_name IN VARCHAR2,
35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,

28: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
34: p_display_name IN VARCHAR2,
35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

29: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
34: p_display_name IN VARCHAR2,
35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

31: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
34: p_display_name IN VARCHAR2,
35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

32: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
34: p_display_name IN VARCHAR2,
35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,

33: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
34: p_display_name IN VARCHAR2,
35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

34: p_display_name IN VARCHAR2,
35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

38: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

39: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

40: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

41: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

42: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

43: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: x_section_id OUT NOCOPY NUMBER,

Line 51: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

47: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: x_section_id OUT NOCOPY NUMBER,
55: x_return_status OUT NOCOPY VARCHAR2,

Line 52: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

48: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: x_section_id OUT NOCOPY NUMBER,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,

Line 53: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: x_section_id OUT NOCOPY NUMBER,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2

Line 63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

59:
60: PROCEDURE Update_Hierarchy_Section
61: (
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_object_version_number IN NUMBER,

Line 64: p_commit IN VARCHAR2 := FND_API.G_FALSE,

60: PROCEDURE Update_Hierarchy_Section
61: (
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_object_version_number IN NUMBER,
68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

Line 65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

61: (
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_object_version_number IN NUMBER,
68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 66: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_object_version_number IN NUMBER,
68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

Line 68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_object_version_number IN NUMBER,
68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_object_version_number IN NUMBER,
68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

66: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
67: p_object_version_number IN NUMBER,
68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,

Line 71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

67: p_object_version_number IN NUMBER,
68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,

Line 72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

68: p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

69: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,

70: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,

71: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

Line 76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

72: p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,

73: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,

74: p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

75: p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

76: p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

77: p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

78: p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,

79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

80: p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

81: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

82: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

83: p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

84: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

85: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

86: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

87: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

88: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

89: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

90: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

91: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

92: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_upd_dsc_scts_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

93: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_upd_dsc_scts_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: x_return_status OUT NOCOPY VARCHAR2,

Line 98: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

94: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_upd_dsc_scts_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,

Line 99: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

95: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_upd_dsc_scts_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2

Line 100: p_upd_dsc_scts_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

96: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_upd_dsc_scts_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2
104: );

Line 109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

105:
106: PROCEDURE Delete_Hierarchy_Section
107: (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 110: p_commit IN VARCHAR2 := FND_API.G_FALSE,

106: PROCEDURE Delete_Hierarchy_Section
107: (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: x_return_status OUT NOCOPY VARCHAR2,

Line 111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

107: (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,

Line 112: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2

Line 113: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2
117: );

Line 124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

120:
121: PROCEDURE Associate_Items_To_Section
122: (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_section_id IN NUMBER,
128: p_inventory_item_ids IN JTF_NUMBER_TABLE,

Line 125: p_commit IN VARCHAR2 := FND_API.G_FALSE,

121: PROCEDURE Associate_Items_To_Section
122: (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_section_id IN NUMBER,
128: p_inventory_item_ids IN JTF_NUMBER_TABLE,
129: p_organization_ids IN JTF_NUMBER_TABLE,

Line 126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

122: (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: p_section_id IN NUMBER,
128: p_inventory_item_ids IN JTF_NUMBER_TABLE,
129: p_organization_ids IN JTF_NUMBER_TABLE,
130: p_start_date_actives IN JTF_DATE_TABLE,

Line 144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

140:
141: PROCEDURE Associate_Sections_To_Item
142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_inventory_item_id IN NUMBER,
148: p_organization_id IN NUMBER,

Line 145: p_commit IN VARCHAR2 := FND_API.G_FALSE,

141: PROCEDURE Associate_Sections_To_Item
142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_inventory_item_id IN NUMBER,
148: p_organization_id IN NUMBER,
149: p_section_ids IN JTF_NUMBER_TABLE,

Line 146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_inventory_item_id IN NUMBER,
148: p_organization_id IN NUMBER,
149: p_section_ids IN JTF_NUMBER_TABLE,
150: p_start_date_actives IN JTF_DATE_TABLE,

Line 164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

160:
161: PROCEDURE Disassociate_Scts_To_Itms
162: (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_section_ids IN JTF_NUMBER_TABLE,
168: p_inventory_item_ids IN JTF_NUMBER_TABLE,

Line 165: p_commit IN VARCHAR2 := FND_API.G_FALSE,

161: PROCEDURE Disassociate_Scts_To_Itms
162: (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_section_ids IN JTF_NUMBER_TABLE,
168: p_inventory_item_ids IN JTF_NUMBER_TABLE,
169: p_organization_ids IN JTF_NUMBER_TABLE,

Line 166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

162: (
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_section_ids IN JTF_NUMBER_TABLE,
168: p_inventory_item_ids IN JTF_NUMBER_TABLE,
169: p_organization_ids IN JTF_NUMBER_TABLE,
170: x_return_status OUT NOCOPY VARCHAR2,

Line 178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

174:
175: PROCEDURE Disassociate_Scts_Itms
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_section_item_ids IN JTF_NUMBER_TABLE,
182: x_return_status OUT NOCOPY VARCHAR2,

Line 179: p_commit IN VARCHAR2 := FND_API.G_FALSE,

175: PROCEDURE Disassociate_Scts_Itms
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_section_item_ids IN JTF_NUMBER_TABLE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,

Line 180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_section_item_ids IN JTF_NUMBER_TABLE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2

Line 190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

186:
187: PROCEDURE Associate_MSites_To_Section
188: (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: p_section_id IN NUMBER,
194: p_mini_site_ids IN JTF_NUMBER_TABLE,

Line 191: p_commit IN VARCHAR2 := FND_API.G_FALSE,

187: PROCEDURE Associate_MSites_To_Section
188: (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: p_section_id IN NUMBER,
194: p_mini_site_ids IN JTF_NUMBER_TABLE,
195: x_return_status OUT NOCOPY VARCHAR2,

Line 192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

188: (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: p_section_id IN NUMBER,
194: p_mini_site_ids IN JTF_NUMBER_TABLE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,

Line 203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

199:
200: PROCEDURE Associate_Root_Sct_To_MSite
201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: p_section_id IN NUMBER,
207: p_mini_site_id IN NUMBER,

Line 204: p_commit IN VARCHAR2 := FND_API.G_FALSE,

200: PROCEDURE Associate_Root_Sct_To_MSite
201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: p_section_id IN NUMBER,
207: p_mini_site_id IN NUMBER,
208: x_return_status OUT NOCOPY VARCHAR2,

Line 205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204: p_commit IN VARCHAR2 := FND_API.G_FALSE,
205: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206: p_section_id IN NUMBER,
207: p_mini_site_id IN NUMBER,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,

Line 216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

212:
213: PROCEDURE Update_Hierarchy_Item
214: (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_inventory_item_id IN NUMBER,
220: p_organization_id IN NUMBER,

Line 217: p_commit IN VARCHAR2 := FND_API.G_FALSE,

213: PROCEDURE Update_Hierarchy_Item
214: (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_inventory_item_id IN NUMBER,
220: p_organization_id IN NUMBER,
221: p_last_updated_by IN NUMBER,

Line 218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

214: (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_inventory_item_id IN NUMBER,
220: p_organization_id IN NUMBER,
221: p_last_updated_by IN NUMBER,
222: p_last_update_login IN NUMBER,

Line 224: p_web_status_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

220: p_organization_id IN NUMBER,
221: p_last_updated_by IN NUMBER,
222: p_last_update_login IN NUMBER,
223: p_last_update_date IN DATE,
224: p_web_status_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,

Line 225: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

221: p_last_updated_by IN NUMBER,
222: p_last_update_login IN NUMBER,
223: p_last_update_date IN DATE,
224: p_web_status_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2

Line 226: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

222: p_last_update_login IN NUMBER,
223: p_last_update_date IN DATE,
224: p_web_status_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2
230: );

Line 235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

231:
232: PROCEDURE Associate_MSites_To_Item
233: (
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238: p_inventory_item_id IN NUMBER,
239: p_organization_id IN NUMBER,

Line 236: p_commit IN VARCHAR2 := FND_API.G_FALSE,

232: PROCEDURE Associate_MSites_To_Item
233: (
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238: p_inventory_item_id IN NUMBER,
239: p_organization_id IN NUMBER,
240: p_mini_site_ids IN JTF_NUMBER_TABLE,

Line 237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

233: (
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238: p_inventory_item_id IN NUMBER,
239: p_organization_id IN NUMBER,
240: p_mini_site_ids IN JTF_NUMBER_TABLE,
241: x_return_status OUT NOCOPY VARCHAR2,

Line 249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

245:
246: PROCEDURE Update_Delete_Sct_Scts
247: (
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
253: p_object_version_numbers IN JTF_NUMBER_TABLE,

Line 250: p_commit IN VARCHAR2 := FND_API.G_FALSE,

246: PROCEDURE Update_Delete_Sct_Scts
247: (
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
253: p_object_version_numbers IN JTF_NUMBER_TABLE,
254: p_start_date_actives IN JTF_DATE_TABLE,

Line 251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

247: (
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
253: p_object_version_numbers IN JTF_NUMBER_TABLE,
254: p_start_date_actives IN JTF_DATE_TABLE,
255: p_end_date_actives IN JTF_DATE_TABLE,

Line 268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

264:
265: PROCEDURE Cut_And_Paste_Section
266: (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
270: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271: p_src_section_id IN NUMBER,
272: p_dst_parent_section_id IN NUMBER,

Line 269: p_commit IN VARCHAR2 := FND_API.G_FALSE,

265: PROCEDURE Cut_And_Paste_Section
266: (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
270: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271: p_src_section_id IN NUMBER,
272: p_dst_parent_section_id IN NUMBER,
273: x_return_status OUT NOCOPY VARCHAR2,

Line 270: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

266: (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
270: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271: p_src_section_id IN NUMBER,
272: p_dst_parent_section_id IN NUMBER,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,

Line 282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

278: --begin : added by abhandar :26 apr 2002 for Copy section with content reference
279: PROCEDURE Copy_Section_Ref_Content
280: (
281: p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: p_src_section_id IN NUMBER,
286: p_dst_parent_section_id IN NUMBER,

Line 283: p_commit IN VARCHAR2 := FND_API.G_FALSE,

279: PROCEDURE Copy_Section_Ref_Content
280: (
281: p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: p_src_section_id IN NUMBER,
286: p_dst_parent_section_id IN NUMBER,
287: x_new_src_section_id OUT NOCOPY NUMBER,

Line 284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

280: (
281: p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285: p_src_section_id IN NUMBER,
286: p_dst_parent_section_id IN NUMBER,
287: x_new_src_section_id OUT NOCOPY NUMBER,
288: x_return_status OUT NOCOPY VARCHAR2,

Line 337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

333:
334: -- For 11.5.10, Layout Components Map
335: PROCEDURE Update_Hierarchy_Layout_Map
336: (p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: p_section_id IN NUMBER,
341: p_layout_id IN NUMBER,

Line 338: p_commit IN VARCHAR2 := FND_API.G_FALSE,

334: -- For 11.5.10, Layout Components Map
335: PROCEDURE Update_Hierarchy_Layout_Map
336: (p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: p_section_id IN NUMBER,
341: p_layout_id IN NUMBER,
342: p_layout_comp_id IN JTF_NUMBER_TABLE,

Line 339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

335: PROCEDURE Update_Hierarchy_Layout_Map
336: (p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: p_section_id IN NUMBER,
341: p_layout_id IN NUMBER,
342: p_layout_comp_id IN JTF_NUMBER_TABLE,
343: p_layout_temp_id IN JTF_NUMBER_TABLE,

Line 356: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

352: );
353:
354: PROCEDURE Update_Section_Dlv_Ctx
355: (p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
357: p_commit IN VARCHAR2 := FND_API.G_FALSE,
358: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
359: p_section_id IN NUMBER,
360: p_deliverable_id IN NUMBER,

Line 357: p_commit IN VARCHAR2 := FND_API.G_FALSE,

353:
354: PROCEDURE Update_Section_Dlv_Ctx
355: (p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
357: p_commit IN VARCHAR2 := FND_API.G_FALSE,
358: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
359: p_section_id IN NUMBER,
360: p_deliverable_id IN NUMBER,
361: p_display_context_id IN NUMBER,

Line 358: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

354: PROCEDURE Update_Section_Dlv_Ctx
355: (p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
357: p_commit IN VARCHAR2 := FND_API.G_FALSE,
358: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
359: p_section_id IN NUMBER,
360: p_deliverable_id IN NUMBER,
361: p_display_context_id IN NUMBER,
362: p_object_version_number IN NUMBER,

Line 379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

375: );
376:
377: PROCEDURE Cascade_Layout_Comp_Mapping
378: (p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
381: p_source_section_id IN NUMBER,
382: p_target_section_id IN NUMBER,
383: x_return_status OUT NOCOPY VARCHAR2,

Line 380: p_commit IN VARCHAR2 := FND_API.G_FALSE,

376:
377: PROCEDURE Cascade_Layout_Comp_Mapping
378: (p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
381: p_source_section_id IN NUMBER,
382: p_target_section_id IN NUMBER,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,

Line 399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

395:
396:
397: PROCEDURE Associate_Items_To_Section(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: p_commit IN VARCHAR2 := FND_API.G_FALSE,
401: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
402: x_return_status OUT NOCOPY VARCHAR2,
403: x_msg_count OUT NOCOPY NUMBER,

Line 400: p_commit IN VARCHAR2 := FND_API.G_FALSE,

396:
397: PROCEDURE Associate_Items_To_Section(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: p_commit IN VARCHAR2 := FND_API.G_FALSE,
401: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
402: x_return_status OUT NOCOPY VARCHAR2,
403: x_msg_count OUT NOCOPY NUMBER,
404: x_msg_data OUT NOCOPY VARCHAR2,

Line 401: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

397: PROCEDURE Associate_Items_To_Section(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400: p_commit IN VARCHAR2 := FND_API.G_FALSE,
401: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
402: x_return_status OUT NOCOPY VARCHAR2,
403: x_msg_count OUT NOCOPY NUMBER,
404: x_msg_data OUT NOCOPY VARCHAR2,
405: p_section_id IN NUMBER,