123: (
124: P_ENTITY_NAME IN VARCHAR2,
125: P_ENTITY_KEY IN VARCHAR2,
126: P_ENTITY_DISPLAYNAME IN VARCHAR2,
127: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
128: P_MODE IN VARCHAR2,
129: P_CONTEXT_PARAMETER_NAMES IN FND_TABLE_OF_VARCHAR2_255,
130: P_CONTEXT_PARAMETER_VALUES IN FND_TABLE_OF_VARCHAR2_255,
131: P_CURR_INSTRUCTION_PROCESS_ID IN NUMBER DEFAULT NULL,
125: P_ENTITY_KEY IN VARCHAR2,
126: P_ENTITY_DISPLAYNAME IN VARCHAR2,
127: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
128: P_MODE IN VARCHAR2,
129: P_CONTEXT_PARAMETER_NAMES IN FND_TABLE_OF_VARCHAR2_255,
130: P_CONTEXT_PARAMETER_VALUES IN FND_TABLE_OF_VARCHAR2_255,
131: P_CURR_INSTRUCTION_PROCESS_ID IN NUMBER DEFAULT NULL,
132: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER
133: )
126: P_ENTITY_DISPLAYNAME IN VARCHAR2,
127: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
128: P_MODE IN VARCHAR2,
129: P_CONTEXT_PARAMETER_NAMES IN FND_TABLE_OF_VARCHAR2_255,
130: P_CONTEXT_PARAMETER_VALUES IN FND_TABLE_OF_VARCHAR2_255,
131: P_CURR_INSTRUCTION_PROCESS_ID IN NUMBER DEFAULT NULL,
132: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER
133: )
134:
134:
135: IS
136:
137:
138: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
139:
140: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
141:
142: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
136:
137:
138: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
139:
140: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
141:
142: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
143:
144:
138: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
139:
140: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
141:
142: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
143:
144:
145: L_RETURN_STATUS VARCHAR2(10);
146: L_MSG_COUNT NUMBER;
155:
156: BEGIN
157:
158: --Initialize the the entity names array containing only one element.
159: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
160: L_ENTITY_NAME.EXTEND;
161:
162: --Initialize the the entity keys array containing only one element.
163: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
159: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
160: L_ENTITY_NAME.EXTEND;
161:
162: --Initialize the the entity keys array containing only one element.
163: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
164: L_ENTITY_KEY.EXTEND;
165:
166: --Initialize the the entity display name array containing only one element.
167: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
163: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
164: L_ENTITY_KEY.EXTEND;
165:
166: --Initialize the the entity display name array containing only one element.
167: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
168: L_ENTITY_DISPLAYNAME.EXTEND;
169:
170: --Set the entity name, key and display name values.
171: L_ENTITY_NAME(1) := P_ENTITY_NAME;
241: P_INSTRUCTION_PROCESS_ID IN NUMBER,
242: P_ENTITY_NAME IN VARCHAR2,
243: P_ENTITY_KEY IN VARCHAR2,
244: P_ENTITY_DISPLAYNAME IN VARCHAR2,
245: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
246: P_CONTEXT_PARAMETER_NAMES IN FND_TABLE_OF_VARCHAR2_255,
247: P_CONTEXT_PARAMETER_VALUES IN FND_TABLE_OF_VARCHAR2_255
248: )
249:
242: P_ENTITY_NAME IN VARCHAR2,
243: P_ENTITY_KEY IN VARCHAR2,
244: P_ENTITY_DISPLAYNAME IN VARCHAR2,
245: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
246: P_CONTEXT_PARAMETER_NAMES IN FND_TABLE_OF_VARCHAR2_255,
247: P_CONTEXT_PARAMETER_VALUES IN FND_TABLE_OF_VARCHAR2_255
248: )
249:
250: IS
243: P_ENTITY_KEY IN VARCHAR2,
244: P_ENTITY_DISPLAYNAME IN VARCHAR2,
245: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
246: P_CONTEXT_PARAMETER_NAMES IN FND_TABLE_OF_VARCHAR2_255,
247: P_CONTEXT_PARAMETER_VALUES IN FND_TABLE_OF_VARCHAR2_255
248: )
249:
250: IS
251:
248: )
249:
250: IS
251:
252: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
253:
254: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
255:
256: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
250: IS
251:
252: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
253:
254: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
255:
256: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
257:
258:
252: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
253:
254: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
255:
256: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
257:
258:
259: L_RETURN_STATUS VARCHAR2(10);
260: L_MSG_COUNT NUMBER;
271:
272: BEGIN
273:
274: --Initialize the the entity names array containing only one element.
275: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
276: L_ENTITY_NAME.EXTEND;
277:
278: --Initialize the the entity keys array containing only one element.
279: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
275: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
276: L_ENTITY_NAME.EXTEND;
277:
278: --Initialize the the entity keys array containing only one element.
279: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
280: L_ENTITY_KEY.EXTEND;
281:
282: --Initialize the the entity display name array containing only one element.
283: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
279: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
280: L_ENTITY_KEY.EXTEND;
281:
282: --Initialize the the entity display name array containing only one element.
283: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
284: L_ENTITY_DISPLAYNAME.EXTEND;
285:
286: --Set the entity name, key and display name values.
287: L_ENTITY_NAME(1) := P_ENTITY_NAME;