DBA Data[Home] [Help]

APPS.JTF_DSP_MSITE_SCT_SECT_PVT dependencies on FND_API

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

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

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

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

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

61:
62: PROCEDURE Create_MSite_Section_Section
63: (
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

62: PROCEDURE Create_MSite_Section_Section
63: (
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,

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

63: (
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,

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

65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

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

68: p_mini_site_id IN NUMBER,
69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_mini_site_section_section_id OUT NUMBER,

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

69: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_mini_site_section_section_id OUT NUMBER,
77: x_return_status OUT VARCHAR2,

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

70: p_child_section_id IN NUMBER,
71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_mini_site_section_section_id OUT NUMBER,
77: x_return_status OUT VARCHAR2,
78: x_msg_count OUT NUMBER,

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

71: p_start_date_active IN DATE,
72: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
73: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
74: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
75: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: x_mini_site_section_section_id OUT NUMBER,
77: x_return_status OUT VARCHAR2,
78: x_msg_count OUT NUMBER,
79: x_msg_data OUT VARCHAR2

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

81:
82: PROCEDURE Update_MSite_Section_Section
83: (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,

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

82: PROCEDURE Update_MSite_Section_Section
83: (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

83: (
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

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

88: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

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

89: p_object_version_number IN NUMBER,
90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

90: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: x_return_status OUT VARCHAR2,

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

91: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: x_return_status OUT VARCHAR2,
99: x_msg_count OUT NUMBER,

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

92: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: x_return_status OUT VARCHAR2,
99: x_msg_count OUT NUMBER,
100: x_msg_data OUT VARCHAR2

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

93: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
94: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
95: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
96: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
97: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: x_return_status OUT VARCHAR2,
99: x_msg_count OUT NUMBER,
100: x_msg_data OUT VARCHAR2
101: );

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

102:
103: PROCEDURE Delete_MSite_Section_Section
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

103: PROCEDURE Delete_MSite_Section_Section
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: x_return_status OUT VARCHAR2,

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

106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: x_return_status OUT VARCHAR2,
114: x_msg_count OUT NUMBER,

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

107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: x_return_status OUT VARCHAR2,
114: x_msg_count OUT NUMBER,
115: x_msg_data OUT VARCHAR2

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

108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
110: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
113: x_return_status OUT VARCHAR2,
114: x_msg_count OUT NUMBER,
115: x_msg_data OUT VARCHAR2
116: );

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

117:
118: PROCEDURE Update_MSite_Section_Sections
119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
125: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

118: PROCEDURE Update_MSite_Section_Sections
119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
125: p_object_version_numbers IN JTF_NUMBER_TABLE,
126: p_start_date_actives IN JTF_DATE_TABLE,

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

119: (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
125: p_object_version_numbers IN JTF_NUMBER_TABLE,
126: p_start_date_actives IN JTF_DATE_TABLE,
127: p_end_date_actives IN JTF_DATE_TABLE,

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

133:
134: PROCEDURE Update_Delete_Sct_Scts
135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
141: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

134: PROCEDURE Update_Delete_Sct_Scts
135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
141: p_object_version_numbers IN JTF_NUMBER_TABLE,
142: p_start_date_actives IN JTF_DATE_TABLE,

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

135: (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
141: p_object_version_numbers IN JTF_NUMBER_TABLE,
142: p_start_date_actives IN JTF_DATE_TABLE,
143: p_end_date_actives IN JTF_DATE_TABLE,