APPS.IBE_DSP_HIERARCHY_SETUP_PUB dependencies on FND_API

Line 14: parent_section_id NUMBER := FND_API.G_MISS_NUM,

10: */
11:
12: -- section record type
13: TYPE SECTION_REC_TYPE IS RECORD (
14: parent_section_id NUMBER := FND_API.G_MISS_NUM,
15: parent_section_access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
16: access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
17: start_date_active DATE,
18: end_date_active DATE := FND_API.G_MISS_DATE,

Line 15: parent_section_access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,

11:
12: -- section record type
13: TYPE SECTION_REC_TYPE IS RECORD (
14: parent_section_id NUMBER := FND_API.G_MISS_NUM,
15: parent_section_access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
16: access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
17: start_date_active DATE,
18: end_date_active DATE := FND_API.G_MISS_DATE,
19: section_type_code VARCHAR2(30),

Line 16: access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,

12: -- section record type
13: TYPE SECTION_REC_TYPE IS RECORD (
14: parent_section_id NUMBER := FND_API.G_MISS_NUM,
15: parent_section_access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
16: access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
17: start_date_active DATE,
18: end_date_active DATE := FND_API.G_MISS_DATE,
19: section_type_code VARCHAR2(30),
20: status_code VARCHAR2(30),

Line 18: end_date_active DATE := FND_API.G_MISS_DATE,

14: parent_section_id NUMBER := FND_API.G_MISS_NUM,
15: parent_section_access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
16: access_name VARCHAR2(240):= FND_API.G_MISS_CHAR,
17: start_date_active DATE,
18: end_date_active DATE := FND_API.G_MISS_DATE,
19: section_type_code VARCHAR2(30),
20: status_code VARCHAR2(30),
21: display_name VARCHAR2(120),
22: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 22: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

18: end_date_active DATE := FND_API.G_MISS_DATE,
19: section_type_code VARCHAR2(30),
20: status_code VARCHAR2(30),
21: display_name VARCHAR2(120),
22: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: long_description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
24: keywords VARCHAR2(1000):= FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 23: long_description VARCHAR2(4000):= FND_API.G_MISS_CHAR,

19: section_type_code VARCHAR2(30),
20: status_code VARCHAR2(30),
21: display_name VARCHAR2(120),
22: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: long_description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
24: keywords VARCHAR2(1000):= FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 24: keywords VARCHAR2(1000):= FND_API.G_MISS_CHAR,

20: status_code VARCHAR2(30),
21: display_name VARCHAR2(120),
22: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: long_description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
24: keywords VARCHAR2(1000):= FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,

21: display_name VARCHAR2(120),
22: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: long_description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
24: keywords VARCHAR2(1000):= FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

22: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
23: long_description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
24: keywords VARCHAR2(1000):= FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

23: long_description VARCHAR2(4000):= FND_API.G_MISS_CHAR,
24: keywords VARCHAR2(1000):= FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

24: keywords VARCHAR2(1000):= FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

25: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: );

Line 38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: );
42:

Line 39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: );
42:
43: /*#

Line 40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: );
42:
43: /*#
44: * Creates a section with Configurable Layout

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

69: * @rep:displayname Create Section
70: */
71: PROCEDURE Create_Section(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,

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

70: */
71: PROCEDURE Create_Section(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
78: p_hierachy_section_rec IN SECTION_REC_TYPE,

Line 84: section_item_id NUMBER :=FND_API.G_MISS_NUM,

80:
81:
82: -- Section Item record type
83: TYPE SECTION_ITEM_REC_TYPE IS RECORD (
84: section_item_id NUMBER :=FND_API.G_MISS_NUM,
85: section_id NUMBER :=FND_API.G_MISS_NUM,
86: inventory_item_id NUMBER,
87: organization_id NUMBER,
88: start_date_active DATE,

Line 85: section_id NUMBER :=FND_API.G_MISS_NUM,

81:
82: -- Section Item record type
83: TYPE SECTION_ITEM_REC_TYPE IS RECORD (
84: section_item_id NUMBER :=FND_API.G_MISS_NUM,
85: section_id NUMBER :=FND_API.G_MISS_NUM,
86: inventory_item_id NUMBER,
87: organization_id NUMBER,
88: start_date_active DATE,
89: end_date_active DATE := FND_API.G_MISS_DATE,

Line 89: end_date_active DATE := FND_API.G_MISS_DATE,

85: section_id NUMBER :=FND_API.G_MISS_NUM,
86: inventory_item_id NUMBER,
87: organization_id NUMBER,
88: start_date_active DATE,
89: end_date_active DATE := FND_API.G_MISS_DATE,
90: sort_order NUMBER := FND_API.G_MISS_NUM,
91: association_reason_code VARCHAR2(300) := FND_API.G_MISS_CHAR
92: );
93:

Line 90: sort_order NUMBER := FND_API.G_MISS_NUM,

86: inventory_item_id NUMBER,
87: organization_id NUMBER,
88: start_date_active DATE,
89: end_date_active DATE := FND_API.G_MISS_DATE,
90: sort_order NUMBER := FND_API.G_MISS_NUM,
91: association_reason_code VARCHAR2(300) := FND_API.G_MISS_CHAR
92: );
93:
94:

Line 91: association_reason_code VARCHAR2(300) := FND_API.G_MISS_CHAR

87: organization_id NUMBER,
88: start_date_active DATE,
89: end_date_active DATE := FND_API.G_MISS_DATE,
90: sort_order NUMBER := FND_API.G_MISS_NUM,
91: association_reason_code VARCHAR2(300) := FND_API.G_MISS_CHAR
92: );
93:
94:
95: TYPE SECTION_ITEM_TBL_TYPE IS TABLE OF SECTION_ITEM_REC_TYPE

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

135: * @rep:displayname Section Item Association
136: */
137: PROCEDURE Create_Section_Items(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,

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

136: */
137: PROCEDURE Create_Section_Items(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_section_id IN NUMBER,

Line 221: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

217: * @rep:displayname Create Object Logical Content
218: */
219: PROCEDURE Create_Object_Logical_Content (
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
222: p_commit IN VARCHAR2 := FND_API.g_false,
223: p_object_type IN VARCHAR2,
224: p_obj_lgl_ctnt_tbl IN OBJ_LGL_CTNT_TBL_TYPE,
225: x_return_status OUT NOCOPY VARCHAR2,

Line 222: p_commit IN VARCHAR2 := FND_API.g_false,

218: */
219: PROCEDURE Create_Object_Logical_Content (
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
222: p_commit IN VARCHAR2 := FND_API.g_false,
223: p_object_type IN VARCHAR2,
224: p_obj_lgl_ctnt_tbl IN OBJ_LGL_CTNT_TBL_TYPE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,