[Home] [Help]
102: p_EXECUTION_MODE IN VARCHAR2,
103: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
104: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
105: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
106: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
107: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
108: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
109: p_EMAIL_ENABLED IN VARCHAR2,
110: p_RESTRICTED_FLAG IN VARCHAR2,
328: p_EXECUTION_MODE IN VARCHAR2,
329: p_VARIABLE_NAME IN CSM_VARCHAR_LIST,
330: p_VARIABLE_TYPE IN CSM_VARCHAR_LIST,
331: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
332: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
333: p_HIDDEN_FLAG IN CSM_VARCHAR_LIST,
334: p_DEFAULT_FLAG IN CSM_VARCHAR_LIST,
335: p_EMAIL_ENABLED IN VARCHAR2,
336: p_RESTRICTED_FLAG IN VARCHAR2,
892: l_PROCEDURE_NAME VARCHAR2(255);
893: l_procedure_stmt VARCHAR2(32767);
894: l_variable_id_lst CSM_INTEGER_LIST;
895: l_var_value_char_lst CSM_VARCHAR_LIST;
896: l_var_value_date_lst CSM_DATE_LIST;
897: l_var_type_lst CSM_VARCHAR_LIST;
898: l_var_name_lst CSM_VARCHAR_LIST;
899: l_return_status VARCHAR2(4000);
900: l_return_message VARCHAR2(4000);
1181: p_INSTANCE_ID IN VARCHAR2 DEFAULT NULL,
1182: p_INSTANCE_NAME IN VARCHAR2,
1183: p_VARIABLE_ID IN CSM_INTEGER_LIST,
1184: p_VARIABLE_VALUE_CHAR IN CSM_VARCHAR_LIST,
1185: p_VARIABLE_VALUE_DATE IN CSM_DATE_LIST,
1186: p_commit IN VARCHAR2 DEFAULT fnd_api.G_TRUE,
1187: x_INSTANCE_ID OUT NOCOPY NUMBER,
1188: x_return_status OUT NOCOPY VARCHAR2,
1189: x_error_message OUT NOCOPY VARCHAR2
1223: FROM DUAL;
1224:
1225: l_variable_id_lst CSM_INTEGER_LIST;
1226: l_var_value_char_lst CSM_VARCHAR_LIST;
1227: l_var_value_date_lst CSM_DATE_LIST;
1228: l_var_type_lst CSM_VARCHAR_LIST;
1229: l_query_id NUMBER;
1230: l_variable_cnt NUMBER;
1231: l_ins_variable_cnt NUMBER;