DBA Data[Home] [Help]

APPS.AMS_CT_RULE_PUB dependencies on FND_API

Line 53: content_rule_id NUMBER := FND_API.G_MISS_NUM,

49:
50: --===================================================================
51: TYPE ct_rule_rec_type IS RECORD
52: (
53: content_rule_id NUMBER := FND_API.G_MISS_NUM,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_updated_date DATE := FND_API.G_MISS_DATE,

Line 54: created_by NUMBER := FND_API.G_MISS_NUM,

50: --===================================================================
51: TYPE ct_rule_rec_type IS RECORD
52: (
53: content_rule_id NUMBER := FND_API.G_MISS_NUM,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_updated_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 55: creation_date DATE := FND_API.G_MISS_DATE,

51: TYPE ct_rule_rec_type IS RECORD
52: (
53: content_rule_id NUMBER := FND_API.G_MISS_NUM,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_updated_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 56: last_updated_by NUMBER := FND_API.G_MISS_NUM,

52: (
53: content_rule_id NUMBER := FND_API.G_MISS_NUM,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_updated_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 57: last_updated_date DATE := FND_API.G_MISS_DATE,

53: content_rule_id NUMBER := FND_API.G_MISS_NUM,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_updated_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: object_id NUMBER := FND_API.G_MISS_NUM,

Line 58: last_update_login NUMBER := FND_API.G_MISS_NUM,

54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_updated_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: object_id NUMBER := FND_API.G_MISS_NUM,
62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 59: object_version_number NUMBER := FND_API.G_MISS_NUM,

55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_updated_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: object_id NUMBER := FND_API.G_MISS_NUM,
62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_updated_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: object_id NUMBER := FND_API.G_MISS_NUM,
62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,

Line 61: object_id NUMBER := FND_API.G_MISS_NUM,

57: last_updated_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: object_id NUMBER := FND_API.G_MISS_NUM,
62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,

58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: object_id NUMBER := FND_API.G_MISS_NUM,
62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,

59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: object_id NUMBER := FND_API.G_MISS_NUM,
62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,

60: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: object_id NUMBER := FND_API.G_MISS_NUM,
62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
68: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR--anchaudh

Line 65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

61: object_id NUMBER := FND_API.G_MISS_NUM,
62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
68: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR--anchaudh
69: );

Line 66: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

62: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
68: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR--anchaudh
69: );
70:

Line 67: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,

63: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
68: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR--anchaudh
69: );
70:
71: g_miss_ct_rule_rec ct_rule_rec_type;

Line 68: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR--anchaudh

64: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
68: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR--anchaudh
69: );
70:
71: g_miss_ct_rule_rec ct_rule_rec_type;
72: TYPE ct_rule_tbl_type IS TABLE OF ct_rule_rec_type INDEX BY BINARY_INTEGER;

Line 94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

90: -- Parameters
91: --
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_ct_rule_rec IN ct_rule_rec_type Required
97: --
98: -- OUT

Line 95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

91: --
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_ct_rule_rec IN ct_rule_rec_type Required
97: --
98: -- OUT
99: -- x_return_status OUT VARCHAR2

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

108: --
109:
110: PROCEDURE Create_Ct_Rule(
111: p_api_version_number IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,

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

109:
110: PROCEDURE Create_Ct_Rule(
111: p_api_version_number IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,

Line 136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

132: -- Parameters
133: --
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_ct_rule_rec IN ct_rule_rec_type Required
139: --
140: -- OUT

Line 137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

133: --
134: -- IN
135: -- p_api_version_number IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_ct_rule_rec IN ct_rule_rec_type Required
139: --
140: -- OUT
141: -- x_return_status OUT VARCHAR2

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

150: --
151:
152: PROCEDURE Update_Ct_Rule(
153: p_api_version_number IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,

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

151:
152: PROCEDURE Update_Ct_Rule(
153: p_api_version_number IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,

Line 178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

174: -- Parameters
175: --
176: -- IN
177: -- p_api_version_number IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180: -- p_CONTENT_RULE_ID IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --

Line 179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

175: --
176: -- IN
177: -- p_api_version_number IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180: -- p_CONTENT_RULE_ID IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --
183: -- OUT

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

193: --
194:
195: PROCEDURE Delete_Ct_Rule(
196: p_api_version_number IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,

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

194:
195: PROCEDURE Delete_Ct_Rule(
196: p_api_version_number IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_content_rule_id IN NUMBER,

Line 219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

215: -- Parameters
216: --
217: -- IN
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_ct_rule_rec IN ct_rule_rec_type Required
222: --
223: -- OUT

Line 220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

216: --
217: -- IN
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_ct_rule_rec IN ct_rule_rec_type Required
222: --
223: -- OUT
224: -- x_return_status OUT VARCHAR2

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

233: --
234:
235: PROCEDURE Lock_Ct_Rule(
236: p_api_version_number IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
241: