eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_DSP_MSITE_SCT_SECT_PVT dependencies on FND_API

Line 31: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

27:
28: PROCEDURE update_row
29: (
30: p_mini_site_section_section_id IN NUMBER,
31: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
32: p_start_date_active IN DATE,
33: p_end_date_active IN DATE,
34: p_level_number IN NUMBER,
35: p_sort_order IN NUMBER,

Line 54: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

50: PROCEDURE load_row
51: (
52: p_owner IN VARCHAR2,
53: p_mini_site_section_section_id IN NUMBER,
54: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
55: p_mini_site_id IN NUMBER,
56: p_parent_section_id IN NUMBER,
57: p_child_section_id IN NUMBER,
58: p_start_date_active IN DATE,

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

66:
67: PROCEDURE Create_MSite_Section_Section
68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_mini_site_id IN NUMBER,
74: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

67: PROCEDURE Create_MSite_Section_Section
68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_mini_site_id IN NUMBER,
74: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_child_section_id IN NUMBER,

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

68: (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_mini_site_id IN NUMBER,
74: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_child_section_id IN NUMBER,
76: p_start_date_active IN DATE,

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

70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_mini_site_id IN NUMBER,
74: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_child_section_id IN NUMBER,
76: p_start_date_active IN DATE,
77: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
78: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

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

73: p_mini_site_id IN NUMBER,
74: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_child_section_id IN NUMBER,
76: p_start_date_active IN DATE,
77: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
78: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: x_mini_site_section_section_id OUT NOCOPY NUMBER,

Line 78: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

74: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_child_section_id IN NUMBER,
76: p_start_date_active IN DATE,
77: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
78: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: x_mini_site_section_section_id OUT NOCOPY NUMBER,
82: x_return_status OUT NOCOPY VARCHAR2,

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

75: p_child_section_id IN NUMBER,
76: p_start_date_active IN DATE,
77: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
78: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: x_mini_site_section_section_id OUT NOCOPY NUMBER,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,

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

76: p_start_date_active IN DATE,
77: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
78: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
79: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: x_mini_site_section_section_id OUT NOCOPY NUMBER,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2

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

86:
87: PROCEDURE Update_MSite_Section_Section
88: (
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_object_version_number IN NUMBER,

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

87: PROCEDURE Update_MSite_Section_Section
88: (
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_object_version_number IN NUMBER,
95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

88: (
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_object_version_number IN NUMBER,
95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

Line 93: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,

89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_object_version_number IN NUMBER,
95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

Line 95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_object_version_number IN NUMBER,
95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_object_version_number IN NUMBER,
95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
100: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

Line 97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

93: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
94: p_object_version_number IN NUMBER,
95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
100: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
101: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

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

94: p_object_version_number IN NUMBER,
95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
100: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
101: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
102: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

95: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
96: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
100: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
101: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
102: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: x_return_status OUT NOCOPY VARCHAR2,

Line 100: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

96: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
100: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
101: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
102: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,

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

97: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
100: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
101: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
102: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2

Line 102: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,

98: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
99: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
100: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
101: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
102: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2
106: );

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

107:
108: PROCEDURE Delete_MSite_Section_Section
109: (
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

108: PROCEDURE Delete_MSite_Section_Section
109: (
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

109: (
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

Line 114: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,

110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
118: x_return_status OUT NOCOPY VARCHAR2,

Line 115: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,

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

112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2

Line 117: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
115: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
116: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
117: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2
121: );

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

122:
123: PROCEDURE Update_MSite_Section_Sections
124: (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
130: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

123: PROCEDURE Update_MSite_Section_Sections
124: (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
130: p_object_version_numbers IN JTF_NUMBER_TABLE,
131: p_start_date_actives IN JTF_DATE_TABLE,

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

124: (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127: p_commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
130: p_object_version_numbers IN JTF_NUMBER_TABLE,
131: p_start_date_actives IN JTF_DATE_TABLE,
132: p_end_date_actives IN JTF_DATE_TABLE,

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

138:
139: PROCEDURE Update_Delete_Sct_Scts
140: (
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
146: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

139: PROCEDURE Update_Delete_Sct_Scts
140: (
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
146: p_object_version_numbers IN JTF_NUMBER_TABLE,
147: p_start_date_actives IN JTF_DATE_TABLE,

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

140: (
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
146: p_object_version_numbers IN JTF_NUMBER_TABLE,
147: p_start_date_actives IN JTF_DATE_TABLE,
148: p_end_date_actives IN JTF_DATE_TABLE,

Line 160: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

156: PROCEDURE LOAD_SEED_ROW
157: (
158: P_MINI_SITE_SECTION_SECTION_ID IN NUMBER,
159: P_OWNER IN VARCHAR2,
160: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
161: P_MINI_SITE_ID IN NUMBER,
162: P_PARENT_SECTION_ID IN NUMBER,
163: P_CHILD_SECTION_ID IN NUMBER,
164: P_START_DATE_ACTIVE IN VARCHAR2, --IN DATE,