19: -- the sequence.
20: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
21: -- Raise exception for invalid flag.
22: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
23: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
24: ---------------------------------------------------------------------
25: PROCEDURE create_listentry(
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
23: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
24: ---------------------------------------------------------------------
25: PROCEDURE create_listentry(
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
28: p_commit IN VARCHAR2 := FND_API.g_false,
29: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
30:
31: x_return_status OUT NOCOPY VARCHAR2,
24: ---------------------------------------------------------------------
25: PROCEDURE create_listentry(
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
28: p_commit IN VARCHAR2 := FND_API.g_false,
29: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
30:
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
25: PROCEDURE create_listentry(
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
28: p_commit IN VARCHAR2 := FND_API.g_false,
29: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
30:
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,
46: -- p_entry_rec: the record with new items
47: --
48: -- NOTES
49: -- 1. Raise exception if the object_version_number doesn't match.
50: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
51: -- that column won't be updated.
52: ----------------------------------------------------------------------
53: PROCEDURE update_listentry(
54: p_api_version IN NUMBER,
51: -- that column won't be updated.
52: ----------------------------------------------------------------------
53: PROCEDURE update_listentry(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
56: p_commit IN VARCHAR2 := FND_API.g_false,
57: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
58:
59: x_return_status OUT NOCOPY VARCHAR2,
52: ----------------------------------------------------------------------
53: PROCEDURE update_listentry(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
56: p_commit IN VARCHAR2 := FND_API.g_false,
57: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
58:
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
53: PROCEDURE update_listentry(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
56: p_commit IN VARCHAR2 := FND_API.g_false,
57: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
58:
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
78: -- 1. Raise exception if the object_version_number doesn't match.
79: --------------------------------------------------------------------
80: PROCEDURE delete_listentry(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85:
86: x_return_status OUT NOCOPY VARCHAR2,
79: --------------------------------------------------------------------
80: PROCEDURE delete_listentry(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85:
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
80: PROCEDURE delete_listentry(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85:
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
106: -- 1. Raise exception if the object_version_number doesn't match.
107: --------------------------------------------------------------------
108: PROCEDURE lock_listentry(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
111: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
112:
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
107: --------------------------------------------------------------------
108: PROCEDURE lock_listentry(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
111: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
112:
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
129: -- p_camp_rec: the listentry record to be validated
130: --
131: -- NOTES
132: -- 1. p_entry_rec should be the complete campaign record. There
133: -- should not be any FND_API.g_miss_char/num/date in it.
134: ----------------------------------------------------------------------
135: PROCEDURE validate_listentry(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
133: -- should not be any FND_API.g_miss_char/num/date in it.
134: ----------------------------------------------------------------------
135: PROCEDURE validate_listentry(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
138: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
139:
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
134: ----------------------------------------------------------------------
135: PROCEDURE validate_listentry(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
138: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
139:
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
150: -- PROCEDURE
151: -- init_entry_rec
152: --
153: -- PURPOSE
154: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
155: ---------------------------------------------------------------------
156: PROCEDURE init_entry_rec(
157: x_entry_rec OUT NOCOPY AMS_LISTENTRY_PVT.entry_rec_type
158: );