DBA Data[Home] [Help]

APPS.AMS_PS_CNDCLSES_PUB dependencies on FND_API

Line 53: row_id ROWID := FND_API.G_MISS_CHAR,

49:
50: --===================================================================
51: TYPE ps_cndclses_rec_type IS RECORD
52: (
53: row_id ROWID := FND_API.G_MISS_CHAR,
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_update_date DATE := FND_API.G_MISS_DATE,

Line 54: created_by NUMBER := FND_API.G_MISS_NUM,

50: --===================================================================
51: TYPE ps_cndclses_rec_type IS RECORD
52: (
53: row_id ROWID := FND_API.G_MISS_CHAR,
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_update_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 ps_cndclses_rec_type IS RECORD
52: (
53: row_id ROWID := FND_API.G_MISS_CHAR,
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_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 56: last_updated_by NUMBER := FND_API.G_MISS_NUM,

52: (
53: row_id ROWID := FND_API.G_MISS_CHAR,
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_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 57: last_update_date DATE := FND_API.G_MISS_DATE,

53: row_id ROWID := FND_API.G_MISS_CHAR,
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_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: cnd_clause_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_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 59: security_group_id 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_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 60: object_version_number NUMBER := FND_API.G_MISS_NUM,

56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,

57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,

58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: cnd_clause_name VARCHAR2(100) := FND_API.G_MISS_CHAR,

Line 63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

59: security_group_id NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: cnd_clause_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
67: cnd_clause_description VARCHAR2(1000) := FND_API.G_MISS_CHAR

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

60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: cnd_clause_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
67: cnd_clause_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
68: );

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

61: cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: cnd_clause_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
67: cnd_clause_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
68: );
69:

Line 66: cnd_clause_name VARCHAR2(100) := FND_API.G_MISS_CHAR,

62: cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: cnd_clause_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
67: cnd_clause_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
68: );
69:
70: g_miss_ps_cndclses_rec ps_cndclses_rec_type;

Line 67: cnd_clause_description VARCHAR2(1000) := FND_API.G_MISS_CHAR

63: cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: cnd_clause_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
67: cnd_clause_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
68: );
69:
70: g_miss_ps_cndclses_rec ps_cndclses_rec_type;
71: TYPE ps_cndclses_tbl_type IS TABLE OF ps_cndclses_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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