35: -- Version Initial version number = 1.0
36: -- History Current version number = 1.0
37: --=======================================================
38: procedure CREATE_FLOW (
39: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40: p_api_version_number IN NUMBER,
41: p_init_msg_tbl IN BOOLEAN := FALSE,
42: p_msg_count OUT NOCOPY NUMBER,
43: p_msg_data OUT NOCOPY VARCHAR2,
43: p_msg_data OUT NOCOPY VARCHAR2,
44: p_return_status OUT NOCOPY VARCHAR2,
45: p_flow_application_id IN NUMBER,
46: p_flow_code IN VARCHAR2,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_return_status OUT NOCOPY VARCHAR2,
45: p_flow_application_id IN NUMBER,
46: p_flow_code IN VARCHAR2,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_flow_application_id IN NUMBER,
46: p_flow_code IN VARCHAR2,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_flow_code IN VARCHAR2,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_name IN VARCHAR2,
56: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_name IN VARCHAR2,
64: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_name IN VARCHAR2,
64: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
58: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_name IN VARCHAR2,
64: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
60: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_name IN VARCHAR2,
64: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
61: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_name IN VARCHAR2,
64: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
62: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_name IN VARCHAR2,
64: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
70: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
63: p_name IN VARCHAR2,
64: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
70: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
71: p_pass IN NUMBER,
64: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
70: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
71: p_pass IN NUMBER,
72: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
65: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
70: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
71: p_pass IN NUMBER,
72: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
73: );
66: p_creation_date IN DATE := FND_API.G_MISS_DATE,
67: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
70: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
71: p_pass IN NUMBER,
72: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
73: );
74:
102: -- Version Initial version number = 1.0
103: -- History Current version number = 1.0
104: --=======================================================
105: procedure CREATE_PAGE (
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107: p_api_version_number IN NUMBER,
108: p_init_msg_tbl IN BOOLEAN := FALSE,
109: p_msg_count OUT NOCOPY NUMBER,
110: p_msg_data OUT NOCOPY VARCHAR2,
112: p_flow_application_id IN NUMBER,
113: p_flow_code IN VARCHAR2,
114: p_page_application_id IN NUMBER,
115: p_page_code IN VARCHAR2,
116: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_flow_code IN VARCHAR2,
114: p_page_application_id IN NUMBER,
115: p_page_code IN VARCHAR2,
116: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_page_application_id IN NUMBER,
115: p_page_code IN VARCHAR2,
116: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_page_code IN VARCHAR2,
116: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_name IN VARCHAR2,
125: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_name IN VARCHAR2,
133: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_name IN VARCHAR2,
133: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_name IN VARCHAR2,
133: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
129: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_name IN VARCHAR2,
133: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
136: p_creation_date IN DATE := FND_API.G_MISS_DATE,
137: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
130: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_name IN VARCHAR2,
133: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
136: p_creation_date IN DATE := FND_API.G_MISS_DATE,
137: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
138: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
131: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_name IN VARCHAR2,
133: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
136: p_creation_date IN DATE := FND_API.G_MISS_DATE,
137: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
138: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
139: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
132: p_name IN VARCHAR2,
133: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
136: p_creation_date IN DATE := FND_API.G_MISS_DATE,
137: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
138: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
139: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
140: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
133: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
136: p_creation_date IN DATE := FND_API.G_MISS_DATE,
137: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
138: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
139: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
140: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
141: p_pass IN NUMBER,
134: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
136: p_creation_date IN DATE := FND_API.G_MISS_DATE,
137: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
138: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
139: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
140: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
141: p_pass IN NUMBER,
142: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
135: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
136: p_creation_date IN DATE := FND_API.G_MISS_DATE,
137: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
138: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
139: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
140: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
141: p_pass IN NUMBER,
142: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
143: );
136: p_creation_date IN DATE := FND_API.G_MISS_DATE,
137: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
138: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
139: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
140: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
141: p_pass IN NUMBER,
142: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
143: );
144:
170: -- Version Initial version number = 1.0
171: -- History Current version number = 1.0
172: --=======================================================
173: procedure CREATE_PAGE_REGION (
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: p_api_version_number IN NUMBER,
176: p_init_msg_tbl IN BOOLEAN := FALSE,
177: p_msg_count OUT NOCOPY NUMBER,
178: p_msg_data OUT NOCOPY VARCHAR2,
182: p_page_application_id IN NUMBER,
183: p_page_code IN VARCHAR2,
184: p_region_application_id IN NUMBER,
185: p_region_code IN VARCHAR2,
186: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
187: p_region_style IN VARCHAR2,
188: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
189: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
184: p_region_application_id IN NUMBER,
185: p_region_code IN VARCHAR2,
186: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
187: p_region_style IN VARCHAR2,
188: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
189: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
191: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_region_code IN VARCHAR2,
186: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
187: p_region_style IN VARCHAR2,
188: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
189: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
191: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
187: p_region_style IN VARCHAR2,
188: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
189: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
191: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_region_style IN VARCHAR2,
188: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
189: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
191: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
189: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
191: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
191: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
191: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
203: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
204: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
205: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
213: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
206: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
213: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
214: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
207: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
213: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
214: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
215: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
208: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
213: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
214: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
215: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
216: p_pass IN NUMBER,
209: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
213: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
214: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
215: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
216: p_pass IN NUMBER,
217: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
210: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
213: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
214: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
215: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
216: p_pass IN NUMBER,
217: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
218: );
211: p_creation_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
213: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
214: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
215: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
216: p_pass IN NUMBER,
217: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
218: );
219:
242: -- Version Initial version number = 1.0
243: -- History Current version number = 1.0
244: --=======================================================
245: procedure CREATE_PAGE_REGION_ITEM (
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: p_api_version_number IN NUMBER,
248: p_init_msg_tbl IN BOOLEAN := FALSE,
249: p_msg_count OUT NOCOPY NUMBER,
250: p_msg_data OUT NOCOPY VARCHAR2,
256: p_region_application_id IN NUMBER,
257: p_region_code IN VARCHAR2,
258: p_attribute_application_id IN NUMBER,
259: p_attribute_code IN VARCHAR2,
260: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
261: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
263: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_region_code IN VARCHAR2,
258: p_attribute_application_id IN NUMBER,
259: p_attribute_code IN VARCHAR2,
260: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
261: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
263: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute_application_id IN NUMBER,
259: p_attribute_code IN VARCHAR2,
260: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
261: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
263: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute_code IN VARCHAR2,
260: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
261: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
263: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
261: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
263: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
263: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
263: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
273: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
274: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
282: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
275: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
282: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
283: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
276: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
282: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
283: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
284: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
277: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
282: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
283: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
284: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
285: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
278: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
282: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
283: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
284: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
285: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
286: p_pass IN NUMBER,
279: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
282: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
283: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
284: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
285: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
286: p_pass IN NUMBER,
287: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
280: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
282: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
283: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
284: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
285: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
286: p_pass IN NUMBER,
287: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
288: );
281: p_creation_date IN DATE := FND_API.G_MISS_DATE,
282: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
283: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
284: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
285: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
286: p_pass IN NUMBER,
287: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
288: );
289:
312: -- Version Initial version number = 1.0
313: -- History Current version number = 1.0
314: --=======================================================
315: procedure CREATE_REGION_RELATION (
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: p_api_version_number IN NUMBER,
318: p_init_msg_tbl IN BOOLEAN := FALSE,
319: p_msg_count OUT NOCOPY NUMBER,
320: p_msg_data OUT NOCOPY VARCHAR2,
330: p_to_page_code IN VARCHAR2,
331: p_to_region_appl_id IN NUMBER,
332: p_to_region_code IN VARCHAR2,
333: p_application_id IN NUMBER,
334: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
331: p_to_region_appl_id IN NUMBER,
332: p_to_region_code IN VARCHAR2,
333: p_application_id IN NUMBER,
334: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_to_region_code IN VARCHAR2,
333: p_application_id IN NUMBER,
334: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_application_id IN NUMBER,
334: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
334: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
343: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
344: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
352: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
345: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
352: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
353: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
346: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
352: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
353: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
354: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
347: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
352: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
353: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
354: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
355: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
348: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
352: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
353: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
354: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
355: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
356: p_pass IN NUMBER,
349: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
352: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
353: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
354: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
355: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
356: p_pass IN NUMBER,
357: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
350: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
352: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
353: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
354: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
355: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
356: p_pass IN NUMBER,
357: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
358: );
351: p_creation_date IN DATE := FND_API.G_MISS_DATE,
352: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
353: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
354: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
355: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
356: p_pass IN NUMBER,
357: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
358: );
359:
383: -- Version Initial version number = 1.0
384: -- History Current version number = 1.0
385: --=======================================================
386: procedure DELETE_FLOW (
387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
388: p_api_version_number IN NUMBER,
389: p_init_msg_tbl IN BOOLEAN := FALSE,
390: p_msg_count OUT NOCOPY NUMBER,
391: p_msg_data OUT NOCOPY VARCHAR2,
423: -- Version Initial version number = 1.0
424: -- History Current version number = 1.0
425: --=======================================================
426: procedure DELETE_PAGE (
427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
428: p_api_version_number IN NUMBER,
429: p_init_msg_tbl IN BOOLEAN := FALSE,
430: p_msg_count OUT NOCOPY NUMBER,
431: p_msg_data OUT NOCOPY VARCHAR2,
467: -- Version Initial version number = 1.0
468: -- History Current version number = 1.0
469: --=======================================================
470: procedure DELETE_PAGE_REGION (
471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472: p_api_version_number IN NUMBER,
473: p_init_msg_tbl IN BOOLEAN := FALSE,
474: p_msg_count OUT NOCOPY NUMBER,
475: p_msg_data OUT NOCOPY VARCHAR2,
515: -- Version Initial version number = 1.0
516: -- History Current version number = 1.0
517: --=======================================================
518: procedure DELETE_PAGE_REGION_ITEM (
519: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
520: p_api_version_number IN NUMBER,
521: p_init_msg_tbl IN BOOLEAN := FALSE,
522: p_msg_count OUT NOCOPY NUMBER,
523: p_msg_data OUT NOCOPY VARCHAR2,
568: -- Version Initial version number = 1.0
569: -- History Current version number = 1.0
570: --=======================================================
571: procedure DELETE_REGION_RELATION (
572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573: p_api_version_number IN NUMBER,
574: p_init_msg_tbl IN BOOLEAN := FALSE,
575: p_msg_count OUT NOCOPY NUMBER,
576: p_msg_data OUT NOCOPY VARCHAR2,
783: -- Version Initial version number = 1.0
784: -- History Current version number = 1.0
785: --=======================================================
786: procedure UPDATE_FLOW (
787: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
788: p_api_version_number IN NUMBER,
789: p_init_msg_tbl IN BOOLEAN := FALSE,
790: p_msg_count OUT NOCOPY NUMBER,
791: p_msg_data OUT NOCOPY VARCHAR2,
791: p_msg_data OUT NOCOPY VARCHAR2,
792: p_return_status OUT NOCOPY VARCHAR2,
793: p_flow_application_id IN NUMBER,
794: p_flow_code IN VARCHAR2,
795: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
796: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
797: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_return_status OUT NOCOPY VARCHAR2,
793: p_flow_application_id IN NUMBER,
794: p_flow_code IN VARCHAR2,
795: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
796: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
797: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_flow_application_id IN NUMBER,
794: p_flow_code IN VARCHAR2,
795: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
796: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
797: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_flow_code IN VARCHAR2,
795: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
796: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
797: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
796: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
797: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
797: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
797: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
808: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
809: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
817: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
810: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
817: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
818: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
811: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
817: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
818: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
819: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
812: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
817: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
818: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
819: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
820: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
813: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
817: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
818: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
819: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
820: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
821: p_pass IN NUMBER,
814: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
817: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
818: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
819: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
820: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
821: p_pass IN NUMBER,
822: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
815: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
817: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
818: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
819: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
820: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
821: p_pass IN NUMBER,
822: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
823: );
816: p_creation_date IN DATE := FND_API.G_MISS_DATE,
817: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
818: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
819: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
820: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
821: p_pass IN NUMBER,
822: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
823: );
824:
848: -- Version Initial version number = 1.0
849: -- History Current version number = 1.0
850: --=======================================================
851: procedure UPDATE_PAGE (
852: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
853: p_api_version_number IN NUMBER,
854: p_init_msg_tbl IN BOOLEAN := FALSE,
855: p_msg_count OUT NOCOPY NUMBER,
856: p_msg_data OUT NOCOPY VARCHAR2,
858: p_flow_application_id IN NUMBER,
859: p_flow_code IN VARCHAR2,
860: p_page_application_id IN NUMBER,
861: p_page_code IN VARCHAR2,
862: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
863: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
859: p_flow_code IN VARCHAR2,
860: p_page_application_id IN NUMBER,
861: p_page_code IN VARCHAR2,
862: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
863: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
860: p_page_application_id IN NUMBER,
861: p_page_code IN VARCHAR2,
862: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
863: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
861: p_page_code IN VARCHAR2,
862: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
863: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
862: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
863: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
863: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
864: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
874: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
876: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
877: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
885: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
878: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
885: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
886: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
879: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
885: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
886: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
887: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
880: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
885: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
886: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
887: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
888: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
881: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
885: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
886: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
887: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
888: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
889: p_pass IN NUMBER,
882: p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
885: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
886: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
887: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
888: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
889: p_pass IN NUMBER,
890: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
883: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
885: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
886: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
887: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
888: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
889: p_pass IN NUMBER,
890: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
891: );
884: p_creation_date IN DATE := FND_API.G_MISS_DATE,
885: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
886: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
887: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
888: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
889: p_pass IN NUMBER,
890: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
891: );
892:
916: -- Version Initial version number = 1.0
917: -- History Current version number = 1.0
918: --=======================================================
919: procedure UPDATE_PAGE_REGION (
920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921: p_api_version_number IN NUMBER,
922: p_init_msg_tbl IN BOOLEAN := FALSE,
923: p_msg_count OUT NOCOPY NUMBER,
924: p_msg_data OUT NOCOPY VARCHAR2,
928: p_page_application_id IN NUMBER,
929: p_page_code IN VARCHAR2,
930: p_region_application_id IN NUMBER,
931: p_region_code IN VARCHAR2,
932: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
933: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
934: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
935: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
929: p_page_code IN VARCHAR2,
930: p_region_application_id IN NUMBER,
931: p_region_code IN VARCHAR2,
932: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
933: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
934: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
935: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_region_application_id IN NUMBER,
931: p_region_code IN VARCHAR2,
932: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
933: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
934: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
935: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
931: p_region_code IN VARCHAR2,
932: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
933: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
934: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
935: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
932: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
933: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
934: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
935: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
933: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
934: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
935: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
934: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
935: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
935: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
937: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
938: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
949: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
950: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
958: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
951: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
958: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
959: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
952: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
958: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
959: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
960: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
953: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
958: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
959: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
960: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
961: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
954: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
958: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
959: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
960: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
961: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
962: p_pass IN NUMBER,
955: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
958: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
959: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
960: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
961: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
962: p_pass IN NUMBER,
963: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
956: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
958: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
959: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
960: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
961: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
962: p_pass IN NUMBER,
963: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
964: );
957: p_creation_date IN DATE := FND_API.G_MISS_DATE,
958: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
959: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
960: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
961: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
962: p_pass IN NUMBER,
963: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
964: );
965:
987: -- Version Initial version number = 1.0
988: -- History Current version number = 1.0
989: --=======================================================
990: procedure UPDATE_PAGE_REGION_ITEM (
991: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
992: p_api_version_number IN NUMBER,
993: p_init_msg_tbl IN BOOLEAN := FALSE,
994: p_msg_count OUT NOCOPY NUMBER,
995: p_msg_data OUT NOCOPY VARCHAR2,
1001: p_region_application_id IN NUMBER,
1002: p_region_code IN VARCHAR2,
1003: p_attribute_application_id IN NUMBER,
1004: p_attribute_code IN VARCHAR2,
1005: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1006: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1008: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1002: p_region_code IN VARCHAR2,
1003: p_attribute_application_id IN NUMBER,
1004: p_attribute_code IN VARCHAR2,
1005: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1006: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1008: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003: p_attribute_application_id IN NUMBER,
1004: p_attribute_code IN VARCHAR2,
1005: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1006: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1008: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1004: p_attribute_code IN VARCHAR2,
1005: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1006: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1008: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1005: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1006: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1008: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1008: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1008: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1008: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1018: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1019: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1020: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1028: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1021: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1028: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1029: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1022: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1028: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1029: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1030: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1023: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1028: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1029: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1030: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1031: p_pass IN NUMBER,
1024: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1028: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1029: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1030: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1031: p_pass IN NUMBER,
1032: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1025: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1028: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1029: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1030: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1031: p_pass IN NUMBER,
1032: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1033: );
1026: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1028: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1029: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1030: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1031: p_pass IN NUMBER,
1032: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1033: );
1034:
1056: -- Version Initial version number = 1.0
1057: -- History Current version number = 1.0
1058: --=======================================================
1059: procedure UPDATE_REGION_RELATION (
1060: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1061: p_api_version_number IN NUMBER,
1062: p_init_msg_tbl IN BOOLEAN := FALSE,
1063: p_msg_count OUT NOCOPY NUMBER,
1064: p_msg_data OUT NOCOPY VARCHAR2,
1073: p_to_page_appl_id IN NUMBER,
1074: p_to_page_code IN VARCHAR2,
1075: p_to_region_appl_id IN NUMBER,
1076: p_to_region_code IN VARCHAR2,
1077: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1078: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1074: p_to_page_code IN VARCHAR2,
1075: p_to_region_appl_id IN NUMBER,
1076: p_to_region_code IN VARCHAR2,
1077: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1078: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1075: p_to_region_appl_id IN NUMBER,
1076: p_to_region_code IN VARCHAR2,
1077: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1078: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1076: p_to_region_code IN VARCHAR2,
1077: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1078: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1077: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1078: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1078: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1087: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1088: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1089: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1097: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1090: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1097: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1098: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1091: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1097: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1098: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1099: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1092: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1097: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1098: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1099: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1100: p_pass IN NUMBER,
1093: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1097: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1098: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1099: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1100: p_pass IN NUMBER,
1101: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1094: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1097: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1098: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1099: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1100: p_pass IN NUMBER,
1101: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1102: );
1095: p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1097: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1098: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1099: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1100: p_pass IN NUMBER,
1101: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1102: );
1103: