DBA Data[Home] [Help]

APPS.AMS_PS_STRATS_PUB dependencies on FND_API

Line 54: row_id ROWID := FND_API.G_MISS_CHAR,

50:
51: --===================================================================
52: TYPE ps_strats_rec_type IS RECORD
53: (
54: row_id ROWID := FND_API.G_MISS_CHAR,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,

Line 55: created_by NUMBER := FND_API.G_MISS_NUM,

51: --===================================================================
52: TYPE ps_strats_rec_type IS RECORD
53: (
54: row_id ROWID := FND_API.G_MISS_CHAR,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 56: creation_date DATE := FND_API.G_MISS_DATE,

52: TYPE ps_strats_rec_type IS RECORD
53: (
54: row_id ROWID := FND_API.G_MISS_CHAR,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 57: last_updated_by NUMBER := FND_API.G_MISS_NUM,

53: (
54: row_id ROWID := FND_API.G_MISS_CHAR,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 58: last_update_date DATE := FND_API.G_MISS_DATE,

54: row_id ROWID := FND_API.G_MISS_CHAR,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: strategy_id NUMBER := FND_API.G_MISS_NUM,

Line 59: last_update_login NUMBER := FND_API.G_MISS_NUM,

55: created_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: strategy_id NUMBER := FND_API.G_MISS_NUM,
63: max_returned NUMBER := FND_API.G_MISS_NUM,

Line 60: security_group_id NUMBER := FND_API.G_MISS_NUM,

56: creation_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: strategy_id NUMBER := FND_API.G_MISS_NUM,
63: max_returned NUMBER := FND_API.G_MISS_NUM,
64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 61: object_version_number NUMBER := FND_API.G_MISS_NUM,

57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: strategy_id NUMBER := FND_API.G_MISS_NUM,
63: max_returned NUMBER := FND_API.G_MISS_NUM,
64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 62: strategy_id NUMBER := FND_API.G_MISS_NUM,

58: last_update_date DATE := FND_API.G_MISS_DATE,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: strategy_id NUMBER := FND_API.G_MISS_NUM,
63: max_returned NUMBER := FND_API.G_MISS_NUM,
64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 63: max_returned NUMBER := FND_API.G_MISS_NUM,

59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: strategy_id NUMBER := FND_API.G_MISS_NUM,
63: max_returned NUMBER := FND_API.G_MISS_NUM,
64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,

Line 64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: strategy_id NUMBER := FND_API.G_MISS_NUM,
63: max_returned NUMBER := FND_API.G_MISS_NUM,
64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
68: strategy_name VARCHAR2(100) := FND_API.G_MISS_CHAR,

Line 65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: strategy_id NUMBER := FND_API.G_MISS_NUM,
63: max_returned NUMBER := FND_API.G_MISS_NUM,
64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
68: strategy_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
69: strategy_description VARCHAR2(1000) := FND_API.G_MISS_CHAR

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

62: strategy_id NUMBER := FND_API.G_MISS_NUM,
63: max_returned NUMBER := FND_API.G_MISS_NUM,
64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
68: strategy_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
69: strategy_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
70: );

Line 67: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,

63: max_returned NUMBER := FND_API.G_MISS_NUM,
64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
68: strategy_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
69: strategy_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
70: );
71:

Line 68: strategy_name VARCHAR2(100) := FND_API.G_MISS_CHAR,

64: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
68: strategy_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
69: strategy_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
70: );
71:
72: g_miss_ps_strats_rec ps_strats_rec_type;

Line 69: strategy_description VARCHAR2(1000) := FND_API.G_MISS_CHAR

65: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
68: strategy_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
69: strategy_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
70: );
71:
72: g_miss_ps_strats_rec ps_strats_rec_type;
73: TYPE ps_strats_tbl_type IS TABLE OF ps_strats_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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