[Home] [Help]
31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from FND_FLEXBUILDER_PARAMETERS
36: where APPLICATION_ID = X_APPLICATION_ID
37: and FUNCTION_CODE = X_FUNCTION_CODE
38: and SEQUENCE = X_SEQUENCE
39: and PARAMETER_NAME = X_PARAMETER_NAME
38: and SEQUENCE = X_SEQUENCE
39: and PARAMETER_NAME = X_PARAMETER_NAME
40: ;
41: begin
42: insert into FND_FLEXBUILDER_PARAMETERS (
43: APPLICATION_ID,
44: FUNCTION_CODE,
45: SEQUENCE,
46: PARAMETER_NAME,
187: ID_FLEX_NUM,
188: ID_PARAMETER,
189: OUTPUT_COLUMN,
190: SOURCE_PARAMETER
191: from FND_FLEXBUILDER_PARAMETERS
192: where APPLICATION_ID = X_APPLICATION_ID
193: and FUNCTION_CODE = X_FUNCTION_CODE
194: and SEQUENCE = X_SEQUENCE
195: and PARAMETER_NAME = X_PARAMETER_NAME
302: X_LAST_UPDATED_BY in NUMBER,
303: X_LAST_UPDATE_LOGIN in NUMBER
304: ) is
305: begin
306: update FND_FLEXBUILDER_PARAMETERS set
307: ASSIGNMENT_TYPE = X_ASSIGNMENT_TYPE,
308: PARAMETER_TYPE = X_PARAMETER_TYPE,
309: PROTECTED_FLAG = X_PROTECTED_FLAG,
310: DESCRIPTION = X_DESCRIPTION,
357: X_SEQUENCE in NUMBER,
358: X_PARAMETER_NAME in VARCHAR2
359: ) is
360: begin
361: delete from FND_FLEXBUILDER_PARAMETERS
362: where APPLICATION_ID = X_APPLICATION_ID
363: and FUNCTION_CODE = X_FUNCTION_CODE
364: and SEQUENCE = X_SEQUENCE
365: and PARAMETER_NAME = X_PARAMETER_NAME;
390:
391: delete from FND_FLEXBUILDER_PARAMS_TL T
392: where not exists
393: (select NULL
394: from FND_FLEXBUILDER_PARAMETERS B
395: where B.APPLICATION_ID = T.APPLICATION_ID
396: and B.FUNCTION_CODE = T.FUNCTION_CODE
397: and B.SEQUENCE = T.SEQUENCE
398: and B.PARAMETER_NAME = T.PARAMETER_NAME